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.
Mar 31, 2022 02:56 PM
Set your trigger conditions to include “Email is not empty”, then retest. Do you still get the error?
Apr 05, 2022 12:57 PM
That did it! Thank you!
Oct 04, 2022 01:16 PM
@D_F Thanks for asking this! (and thanks to @Kamille_Parks for the response!) I was hitting the exact same wall :man_facepalming:
Nov 16, 2022 04:00 PM
Hi, I’m having the issue but this fix didn’t work.
Jan 05, 2023 12:20 PM
Feb 07, 2023 07:27 AM
Also getting this same error. Trying to match 2 fields that contain the same value.
Both fields are the same format.
Anyone figure out how to fix?
May 22, 2023 10:10 AM
Any update here? i'm hitting this same error
May 29, 2023 06:07 AM - edited May 29, 2023 06:08 AM
Hoping for an update on this soon, I'm also having this issue and the suggestion solution doesn't apply/fix the issue.
May 30, 2023 10:16 AM
hello?? anyone have an answer?
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
😡