Skip to main content

Hi, I have a number field which requires conditional validation.

If an option above is selected, then the number field is unable to be left blank (but it may be 0 in value)

I have tried the following validation rule (see attached Capture1.jpg).

With this rule, I get 99% success. But I am unable to populate the field with a 0 (zero).

Why not?

Is there a change to the validation perhaps? I've tried everything I can without success

note I have tried with single quotation marks IE '' and double quotation marks IE ""

Thanks

Carl

Hi ‌,

Is Termination is a check box/Choice?

Using rules you can n't set values to the controls. You can set 0 to 'Leave Pay Days' using javascript when you select Termination value else you can clear it by setting empty string. see the below. And let it be the validation rule for checking blank value.

205214_pastedImage_1.png

Thanks,

Lakshmi Narayana C


empty string has to be converted to a numeric, hence it's zero.

use rather formula like

isNullOrEmpty(LeavePayDaysOldDefinition) && ...

Reply