If/then with blank field and checkbox
Hello friends, question about a field that used to work for me but no longer does.
In one form, one field will either be blank or have a number in it, we'll call it "tag number". If "tag number...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThe correct formula is this.
if(Trim([tag number])="", true, false)
in order to test a text field for blank you check if it's equal to empty quotes.
I'd like to wrap it in the trim function just in case someone enters some invisible spaces into the text field.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
If Tag Number is actually a Numeric field - you can also user the Nz() function. It will return 0 if the value is entered as 0 or null - basically a way to force it to render as 0 in all cases. You could then do if( Nz([Tag Number]) > 0, true, false)
------------------------------
Chayce Duncan
------------------------------thank you, everyone! the second option worked, and then I just flipped the true,false to false, true and that worked! thank you both for your help! I'll be able to use the first option I believe with another challenge. Thank you!!!
------------------------------
Nicole Cordeiro
------------------------------
