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.
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?
validation rules work for controls in repeating section.
but your formula should look like
othernumber > 0 && IsNullOrEmpty(othercomments)