Forum Discussion

joevandervest's avatar
joevandervest
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...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend

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. 

rbuschmeyer's avatar
rbuschmeyer
Qrew Trainee
2 months ago

Excellent, thank you Mark