Find Record Invalid Filter Error

Set your trigger conditions to include “Email is not empty”, then retest. Do you still get the error?

That did it! Thank you!

@D_F Thanks for asking this! (and thanks to @Kamille_Parks for the response!) I was hitting the exact same wall :man_facepalming:

Hi, I’m having the issue but this fix didn’t work.

Did you ever get an answer to this? I am having the same issue.

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?

Any update here? i'm hitting this same error

Hoping for an update on this soon, I'm also having this issue and the suggestion solution doesn't apply/fix the issue.

hello?? anyone have an answer?

Hello, same issue either with an email formatted field, or text type field, or fomula. Any idea @dashler78-team ?

This is really blocking for basic feature. OR should make it match with first condition / but it stopped

Hey @Kamille_Parks11 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

I am also having the same problem 😞

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

🙎

I’ll assume many people coming across this issue aren’t finding their exact situation covered by the posts, so I figured I’d contribute my own version of a solution.

My issue was feeding a formula string of a Record ID and trying to find a record matching that Record ID. Both fields were Formulas providing a string of a Record ID, but the one provided from a lookup seemed to be wrapped in an Array or non-pure string that the filter didn’t like (error was “Invalid Filter on:”).

My workaround was to create a script preceding the “Find a Record” which transformed the problematic Record ID to a pure string, which is outputted for use by Find a Record. It’s quick and easy, and eliminates a few extra lookup & formula fields I was using before.

Yes, and another way of turning a lookup field into a pure string of text is to create a formula like this:

{Your Lookup Field} & ""

- ScottWorld, Expert Airtable Consultant

{Your Lookup Field} & ""

I have used that before, and completely forgot about it. If you can spare the extra fields, your method is the quickest and most elegant. Thank you for the contribution ​@ScottWorld 

You’re welcome! And thanks for your contribution as well! :)