Google Calendar automation - attendees no nested options
Hi all,
I'm trying to setup an automation that updates a record when an events is scheduled that matches users in the database to confirm that they scheduled and when. I can do this with Zapier but I'm trying to do it directly in Airtable.
The main problem is that I need to use Attendees to Find a Record where e-mail contains "guest email" but this field is grayed out and says "No valid nested options".
Any ideas / suggestions?
@SorinPetrov @Selimafifi @Tomas_T
I got stuck on a similar problem and found both the explanation and solution to it. I'm late in the game, but this might help you guys out for future automations.
If you’re getting the tooltip ‘No valid nested option’ when trying to select a field as a condition in an automation, that's because the data type of the selected field and the data type of the populated value do not match.
To understand why this happens, it’s useful to know that Airtable processes linked records and lookups as arrays, even when the cell contains only 1 element (in that case, Airtable treats it as a 1-item array). This means you’re trying to have [string = array] as a condition, which Airtable considers as impossible.
The workaround to that is to create a formula field that references the linked record or lookup. This new field will display the original value, but will convert the array into a string. You can select this newly created field as a condition in your Find Records module.
