General

Re: Validating a field against a repeating table field is not working

lenovo27 — Tue, 20 Mar 2012 22:28:50 GMT

Should have been any row of field2.

Re: Validating a field against a repeating table field is not working

lenovo27 — Tue, 20 Mar 2012 22:28:21 GMT

Thanks Hilary, I found a way to accomplish this. I will post about it tomorrow or when time allows.

Re: Validating a field against a repeating table field is not working

Hilary Stoupa — Tue, 20 Mar 2012 16:41:30 GMT

I see where I was confused. I hadn't realized field 1 was not in the repeating table.

Which instance of field 2 should field 1 match? The first? The second? The 23rd? :-)

Re: Validating a field against a repeating table field is not working

lenovo27 — Tue, 20 Mar 2012 16:30:25 GMT

Please find attached. It's just a dummy form with only this concept. The actual form has a repeating table populated via a web service, but for troubleshooting I am trying to get this to work in the most basic way possible for now.

Re: Validating a field against a repeating table field is not working

Hilary Stoupa — Tue, 20 Mar 2012 15:19:37 GMT

Can you attach a copy of your form under the Options tab?

Re: Validating a field against a repeating table field is not working

lenovo27 — Tue, 20 Mar 2012 15:13:18 GMT

Yup, tried that, throws the same error. Repeating tables in InfoPath seem to always be an issue. If I copy field3 out of the repeating table it works perfectly fine. As soon as I put it back into the repeating table it throws the validation error every time.

Re: Validating a field against a repeating table field is not working

Hilary Stoupa — Mon, 19 Mar 2012 19:34:58 GMT

The only thing I can think of is that the comparison field (field 3) isn't an exact match of field 1. Have you tried copying from field 3 and pasting into field 1? Then tabbing or clicking out so the validation is re-evaluated?

Re: Validating a field against a repeating table field is not working

lenovo27 — Mon, 19 Mar 2012 16:56:29 GMT

Sorry for the confusion, I killed the form that I was using when I first posted this. I have a new form in which field1 is the field my validation rule is written on. Field3 is the first column of the repeating table that I want to validate against.

Re: Validating a field against a repeating table field is not working

Hilary Stoupa — Mon, 19 Mar 2012 15:43:08 GMT

So - your initial post said you were comparing to field 2. This is comparing against field 3.....

Re: Validating a field against a repeating table field is not working

lenovo27 — Mon, 19 Mar 2012 15:30:49 GMT

Thanks for taking a look Hilary.

. != ../my:field3

Re: Validating a field against a repeating table field is not working

Hilary Stoupa — Thu, 15 Mar 2012 00:26:55 GMT

What is the validation expression?

If you open the condition and change the first drop down to "The expression" it will display in a field next to that so you can copy and paste it in....

Validating a field against a repeating table field is not working

lenovo27 — Wed, 14 Mar 2012 22:27:23 GMT

I could have sworn I did this before.

The validation rule is as follows:

field1 is NOT equal to field2 (field2 is in repeating table, NOTE: field2 in repeating table is being populated on form load via a web service query)

Throw validation screentip: "Test"

It throws the validation error EVERY time though, even when the value in field1 matches the value in field2 (a field in the first column of the repeating table.

The validation rule is written on the field I want to validate (field1).