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.
AdamTanner's avatar
AdamTanner
Qrew Trainee
8 years ago
I do not want to test if the field is blank. I want to label a record as either, Oracle, Payment, or Rapid hold in a summary report if a certain field has text in it. Does that make sense?