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
Try this

If(
[AP Supplier Type])<>"", "Oracle Hold",
[CURRENTWORKNODE]<>"", "Rapid Hold",
[Amt])<>"", "Payment Hold")

Note that unlike Excel, you do not need to nest your IF statements.