Forum Discussion

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago

Re: Listing Required fields not completed

It is sometimes confusing when QuickBase is or is not case sensitive.

but in a formula with = it is case sensitive

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

2 Replies

  • TomMusto's avatar
    TomMusto
    Qrew Cadet
    6 years ago
    If you want to eliminate the ambiguity around case sensitivity in formulas, you can always use the Lower() and Upper() functions. It then won't matter if your field has the word "yes" spelled with any of the 8 combinations of upper and lower case letters that can form that word (e.g. "yes", "YES", "YeS", "yEs"), Upper([My Field]) will always be "YES" and Lower([My Field]) will always be "yes".

    ------------------------------
    -Tom
    ------------------------------
    • AndrewFry's avatar
      AndrewFry
      Qrew Assistant Captain
      6 years ago
      That is a great idea!!

      I already implement that with a number of Excel apps I developed, so I don't know why I didn't think of that, lol.

      Thanks for the great tip Tom!!

      ------------------------------
      Andrew Fry
      ------------------------------