Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Aug 06, 2020 01:53 AM
Hi,
I want to do a select on my records according two conditions :
For both conditions, I want them to be case nonsensitive because some text are written in caps, other not.
So, at the moment, I’ve this :
filterByFormula=AND(FIND("some text",{Resource title}),(FIND("Video",{Format}")))
And I’m getting the INVALID_FILTER_BY_FORMULA error message .
So, what I’m doing wrong ? Is it possible to have the nonsensitive case research ?
Thanks.
Aug 06, 2020 06:37 PM
Try this for a case-insensitive search:
AND(FIND(“some text”,LOWER({Resource Title})),(FIND(“video”,LOWER({Format}))))
This may be why you were getting the error: