Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
6 years ago

Formula on related numeric field?

I'm trying to do a simple check to see if a related (numeric) field is null. How come this doesn't work?

If(isnull([Related Field], true,false)

I don't get any errors in the code, it just simply doesn't work. Is that not the correct way to check if a related field is null?

------------------------------
Mike Tamoush
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago

    All numeric data entry fields have a checkbox to ask whether a blank should be treated as zero. Typically they default to treat a blank as zero. 


    So you can either disable the checkbox or test if it is equal to zero.



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