Forum Discussion

JaredBerger's avatar
JaredBerger
Qrew Member
4 years ago

Running formula isNull vs Is not null

Does anyone have any help for this problem I am running into, I want to display a text if the field has an input and display a different text if it does not have input? If( IsNull([Qty]), "D...
  • MarkShnier__You's avatar
    4 years ago
    You would need to uncheck the checkbox on the field which is probably set to "Treat blank as zero".

    That way a blank would be treated as a null.


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