I know validation on fields has been kicking about in the nice-to-have category for a while but I would like to compromise here and set out to trying to achieve some visual way of validating field values via Row Formatting Rules. The only problem is that the options to filter by are not case sensitive in my case. I was hoping I could create 26 rules to check if a field started with A-Z to check for uppercase naming, however the filter is case insensitive.
Ideally there is a Matches Pattern
or Starts With Pattern
but I’ll take a checkbox for Filter Values Are Case-Sensitive
.
See the attachment for more info.
Cheers,
Halil