carl_taute
Novice

Number Field Validation

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

Tags (2)
0 Kudos
Reply
2 Replies
lakshminarayana

Re: Number Field Validation

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.

Thanks,

Lakshmi Narayana C

0 Kudos
Reply
emha
Collaborator

Re: Number Field Validation

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

use rather formula like

isNullOrEmpty(LeavePayDaysOldDefinition) && ...
0 Kudos
Reply