Skip to main content

Hi, 

I'm new to automations on Airtable and am facing an unusual error:

"Name is "foo", Invalid filter on Email (Invalid choice name or id: foo@bar.baz)"

My "Find records" step has two conditions (OR), attempting to match on "Name" or "Email".

Here you can see a successful test, when a match is found:

It is also successful when no match is found, BUT when only "name" is used, and not both name and email, finding 0 results (expected behaviour).

 

 

BUT when adding the email condition bac, when there are no matches, it gives the error:

 

This seems like a bug to me, can you advise? Thanks!!

Could you provide a read only invite link to the base with some example data?  It's difficult to help you with this without access to the automation itself

Could you provide a read only invite link to the base with some example data?  It's difficult to help you with this without access to the automation itself


Of course, thank you!

I created a new base, with two tables and a very simple automation to look up the email only. It's worth mentioning that the email field in the "Find records" table is a multi-value field. 

Trigger: new record in Table 2

Find records: from Table 1, multi-email field (multiple select field)

When a matching record exists (correct behaviour):

 

When no matches exist (error - expected "no records"):

Table 1 (to look up records from):

Table 2 

Will send you a DM with a link to the base. Thank you!!

 

Of course, thank you!

I created a new base, with two tables and a very simple automation to look up the email only. It's worth mentioning that the email field in the "Find records" table is a multi-value field. 

Trigger: new record in Table 2

Find records: from Table 1, multi-email field (multiple select field)

When a matching record exists (correct behaviour):

 

When no matches exist (error - expected "no records"):

Table 1 (to look up records from):

Table 2 

Will send you a DM with a link to the base. Thank you!!

 


I got the invite, thanks!  I think this is happening because when we try to do a "has any of" condition in a multiselect it expects us to pass it a select option instead of text

As a workaround, I created a formula field to output the multiselect options as text and used that in the condition and it seemed to do what you need!


Link to base

 

I got the invite, thanks!  I think this is happening because when we try to do a "has any of" condition in a multiselect it expects us to pass it a select option instead of text

As a workaround, I created a formula field to output the multiselect options as text and used that in the condition and it seemed to do what you need!


Link to base

 


Thanks a lot, that works!!

Reply


Terms & Conditions