Restrict which records update a Google calendar event?

Hey all,

I have an Airtable set up former employees returning hardware to the company. It’s based on a form where they select whether they will drop-off their hardware in person or ship it to the building. I set up an automation where if they select drop-off, they select a day and time and an event is created on a shared Google calendar. I am working on another automation that adds a member of the IT team as an attendee on each event when they are assigned in Airtable, and it works perfectly for the drop-off records. However, I assign IT team members to all records, not just drop-offs, and when I assign out a non-drop-off ticket I get a ‘failed automation’ notice. Is there a way to tell Airtable to only update records that have ‘Drop-off’ selected, and not update for records with ‘Ship to HQ’ selected?

This depends on what triggers the automation.

It will probably work best, if the automation is triggered by “When record matches conditions” and you set one of the conditions as status is drop-off.

An alternative would be to create a view that contains all the drop-offs and then trigger the automation via “When record enters view”.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.