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). The new Zap can now trigger for each address individually.To the best of my knowledge, NOTHING can track changes/updates to records other than Airtable itself. Finally, create a second Zap with your original workflow to trigger off each new record in the new table. When this Zap runs, it will leave you with three new records on the new table, each with the primary field being the email address you’re searching for. This won’t work if it’s not comma-separated :slightly_smiling_face: Not sure if there’s a more elegant solution, but if you have an extra Zap to spare, you could use two to accomplish this.Īdd a new table that’s linked to the table which includes your form view. When the Interaction form is submitted for more than one linked record at a time, that lookup field says something like a stab in the dark, I tried this for a Search Formula:Īny ideas or tips on how can I write this search fomula?Īlternatively, any idea on how I can tell Zapier to ignore those error messages and NOT shut down my Zap when it fails to find multiple people?
The Interactions table field I’m currently using in Step 2 to match with records in the Contacts table is a an Airtable Lookup field of the email address from the Contacts table.
SEARCH BY CUSTOM VALUE ZAPIER AIRTABLE YOUTUBE UPDATE
Is there a way I can use a Search Formula for “Step 2: Find Record in Airtable” so it finds multiple records to update in Step 3? After a bunch of error messages, Zapier shuts down the Zap, and then the Zap doesn’t even work for one-at-a-time updates, until I log in and turn the Zap back on again. When this happens, the Zap trips an error message (even if the Progress field wasn’t updated). The problem is, users often fill out the Interaction form to apply updates to multiple Contacts at the same time (using linked field). Those new rows appear whenever a user fills out an Interactions Form.
Following the two tutorials on setting up Zapier, I’ve successfully gotten a Zapier Zap working to update a “Progress” field within the primary “Contacts” table whenever a new row appears in the “Interactions” table.
0 kommentar(er)
