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]), "Data Not Entered - Not Confirmed",

not IsNull ([Qty]), "Data Entered")



------------------------------
Jared Berger
------------------------------
  • 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
    ------------------------------
  • 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
    ------------------------------