Forum Discussion

Qrew Cadet

2 years ago

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

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 wor...

joevandervest

Qrew Cadet

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
------------------------------

JoelHickok

Qrew Cadet

2 years ago

While I also search out work arounds like you have done here, I still feel like this is an issue. We should not be forced to create new fields and workarounds to do something basic that the form should be capable of doing on its own. Especially since the old forms allowed this more easily.

Let's take steps forward not backwards!