Data validation

[Karen]

Hi,

Is there a way to validate that the data entered in one field exists as an
entry in another field which is part of a repeating table? I tried using
"contains", but that just does a string search, so if they had entered "Plan
A" in the field of the repeating table and "Plan" in the field that I'm
checking, it won't flag it as a validation error.

Thanks in advance.

Regards,
Karen

 

[SMS]

Hi,

Is there a way to validate that the data entered in one field exists as an
entry in another field which is part of a repeating table?  I tried using
"contains", but that just does a string search, so if they had entered "Plan
A" in the field of the repeating table and "Plan" in the field that I'm
checking, it won't flag it as a validation error.

Thanks in advance.

Regards,
Karen

I created a dummy field, which was concatenation of all the repeating
fields using the below link:
http://blogs.msdn.com/infopath/archive/2006/04/05/569338.aspx

And creates a field with data "Plan;Plan A;"

Now I search for "Plan;" (using contain function) and since the
semicolon indicates end of word, it wouldn't pick up Plan A

 

[Steve]

I created an input TextBox field1 and a repeating table with TextBoxes
field2, field3, and field4.

For the data validation for field1, I specified that:
if field2 does not contain field1 and
if field3 does not contain field1 and
if field4 does not contain field1
then show this error alert: No match!

This all works as expected. If the term in field1 is in any of the other
fields, it validates. Note that this matches any string or portion of
string. So if I enter "test" in field1 and "testing", "tested", etc in the
other fields, I get a match.

Interesting exercise. I hope that this helps.

 

[Frederik Van Lierde]

The most easy way is to use Data Validation on Field 1 (Input TextBox)

The complete step by step guide can be found on

http://blueinfopath.wordpress.com/2...ld-exists-as-an-entry-in-a-repeating-control/

Don't forget to let us know if the solution worked. (by rating the
post or by leaving a comment)

Frederik Van Lierde
http://SilverSandsAssociates.wordpress.com

Twitter: http://Twitter.com/SilverSands_IT