Skip to main content
Question

IF STATEMENT TO KNOW IF REPORT LINK IS POPULATED

  • March 29, 2018
  • 0 replies
  • 23 views
I am wanting to write an IF statement to tell me if a report link has any data in it. It tried this IF statement but it does not change

IF([Scheduled Job]=null, "Scheduled", "Not Scheduled")

Basically the assumption is if there is data in the report link Related Scheduled Job then it is scheduled.

Thanks for the help.
      This topic has been closed for replies.

      • MCFNeil
      • Quickbase Alumni
      • March 29, 2018
      I think you mean to say 'Reference field'. 

      If thats the case, numeric reference fields will have a null value, but act like a "0" by default.

      You can change the field properties for the reference field, or do what I do and just change the logic in the formula (faster for me)

      ">0" rather than "=null"

      IF([Related Scheduled Job]>0, "Scheduled", "Not Scheduled")
      Terms & ConditionsAccessibility statement