Skip to main content
Solved

single line test is case insensitive on filtering

  • August 21, 2025
  • 4 replies
  • 79 views
C
Forum|alt.badge.img+2

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

Best answer by Tyler_Thorson

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!

    4 replies

    Tyler_Thorson
    Forum|alt.badge.img+15
    • Tyler_Thorson
    • Brainy
    • 30 replies
    • Answer
    • August 21, 2025

    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!

    Mike_AutomaticN
    Forum|alt.badge.img+28

    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

    C
    Forum|alt.badge.img+2
    • ciccio
    • Author
    • New Participant
    • 1 reply
    • August 22, 2025

    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

    Mike_AutomaticN
    Forum|alt.badge.img+28

    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.


    Terms & ConditionsAccessibility statement