Quick Base Discussions

Expand all | Collapse all

IF STATEMENT TO KNOW IF REPORT LINK IS POPULATED

  • 1.  IF STATEMENT TO KNOW IF REPORT LINK IS POPULATED

    Posted 03-29-2018 05:00
    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.


  • 2.  RE: IF STATEMENT TO KNOW IF REPORT LINK IS POPULATED

    Top
    Contributor
    Posted 03-29-2018 05:16
    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")