Forum Discussion

AdamTanner's avatar
AdamTanner
Qrew Trainee
7 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]), "Rapid Hold",
If(not IsNull([Amt]), "Payment Hold")))

Currently, everything is being listed as an "Oracle Hold". I am not sure what I am doing wrong. Your help is much appreciated!!
Formulas and functions

14 Replies

Sort By
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 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
      7 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?
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      7 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.
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      7 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.