Forum Discussion

AndrewFry's avatar
AndrewFry
Qrew Assistant Captain
6 years ago

Listing Required fields not completed

I am in need of some brain power to figure out how to go about listing all required fields not completed. For a Work Order to be deemed "Active", several different fields must be completed. These f...
Forms
Formulas and functions
roles and permissions
AndrewFry's avatar
AndrewFry
Qrew Assistant Captain
6 years ago
Ok, I think I figured it out.

I didn't realize that the "Yes" or text was case sensitive.

I am testing a few other examples but I think I got it!!

------------------------------
Andrew Fry
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
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
------------------------------
  • 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
    ------------------------------