Zapier trigger for updated record or all records

[Christopher_Bis]

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.

[Jeff_Frazier]

So this isn’t a perfect solution, but I do have a manual workaround that actually worked out better for a given use case.

In my office we were wanting to use AirTable to store and centralize contact information and link it to various other records. We would be constantly adding information to records as we found out people’s cell phone numbers and additional email addresses etc. That makes it slightly risky to auto sync and update the information as someone could accidentally delete some information and clear it our of our database.

The workaround was to set the trigger to be a button push. Air table would then search for any record with “Yes” in the field “Ready for Update?”. It would update the contact information in the first record with Yes in that fields to google contacts, then after it updates it looks back for that same field (using the main ID# we use as a key to identify it) and updates the Yes to “Updated” and puts the timestamp of the button press into another field for records.

You do have to press the button once for each record you update, but it will work every time you press it, and it can repeated any number of times.

I know its not quite automated, but when its something as vital as contact information, it can sometimes be best to have a physical trigger to make sure that things don’t trigger improperly.

[Delali_Dzirasa]

@openside is a short trial available to test this out?

[openside]

Hi @Delali_Dzirasa @Nick_Duda (sorry I missed your post from a few months ago. never got a notification).

We offer a full refund in first 14 days if it doesn’t work out for you. Just reach out to our community site and submit a ticket and it will be refunded.

Thanks!

[Dylan_Sather1]

Hi y’all,

I’ve setup webhooks for new records and record updates using a combination of Airtable’s Slack notifications and Pipedream (think Zapier, but optimized for webhooks). It’s similar to the solution some of y’all have described, using Slack as a way to get record updates, but it’s also free.

End-to-end, If you add a new record to a base, you’ll get a webhook out with a JSON payload sent to a custom HTTP endpoint for that update:

[
  {
    "tableId": "tbl98fitgvmmAR8aX",
    "recordId": "recltHKU7vKAv7bhW",
    "updates": [
      {
        "field": "Name",
        "newValue": "NEW RECORD"
      },
      {
        "field": "Status",
        "newValue": "CLOSED"
      }
    ]
  }
]

I documented the setup in a Medium post:

https://medium.com/@dylan.sather/airtable-webhooks-with-slack-pipedream-8a394a763fa9

and this Pipedream pipeline:

https://pipedream.com/@dylburger/airtable-slack-messages-webhook-p_wOCgpB

(apologies for the formatting, the Community site wouldn’t let me include any direct links in this post)

I’d love feedback on whether this helps solve anyone’s issues getting webhook notifications for record creation / updates.

Feel free to personally reach out if you need help getting it working — more than happy to help.

Dylan

[Steve_Singleton]

Airtable team, how we coming on this?

[JulianStrong]

This fuctionality is soooo needed. It’s been over 3 years and still nothing…

@Airtable_Ops @Airtable_Team Can you please look at this?

[Samuel_Willhite]

It’s a lot simpler than that. To re trigger on an event, simply right click the line that you want to trigger again. Select duplicate. Delete the first line. That new line has a new record ID and will trigger once more to do the same function with zapier.

[Istvan_Gergely_]

Sure, but this method is totally manual, we need soemthing that can run totally automatized.

[L_Team]

Its now 10/29/2019… any progress Airtable?

[Megan_Tanner]

@Airtable, @Airtable_Ops

48 replies & 9.4k views and nearly 4 years without a single response.

Triggering upon record update is a vital feature that nearly every other app offers.

Please make this happen.