cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Workflow Hero

How to ensure validation checks each fields of repeating rows?

Hello,

I have repeating rows. Inside each repeating row, I have several fields; two of those fields are "Other (Numbers Only)" and "OTHER (Comments)" as can be seen in the attached image. These fields can only accept numbers.

How it shows on the page:

How it shows on the Nintex:

I am trying to ensure that if any of the OTHER(Numbers only) are anything more than 0, then Other (Comments) needs to be filled out and is mandatory.

I gave "othernumber" the name to OTHER (Numbers Only) as below

I tried to add this validation using rules as below:

However, the problem is below:

* If two repeating rows have other (number) > 0, then the validation kicks in. This is correct. I fill it one of the Other (comments) and leave the other(comments) empty. I expected the validation still stop me from submitting. However, it gets submitted. I need all Other (Number Only) to be checked. Is that possible using rules or another way?

Labels: (1)
0 Kudos
Reply
1 Reply
Workflow Hero

Re: How to ensure validation checks each fields of repeating rows?

validation rules work for controls in repeating section.

but your formula should look like 

othernumber > 0 && IsNullOrEmpty(othercomments)
0 Kudos
Accept as Solution Reply