Forum Discussion

AdamTanner's avatar
AdamTanner
Qrew Trainee
8 years ago

Using 'not ifnull' formula in a 'formula text field'

I need some help with a formula. I am trying display text if a field is not null. This is my current formula: If(not IsNull([AP Supplier Type]), "Oracle Hold", If(not IsNull([CURRENTWORKNODE]), "R...
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
The IsNull function is documented not to work with Text Realty. To test of a text field is blank then use the syntax here

If(Trim([my text field])="", This field is blank")

Ie you have to test against = empty quotes.
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
In other words uf the field is not blank, then you want to do something. So you do, in fact, need a way to test if a field is blank.