Skip to main content

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 ​@ciccio,

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 ​@ciccio,

As mentioned ​@Tyler_Thorson above, only the {Single line text field} “is”… will be case sensitive. The “contains” will not.

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 ​@Mike_AutomaticN and ​@Tyler_Thorson for your help.

The workaround that ​@Tyler_Thorson suggest is what I actually need in this case 🙂

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.