Airtable - Error [422] The formula for filtering records is invalid: Invalid formula. Please check your formula text

Questions & Answers
1

Getting an error when trying to search an Airtable record for existing affiliate and getting the error:

Error

[422] The formula for filtering records is invalid: Invalid formula. Please check your formula text.

Please see attachments

IMG_0111
IMG_01112388×1668 314 KB

IMG_0110
IMG_01102388×1668 372 KB

IMG_0109
IMG_01092388×1668 357 KB

IMG_0112
IMG_01122388×1668 349 KB

3

Hello @Brittney_Gooch,

In your Formula, have you tried surround 147.Properties.Affiliate with single quotes instead of double quotes?

Edit: The above works, but not if the Company Name includes single quotes. So I think you would need to both surround the search term with single quotes, and escape any that may possibly be in the value itself. Example:

image

2 Likes
4

Thank you so so much! The scenario was running conditionally and the fix was to alternate between double and single quotes depending on how the data was input.

2 Likes
5

Hello @Brittney_Gooch :wave:

I just wanted to quickly jump in and congratulate you on solving this with the assistance of @Donald_Mitchell :clap:

Also, thanks a lot for getting back to us and sharing what did the trick for you. We genuinely appreciate that :pray:

6