Hello,
I am filtering out a view based on the value of a “single line text” field in which I search for a specific substring (E.G. “Backrow”) although I got presented also the records in which there is the same word but with different casing (“BackRow) and I don’t want that.
Am I missing something or the filtering for “single line text” is actually case insensitive? If so, is there any workaround?
Thanks in advance
Francesco
Hello
Unfortunately the case-sensitivity of text filters is coupled to the “is” vs. “contains” operators:
When you select Single Line Text is Backrow, it will be a case-sensitive search.
When you select Single Line Text contains Backrow, it will be a non-case-sensitive search.
Its super clunky, but you could include a formula field called “SearchTerm” where you set the formula value to the term you want to search:
"Backrow"
and another formula field called “Search” with the following formula:
IF(FIND({SearchTerm}, {SearchField}), TRUE(), FALSE())
Set the formula format to Checkbox, then filter using that field.
Then all you have to do is change the contents of the SearchTerm field to whatever case-sensitive text you want to search for.

Super clunky, but gets the job done for quick searches.
Hope that helps!
Hey
As mentioned
If you really need to search for exact matches (but not case sensitive), then my suggestion would be to have a helper field called “Lower” or similar, and have the following formula on it:
LOWER({single line text field})
Then, apply the filter to “is” but always type on lowcaps.
Is that helpful? Otherwise please let us know!
Mike, Consultant @ Automatic Nation
Thank
The workaround that
Have you all a great day
Francesco
Glad to hear that!! Feel free to reach out as needed if you have any other question :D
Mike, Consultant @ Automatic Nation
YouTube Channel here.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.