Validate Date against Multi Select Choice within repeating section

Hi

Within a repeating section on a desktop form in 2010, I have a date/time control and a multi select choice control.

I don't think the problem is because they're in a repeating section. I took the controls out and still had the same problem.

I want to validate the following:

If the date is not empty and nothing is selected in the multi choice control, produce error message.

I've tried a number of different rule options, however I believe the following should work:

{Self} is the Action Taken

I've also tried:

and(!equals(Date,''),equals({Self},''))

and(Date!='',equals({Self},''))

and(!Date=='',equals({Self},''))

I've also tried substituting 'and' for &&

Page 1 / 1

Where do you apply the rule?
Try to use the Validation rule below on the checkbox control.

isNullOrEmpty({Self})&&not(isNullOrEmpty(DustAlarmsDateTime))

I've tried this rule outside and inside of a repeating section.
It works properly.

p/s: Do not copypaste the rule formula above. Build it as per above inside Rule Formula Builder.

Please let me know what is your result.

Thanks Abdullah, that worked.

Good to know it worked for you ‌

Sign up