JaredBerger
4 years agoQrew Member
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?
------------------------------
Jared Berger
------------------------------
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
------------------------------