Forum Discussion

ESPECData's avatar
ESPECData
Qrew Member
8 years ago

How do formula functions respond to capitalization? Is there a guide to this?

I've looked before and never found a guide to how Quick Base executes formula functions regarding capitalization. I've been using QB for years and just let it do its thing. Today, I found at text test...
Formulas and functions
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
8 years ago
You have to canonicalize your comparison to achieve case insensitivity:

Case(Lower([field]),
  "with modification", "Model requires modification"
)