harfmt
Design Canvas Artiste

Validate Date against Multi Select Choice within repeating section

Jump to solution

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

Reply
3 Replies
abdullahfahmi91
Cloud Wanderer

Re: Validate Date against Multi Select Choice within repeating section

Jump to solution

Hi Joanne Morris‌,

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.

View solution in original post

Reply
harfmt
Design Canvas Artiste

Re: Validate Date against Multi Select Choice within repeating section

Jump to solution

Thanks Abdullah, that worked. 

0 Kudos
Reply
abdullahfahmi91
Cloud Wanderer

Re: Validate Date against Multi Select Choice within repeating section

Jump to solution

Good to know it worked for you

0 Kudos
Reply