I’m using FM19. As long as the data file could be pulled into a filemaker database, that would be enough. I just need a legit backup if AirT ever went away that I could pull into Filemaker or similar.
This confidential e-mail message, including any attachments, is for the sole use of the intended recipient(s) only. This e-mail may contain privileged and confidential matter. If you have received this e-mail in error, please notify the sender immediately by replying to this e-mail. This e-mail may not be forwarded, posted or disclosed to anyone without prior approval from its author. Any dissemination, distribution or copying of this e-mail is strictly prohibited.
If the format is not FM19 and exported in a manner that includes all relational elements, links, lookups, option lists, etc – it will not be easy to re-instantiate in FileMaker Pro in a timely fashion.
Given that your current Airtable solution likely uses formula fields, linked fields, lookup fields, views with grouping, filters and sorts - all of these configuration aspects will be lost in the event of a catastrophic failure. And this list doesn’t even include Airtable automations or glue-factory processes like you may be using from Zapier or Integromat.
I suspect that your definition of “minimal downtime” probably doesn’t include weeks or months to recover. This event - should it ever occur - would be devastating to most businesses.
These are the risks that accompany a platform that tends to fragment your business logic spreading it around a very shallow gene pool. I wrote about this challenge in “Airtable Backup & Recovery Strategies: Simply, a Nightmare”.
Sorry for a relatively downbeat Saturday rant, but there’s nothing positive I can say about this topic unless the backup process reflects the true footprint of a solution.
I was asking specifically about the FM19 export format to see if you had considered all of these backup and recovery nuances. FileMaker Pro can, of course, do everything Airtable does, but transforming an Airtable solution into a FileMaker solution is a very big lift.
One last comment. I built a custom backup/recovery system for an Airtable client in Europe but I would never do it again. It is difficult, costly, prone to errors, and unlikely to ever meet the true requirements. This is why – in my view – you might want to consider Pro Backup; it will get you as close as possible in a financially practical manner.
I would suggest Integromat for backup purposes.
You could probably use a Webhook and Airtable’s API. It could be setup so that when you add or make record changes, it can backup to the Integromat scenario in real-time.
Just a suggestion, hope it helps.