![]() 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. This automation ensures that your spreadsheets stay accurate and current, saving you time. Whenever a new or updated record is detected in Airtable, it will seamlessly update the corresponding row in your selected Google Sheets spreadsheet. When a field is updated, if it does not equal its mirror field, the record enters the event trigger view. Keep your Google Sheets up-to-date with the latest data from Airtable by using this efficient workflow. You can also use what I call “mirror” fields, which mirror the value of another field. 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. ![]() 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. ![]() 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. Triggers when a Card is updated in Trello. Save time and boost productivity by streamlining your processes with this simple yet powerful automation. To do this, we keep a central table called “Event Triggers”. When you update a card in Trello, the associated record in Airtable will be updated automatically, ensuring your team always has access to the most up-to-date information. This Zap lets you customize your workflow by automatically updating a record in your Airtable base whenever a new webhook request is received at a specified. 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. Our current method of reacting to changes in records is to use what we call “event trigger” views.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |