Sep 22, 2022 01:57 PM
I’m wondering if it’s possible to set up a case sensitive Contains Filter on a single line text field in a Grid View. So if the Contains filter value was ‘Abc’, a row with the field containing ‘Abc123’ would be shown but not rows containing ‘ABC456’ or abc789’?
Sep 23, 2022 12:48 AM
Hi Steve, I usually solve this with a formula field and filter on that, not sure if there’s a more elegant way to handle it tho
Formula used here was
IF( FIND("Abc", Name), "Yes", "No" )
Sep 23, 2022 07:04 AM
Thanks for the reply Adam. That should get the job done (with a filter on that formula). I’d be changing the filter text often in the actual application, but I suppose it wouldn’t be much more effort in practice to edit the text in the formula column vs the filter contains field value.
Have you ever seen a feature request like a checkbox to go along side a ‘contains’ filter value field for case sensitivity? That would be ideal, but I feel like if that haven’t added something like that by now, it probably hasn’t been requested much.
Sep 26, 2022 12:53 AM
Hmm, you could make a text field that said formula field references too, thereby reducing your clicks by 3 heh
Nope, but I don’t really pay much attention to the feature request side of things either I’m afraid
Sep 26, 2022 05:25 AM
Could you elaborate on this? I’m not sure what you mean.