Is there a way to have a button on the interface run a script or automation to export data to a csv? If it can be done with a script please advise on the script code needed. Thank you in advance.
In the meantime, I have several of my clients automatically exporting CSV files on a daily basis with Make.
Note that this isn’t a straightforward “Export To CSV” functionality. It’s a 3-step process:
Thank you for the response. It is easier to just go into the base and export to csv than use Make or Zapier. The reason I want the button is so a user that just access the interface could export as well. Hopefully a scripting guru has an answer.
If anyone does have a solution to this, I am also after the same thing - I want to use AirTable’s button to either run a webhook/create a CSV Export of the particular Table View that the interface is showing.
The reason we don’t have to use the extra clicks in the Base to ‘download CSV’, is we want Interface only users to be able to click the button from Interface Designer.
Here are a few thoughts about buttons, interfaces, and creating a CSV file.
I understand the first two points. I’m hoping that AirTable soon extends the functionality of Interfaces where users CANT access the entire base. We currently have users who never need to see the base, they’re ‘interface only users’ as matter of convenience as you say. But we would also reallllly like to share interfaces with users who should not be able to access the base. So hopefully this is in the roadmap.
On your other points about the data change in the base (after the button is clicked) actually doing the triggering - I’ll look into that. Then yes, using 3rd party automation (Make/Integromat in our case) to create the CSV.
Will likely work as a workaround - still would like to see a native ‘print’ & ‘export’ button in Interfaces.
I don't know if it is still an issues for you but I have found a solution that allows you to have a button that download a view to CSV !
I am using the tool https://csv-getter-for-airtable.vercel.app/ that create a link that automatically download the view you want when you run the link in your web browser. By selecting the cols, you can select what fields you want to export. Then, in your interface, you can create a button that trigger an external URL and you set the URL created by csv getter !
I hope it will help !
You can now do it with Excel-Exporter. There is a freemium version and a premium version with a 7 day free trial. You can also ask them custom tools if you have a very specific need. It's a third party app that you can find on the marketplace of airtable and it does 100% of what you ask. Moreover, the data of your export don't go through any server, so it's pretty safe.