Mar 31, 2022 09:12 AM
I am running into a wall with this automation, hoping someone knows what I’m doing wrong.
When a record in my Events table matches a condition, I am trying to build a Find a Record automation that finds a record in my Main Directory table where email in Main Directory is email in Events. I am getting an invalid filter error on my email field. Not sure what I’m doing wrong here. Ultimately I would like to update the retrieved record with data from Events, but I can’t get beyond the filter error.
Jul 12, 2023 06:29 AM - edited Jul 17, 2023 12:54 PM
Hello, same issue either with an email formatted field, or text type field, or fomula. Any idea @airtable-team ?
This is really blocking for basic feature. OR should make it match with first condition / but it stopped
Aug 22, 2023 07:02 PM
Hey @Kamille_Parks any chance you could please assist with this problem that these latest comments are about is slightly different to the problem you initially provided a solution for?
I and many others also seem to be facing this issue. Let me know if you need any other info but this is the error code we are facing "invalid filter on "field name" (Invalid filter value: null)"
Thanks in advance for your assistance in advance and for everything else you do for this community, your comments on other issues have saved me and others many hours of headaches!
Darcy
Oct 06, 2023 05:04 PM
I am also having the same problem 😞
Oct 12, 2023 01:47 PM
In case anyone is still stuck on this...I managed to get around this error (fixed for my use case) by using the record ID instead of the field value (see photos).
😊
The following photo shows the token which caused the error for me
😡