Is Not Null
Hello, I'm looking for some help using if( not is null)... I have a field called "Seat #" and another called "Verification Cleared?." "Verification Cleared?" is multiple-choice that can have t...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendWhat field type is seat number - numeric or text?
But assuming that it is a text field like an airline seat, then try this
IF(
[Seat #]<>"" and [Verification Cleared?] = "Pending", "Incomplete",
[Seat #]<>"", "Complete")
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- MarkShnier__You
btw, its a bit of a "gotcha", but you may not use IsNull on a text field. You need to compare to empty quotes.
https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=12&rl=ep9
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------That's what I was suspecting. Thanks, Mark!
------------------------------
V W
------------------------------
