Discussions

Expand all | Collapse all

Formula on related numeric field?

  • 1.  Formula on related numeric field?

    Posted 9 days ago
    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
    ------------------------------


  • 2.  RE: Formula on related numeric field?

    Posted 9 days 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
    ------------------------------