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]), "R...
Formulas and functions
AdamTanner's avatar
AdamTanner
Qrew Trainee
It worked beautifully. Thanks so much!
MattHanamoto's avatar
MattHanamoto
Qrew Member
4 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
    Qrew Champion
    4 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
    ------------------------------
    • DonCurtin's avatar
      DonCurtin
      Qrew Member
      3 years ago
      I know this is a bit of an old post, but will 'IsNull' work if [my user field] is a text field

      ------------------------------
      Don Curtin
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew Champion
        3 years ago
        To check for blank in a text field use

        Trim([my text field])=""

        ------------------------------
        Mark Shnier (YQC)
        mark.shnier@gmail.com
        ------------------------------