Validate Date against Multi Select Choice within repeating section

+11

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

+5

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.

+11

Thanks Abdullah, that worked.

+5

Good to know it worked for you ‌

Sign up