Skip to main content
Question

New Forms - Rules Test for NULL or 'unset' DATEs

  • June 16, 2023
  • 0 replies
  • 312 views

Forgive me if I missed something about this elsewhere, but for the life of me, i'm manually converting some forms and running into the issue with form/dynamic rules - the BLANK tests that used to work on old forms don't seem to be working in new forms. 

Now I have a work around to create a "dummy_null_field" for data types i need to test, using the null field in a "value in field" test, but that seems a bit over the top. 

Is there some way to test fields for NULL that works in New Forms rules creation?  



------------------------------
joe vandervest
------------------------------

    • joevandervest
    • Author
    • Registered
    • June 16, 2023

    I figured this out. 

    For those that might be confused: 

    Use the FORMULA BUILDER in the create/edit rules interface to create a simple test that should produce a boolean output.   e.g IsNull([something])=TRUE or Nz([something])=TRUE depending on datatype

    Then if the bool is TRUE the action you identify in the action section will happen. 




    ------------------------------
    joe vandervest
    ------------------------------

      MarkShnierYou
      Forum|alt.badge.img+24

      The problem may be a mismatch between how the field [Related Deployment] is set to handle nulls and how your formula is handling nulls.  If the Field Properties is set to treat blanks as zeros then is not will not work. You would have to compare as to whether or not it is equal to zero. Or else go to the field properties and de-select the checkbox to treat blanks as now. Then you can use IsNull. 

      Mark Shnier. Your Quickbase Coach
      Terms & ConditionsAccessibility statement