Skip to main content

Hi,


I want to do a select on my records according two conditions :



  • Find in “Resource title” field a text

  • Find in “Format” field an exact text


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.

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:

Reply


Terms & Conditions