Complex Data Validation

re: Complex Data Validation

Matthew Stenger — Wed, 13 Oct 2010 19:23:31 GMT

p.s. Clarification, my last comment is in the context of InfoPath Designer 2010. Thanks.

re: Complex Data Validation

Matthew Stenger — Wed, 13 Oct 2010 19:20:12 GMT

How to create validation rule to accommodate the following:

"Account number must be *between* pattern 40\d\d\d\d\d? and pattern 50\d\d\d\d\d?"

Does a numerical range ruleset require VB?

re: Complex Data Validation

Jerkham — Tue, 06 Jul 2010 00:43:51 GMT

Looks like I'm about 4 years late with this comment, but it would make a lot more sense to use regular expressions for these specific examples. Something like...

State matches expression "Alabama|Arizona|Georgia|Utah"

would cover all 4 tests in one rule and is much easier to follow/debug. While I'm certainly no master of regular expressions, I know enough to know that they're powerful and handy.

re: Complex Data Validation

APickett — Fri, 23 Mar 2007 21:29:18 GMT

Hello, I have a question regarding Case Study #2, the first screenshot. You want to achieve this logic:

IF (State="Ohio" or State="Alabama") and TaxRate is blank THEN (fail...)

I have built this exact data validation rule (in Infopath 2007) and I have a suspicion that behind the scenes Infopath is interpretting it as:

IF State="Ohio" or (State="Alabama" and TaxRate is blank) THEN (fail...)

by giving the "AND" preference in the order of operations. This means that it throws a validation error whenver Ohio is selected, regardless of what Tax Rate is.

However, the Alternative Approach is exactly what I'm looking for and I will use that going forward. Thanks for the info!

-Andy