Case Sensitive Contains Filter in Grid View

[Steve_Black]

Hi all!

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’?

Thanks!
Steve

[TheTimeSavingCo]

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"
)

[Steve_Black]

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.

[TheTimeSavingCo]

Steve_Black:

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.

Hmm, you could make a text field that said formula field references too, thereby reducing your clicks by 3 heh

Steve_Black:

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.

Nope, but I don’t really pay much attention to the feature request side of things either I’m afraid

[Steve_Black]

Adam_TheTimeSavingCo:

Hmm, you could make a text field that said formula field references too, thereby reducing your clicks by 3 heh

Could you elaborate on this? I’m not sure what you mean.