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?
  • 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.
  • 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.
  • AdamTanner's avatar
    AdamTanner
    Qrew Trainee
    8 years ago
    Thank you for your help! It is coming back with a syntax error.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    There was an extra bracket after AMT

    Try this

    If(
    [AP Supplier Type])<>"", "Oracle Hold",
    [CURRENTWORKNODE]<>"", "Rapid Hold",
    [Amt]<>"", "Payment Hold
  • AdamTanner's avatar
    AdamTanner
    Qrew Trainee
    8 years ago
    It is coming up with the same error message :(
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Sorry, there were more extra brackets.

    There was an extra bracket after AMT

    Try this

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

    I'm actually sitting in a tent now on vacation and it's hard to see on my iPad :)
  • AdamTanner's avatar
    AdamTanner
    Qrew Trainee
    8 years ago
    Got it! The error was coming from [AP Supplier Type]) <-----
  • AdamTanner's avatar
    AdamTanner
    Qrew Trainee
    8 years ago
    It worked beautifully. Thanks so much!
    • MattHanamoto's avatar
      MattHanamoto
      Qrew Member
      5 years ago
      For future reference, if someone is trying to do this with a User type field, simply convert that user field to text and then use the syntax that the QuickBase coach provided.

      Ex. ToText([UserField])<>""
      - This can be embedded into the if statement to utilize the if(condition), then "value", else "other value" logic.

      ------------------------------
      Matt Hanamoto
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        On a User field type you can also do

        IF(IsNull[my user field]), then do this.......)

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------