Jun 01, 2020 07:57 AM
I’d to send selected records in Airtable to Zapier in order to push the record’s data to another platform.
Ideally, the user could select one or multiple records in a table view, click Run on the script block, and the process would occur.
Can anybody point me in the right direction on where to get started?
Jun 02, 2020 01:02 AM
Hi @Nick_Bergthold1 - you might not even need a script to get this process to work. With Zapier you can trigger a Zap with “new record in a view”, so, potentially, you could construct a view that captures the data when certain conditions are met. If you really want to be explicit about it, you could create an additional checkbox field “Send to Zapier” and the view is constructed around this, i.e. filtered where the checkbox is checked. This would put specific records in the view and Zapier will pick this up.
Will that work in your scenario?
Jun 02, 2020 06:25 AM
No, this won’t work, there’s more to the script than just this action. I’m just wondering how this particular part would work, if it’s possible.
Jun 02, 2020 06:52 AM
Jun 02, 2020 08:36 AM
But, you could very easily trigger a Zapier webhook on a record-by-record basis.
Just create a formula field that results in a. URL — you would combine the “catch hook URL” that Zapier gives you, along with the record ID of your record. You can get that using the formula
Then, whenever your users click on that URL for that record, it will trigger the zap.
Yes, the downside to this is that your users will get taken to a blank tab in their web browser which confirms the action, but they could just close that tab and come back to Airtable.
Otherwise, as @JonathanBowen mentioned above, I would just use the built-in triggers of Zapier (and even better, Integromat) to handle this. Then you don’t need to worry about webhooks or scripts at all.
The Airtable trigger functionality is already natively built into Zapier and Integromat!
(Although Zapier’s functionality is extremely limited without the On2Air Actions plug-in, so we tend to steer people towards Integromat if they have the apps you’re looking for.)
p.s. When you have found your answer, please mark one of the comments in this thread as the solution to your question. This will help other people who are searching the forum with similar questions in the future. :slightly_smiling_face:
Jun 02, 2020 10:06 AM
@ScottWorld, his requirements apparently preclude the black-boxiness of running a Zap.
Yes, indeed this is easy, but it is an incomplete solution for this guest because there’s apparently other logic that needs to be considered.