Button to copy data to Excel doc

[SunLynx]

My Airtable has purchase order data, and I need to be able to present a single page, multi line PO for records and vendors. I have an excel doc that will “make it pretty” for me, as long as the data is present.

If I was the user I would just copy/paste, Save As and move on. The person who needs the PO is very computer illiterate, so I need a print button or similar to “make it go”.

All I need is to copy the data from a specific view into the Excel doc (preferably a blank master doc) and then either have it automatically Save As or at least pop up the Excel program so Save As can be done manually.

Since this is an instant trigger I don’t think I can use Zapier/Integromat for it. I know that there is a script on here for pulling data into a power query (sorry, am on mobile. link later), but that seems to be button in Excel doc, not button in Airtable.

Is it possible/effective to try a script? Is there something else I don’t even know is an option?

Thanks for the help.

[ScottWorld · Accepted solution]

SunLynx:

I don’t think I can use Zapier/Integromat for it.

Yes, you can do this with Integromat. Just create a checkbox or button or script in Airtable that triggers your scenario.

[SunLynx]

Thanks for the help @ScottWorld. Now I just have to figure out how to get the results from Integromat…I really wish they had a community accessible to anyone (meaning not exclusively on Facebook, as a private group).

[ScottWorld]

Yeah, it is odd that their community is on Facebook. They have good tech support, though. And if you have a budget for this project and you’d like to hire a top Integromat expert & Airtable consultant to help you, please feel free to contact me through my website at ScottWorld.com.

[Anna_Gogol]

I think you can use Coupler.io to export the data from Airtable to Excel automatically. It is a data integration software, which allows its users to extract the data from multiple apps, including Airtable to 3 supported destinations: Excel, GoogleSheets or BigQuery automatically on a desired schedule.  

Here is an Airtable to Excel Integration link where you can learn more details of how to use Coupler.io and what capabilities it has.

Coupler.io also supports data stitching feature which enables its users to extract and merge the data from different sources into one single destination.

Coupler.io offers a free 14 days test-drive, so you can try out the system to check if it fits your needs.