filterByFormula not working if search term contains apostrophe

Anyone else running into this? I have the following formula (encoded or not) that throws an INVALID_FILTER_BY_FORMULA error when submitted to the API via JavaScript:

AND(IF(FIND(‘GIZELLE’S BUCKET LIST’, Available_Rights) > 0, TRUE(), FALSE()))

The only records where this is a problem contain the apostrophe. All others work fine. I’ve explored the forum where people are having problems with commas and similar punctuation within the data and their fixes didn’t work. I’ve also tried looking it up via other available data and that was a bust, too, due to the structure of the tables.

Has anyone encountered this? Is this an API problem? Any thoughts or fix ideas welcome.

Thanks in advance!

Mark

See the apostrophe in the GEZELLE’S ? That is messing up your formula since you now have an extra one. Use GAZELLE\'s instead

1 Like

I am an idiot. Been looking at the for a hour and didn’t even think to do that. Thanks! :slight_smile: