Only One of Three Fields Required Validation Rule - Nintex Forms

Hi,

 

Thought it would be easier to make you a demo form rather than explain this so I have attached one.

When you select a product group if none of the three fields are completed all will invalidate.

If one of the three fields is completed none of them will invalidate.

 

Hope this helps.

 

Hi,

 

Thank you, but unfortunately, I'm unable to open the file you attached. Would you be able to post the rule you created so I can take a look? I'd really appreciate it!

Hi,

To use the attached file you need to unzip it and then open the Nintex Forms designer and pick a classic form and then click import from the ribbon and select the unzipped file.

On the years control I used this rule:
!isNullOrEmpty(ProductGroup) && isNullOrEmpty(Month) && isNullOrEmpty(Date) && isNullOrEmpty({Self})

On the Month control I used:
!isNullOrEmpty(ProductGroup) && isNullOrEmpty(Years) && isNullOrEmpty(Date) && isNullOrEmpty({Self})

On the Date control I used:
!isNullOrEmpty(ProductGroup) && isNullOrEmpty(Years) && isNullOrEmpty(Month) && isNullOrEmpty({Self})

Thank you so much!

 

The rule for the year and months works great, but the one for the date field isn't firing for some reason. IDK why, maybe it has something to do with it being a date field?

Did you try import my sample form as the rule on the date control also works.