Oct 16, 2020 11:23 AM
Here’s my thinking. I like the simplicity of Airtable’s own “Export CSV” function. Data in a spreadsheet as a simple backup is all I am after.
If “Export CSV” could be triggered via a script, the entire process could be automated. A new record could be the trigger to run this script.
Does anyone know if this is even possible?
Oct 24, 2020 12:17 AM
@Markus_Wernig This could be made possible with an Airtable App with a few options like whether you want the ids or resolve the relationships instead.
Still gotta be done, but that could be a great way of making it available for everyone, and for free.
May 25, 2021 09:29 AM
Yes to the CSV, It really should be a simple trigger, or even a googlesheets function, which you can kind of work into by playing the triggers that execute when all fields that have are no blank. Not ideal, but it can kind of work.
Ideally a secondary CSV back-up nightly automation is needed.
Further, a airtable file, that supports records IDs etc would be most appreciated.
Oct 21, 2021 02:57 AM
For anyone wanting live csv export by api endpoint, here is an endpoint i built:
Details can be found here
Apr 07, 2022 11:59 AM
Oct 05, 2022 02:02 AM
This is amazing! Thanks so much :slightly_smiling_face:
Oct 20, 2022 12:59 AM
So, I changed my mind and eventually build a “print-base-structure” airtable app. Then, I use a diff tool to compare the generated output, and it allows me to see what structural differences there are between two bases.
btw, within script extension you can work across the tables of one base, you probably know but do you have any recommendation of how to export or create a new table from a list of records re-arranged and coming from different tables ?