![]() ![]() I’d love feedback on whether this helps solve anyone’s issues getting webhook notifications for record creation / updates.įeel free to personally reach out if you need help getting it working - more than happy to help. I documented the setup in a Medium post: this Pipedream pipeline: for the formatting, the Community site wouldn’t let me include any direct links in this post) 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.Įnd-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: [ With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end Check out the following list of triggers and actions you can use with Freshdesk, Airtable, and Mailchimp. ![]() 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). Do even more with Freshdesk + Airtable + Mailchimp. 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. With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end Check out the following list of triggers and actions you can use with Zoom, Airtable, and Mailchimp. 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. Do even more with Zoom + Airtable + Mailchimp. 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. Air table would then search for any record with “Yes” in the field “Ready for Update?”. The workaround was to set the trigger to be a button push. 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. We would be constantly adding information to records as we found out people’s cell phone numbers and additional email addresses etc. In my office we were wanting to use AirTable to store and centralize contact information and link it to various other records. But still, I WISH we could have some simple things like “date modified”, field/table/base metadata, and filters by related record VALUE (not just related record ID).So this isn’t a perfect solution, but I do have a manual workaround that actually worked out better for a given use case. And to be fair, they’ve owned this from the start (I’m actually rather impressed by the clarity of their vision/roadmap). ![]() I totally get it as their business model is clearly focused on monetizing the front-end UI and features (blocks, colors, etc). The biggest gotcha is ensuring that if your request (or requests in the case of batches) returns anything OTHER than a 200 HTTP response code, you cleanly exit rather than syncing an empty response (this has happened to me and it is unfortunate).Īirtable continues to double-down on NOT being a proper backend for data-they are fully invested in their front-end and have let all of us API users nibble on the meager crumbs they throw our way. The only way I’ve managed (sane) syncs is by:įetching all records from a table (usually in batches), creating a hash using specific fields, comparing that hash to a cached value associate with that record ID, and only THEN can my script tell if that record has changed. Zapier doesn’t have a “trigger” for Airtable updates (just new records) and the API (as you know) doesn’t expose date modified (only date created). With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end Check out the following list of triggers and actions you can use with Mailchimp, Airtable, and LiveChat. With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end Check out the following list of triggers and actions you can use with Mailchimp, Microsoft Outlook, and Airtable. To the best of my knowledge, NOTHING can track changes/updates to records other than Airtable itself. Do even more with Mailchimp + Airtable + LiveChat. Do even more with Mailchimp + Microsoft Outlook + Airtable.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |