Quick Base Discussions

Expand all | Collapse all

IsNull Formula help

  • 1.  IsNull Formula help

    Posted 07-05-2017 14:55
    I have two fields, one which is a date and one which is numeric. I would like if either are blank, the action does not fire. Is there a way to set this up?

    I am currently trying to use a formula text field and isNull with the following formula:

    If(IsNull([Social Insurance Number]) or IsNull([Date of Birth]), "No", "Yes")
    So that I can determine if the action will fire if this formula says yes or no. The issue is if I input a number for [Social Insurance Number] it remains no, though if I input a date for [Date of Birth] if changes to say yes even if [Social Insurance Number] is still blank.

  • 2.  RE: IsNull Formula help

    Posted 07-05-2017 19:13
    On the field properties for "Social Insurance Number", is "Treat blank values as "0" in calculations" unchecked? It should be.

  • 3.  RE: IsNull Formula help

    Posted 07-06-2017 12:43
    It was checked! I actually ended up going with: 

    If(not IsNull([Social Insurance Number]) and (not IsNull([Date of Birth])), "Yes", "No")

    And it seems to be working