Help

Zapier trigger for updated record or all records

Topic Labels: Views
32594 69
cancel
Showing results for 
Search instead for 
Did you mean: 
Christopher_Bis
5 - Automation Enthusiast
5 - Automation Enthusiast

Love the Zapier integration, but without the ability to trigger on update/change/edit of a field, it’s pretty hard to keep other databases synced with Airtable - not sure if this my mistake or not.

Additionally, I can’t move my system across to Airtable without the above feature or the option to run a Zapier zap on all database entires in a view/base. For example, if I want to email all my contacts, I can’t do that via Mail-Chimp etc, because the triggers only fire on creation of a record not on update/change/manual selection.

Can you advise any workaround because this is one of only two barriers to me moving a client to your platform.

69 Replies 69
Jason_Laster
4 - Data Explorer
4 - Data Explorer

I’m also looking into github + zapier integration. I was able to import new issues into airtable, but i cannot find a good way to update the airtable row when the issue closes in github.

@NickPunt I’m curious if you found a work around here. I’m thinking about setting up a probot for this too…

Oli_Steadman
7 - App Architect
7 - App Architect

Please please can we have this

Daniel_Payne
4 - Data Explorer
4 - Data Explorer

I would like to add this to the feature request roadmap too.

Shreya_Bhutra
5 - Automation Enthusiast
5 - Automation Enthusiast

Bump. Need trigger with update record

William_Nutt
6 - Interface Innovator
6 - Interface Innovator

Desperately need a Zapier trigger when a record is updated!

Airtable says in their api documentation that this is coming:

Here are a few things that we’ll expose in the API shortly:

  1. Transparently creating new multiple choice options when you update records.

  2. Querying for recent changes.

  3. Receiving notifications about changed records.

Nick_Threapleto
4 - Data Explorer
4 - Data Explorer

Seconding this. Right now it’s almost impossible to replicate your airtable into another database.

One solution I’ve found is using this sheets plugin to replicate data to sheets https://chrome.google.com/webstore/detail/airtable-importer-by-rail/kngidnifbonbaembhpnjlpeefhmjpegb

then syncing that data into our DB with an ETL tool like stitch. This works but is unreliable and insecure. Please add webhooks soon Airtable team!

Sara_Larsen
4 - Data Explorer
4 - Data Explorer

I also need to replicate just a portion of my Airtable into another database, and would love to see a trigger on updates. Thanks!

Roman_Scher
6 - Interface Innovator
6 - Interface Innovator

Our current method of reacting to changes in records is to use what we call “event trigger” views. Each one of these views has some filters set, so that when a record matches some criteria, it enters the view, we pick it up using the Airtable API, take some action like posting a notification to Slack, then update the record so that it is removed from the view.

To do this, we keep a central table called “Event Triggers”. Each record in this table has the url for an event trigger view, and a Zapier webhook to call to take action when a record is found in that view. We then have a perpetually running python process on AWS poll the Event Triggers table every so often to get this list of views, and check each view for records to take action on.

To remove the records from the view after processing them, sometimes we mark the records with timestamps and have our event trigger view filter on whether those timestamps are filled in or not. You can also use what I call “mirror” fields, which mirror the value of another field. When a field is updated, if it does not equal its mirror field, the record enters the event trigger view. Then, after processing the record, you set the mirror field to the actual field’s value once more to mark it as processed and remove it from the view.

Gary_M
4 - Data Explorer
4 - Data Explorer

Another mighty +1 for being able to trigger all records in a view, or trigger for updated records of a view.