Help

Re: Find records error: Name is "foo", Invalid filter on Email (Invalid choice name or id:

Solved
Jump to Solution
232 2
cancel
Showing results for 
Search instead for 
Did you mean: 
fibibam
5 - Automation Enthusiast
5 - Automation Enthusiast

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:

fibibam_0-1714498514319.png

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).

fibibam_1-1714498579172.png

 

 

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

fibibam_2-1714498605354.png

 

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

1 Solution

Accepted Solutions

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!

Screenshot 2024-05-03 at 10.41.26 AM.png

Screenshot 2024-05-03 at 10.41.32 AM.png
Link to base

 

See Solution in Thread

4 Replies 4

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):

 

fibibam_1-1714670314679.png

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

fibibam_2-1714670418865.png

Table 1 (to look up records from):

fibibam_3-1714670492455.png

Table 2 

fibibam_4-1714670582141.png

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!

Screenshot 2024-05-03 at 10.41.26 AM.png

Screenshot 2024-05-03 at 10.41.32 AM.png
Link to base

 

Thanks a lot, that works!!