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 ------------------------------
Best answer by MarkShnierYou
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 ------------------------------
