Forum Discussion

AmandaThomas1's avatar
AmandaThomas1
Qrew Trainee
4 years ago

Formula to check for blank/null Multi-Select Text field

I am writing custom data rules and would like to have a rule that when a specific Multi-Select Text field [Items Awarded] is blank/null the record cannot be saved. I've tried using each of the foll...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
It's not well documented imho, but custom data rule is really a formula text field and the record will be blocked on save if the generated message to the user, is not blank.  

So this should work

IF(ToText([Items Awarded]) = "", "You must select at least one value for Items Awarded")

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
  • AmandaThomas1's avatar
    AmandaThomas1
    Qrew Trainee
    4 years ago
    Thank you Mark. I just realized that the reason I was receiving an error even when using (ToText([Items Awarded]) was that I didn't have the next condition in the if statement. 

    I appreciate your help

    ------------------------------
    Amanda Thomas
    Business Systems Analyst
    Morse Steel Reinforcing
    Bellingham WA
    360-756-6208
    ------------------------------