Using 'not ifnull' formula in a 'formula text field'

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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!!
Photo of Adam Tanner

Adam Tanner

  • 206 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,256 Points 50k badge 2x thumb
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.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,256 Points 50k badge 2x thumb
There was an extra bracket after AMT

Try this

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

Adam Tanner

  • 206 Points 100 badge 2x thumb
It is coming up with the same error message :(
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,256 Points 50k badge 2x thumb
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 :)
Photo of Adam Tanner

Adam Tanner

  • 206 Points 100 badge 2x thumb
Got it! The error was coming from [AP Supplier Type]) <-----
Photo of Adam Tanner

Adam Tanner

  • 206 Points 100 badge 2x thumb
It worked beautifully. Thanks so much!