General

Re: Using 'And' and 'Or' in Data Validation

Shiva — Fri, 29 Sep 2006 18:58:13 GMT

Anyway, glad to see you figured it out! :)

Re: Using 'And' and 'Or' in Data Validation

mjoffutt — Fri, 29 Sep 2006 17:17:47 GMT

Sorry about that, I had the fields wrong in the validation. It does work correctly.

Thank you for your help. :)

Re: Using 'And' and 'Or' in Data Validation

Shiva — Fri, 29 Sep 2006 06:07:01 GMT

Hi mjoffutt,

I have done many times in InfoPath these types of validation conditions. For every validation as treated as ‘OR#%92 only. Can you check your validation condition once again.

Re: Using 'And' and 'Or' in Data Validation

mjoffutt — Thu, 28 Sep 2006 16:44:42 GMT

This does not appear to work. It appears that it is treating each line as an 'AND' and not an 'OR' so unless all of the validations resolve to true the field is not required.

Re: Using 'And' and 'Or' in Data Validation

Shiva — Thu, 28 Sep 2006 03:58:08 GMT

Hi mjoffutt,

For above validation you need add three validations like:

1. ReasonForClose = "" and PASS0DissapproveAction = "4-Close PDR"
2. ReasonForClose = "" and CustomerDisapproveAction = "6-Close PDR"
3. ReasonForClose = "" and BusinessDisapproveAction = "4-Close PDR

Using 'And' and 'Or' in Data Validation

mjoffutt — Wed, 27 Sep 2006 20:20:43 GMT

I have the following Data Validation set up on a field

This doesn't work quite like I would like it to. How would I create Data Validation to behave like:

(PASS0DissapproveAction = "4-Close PDR" OR CustomerDisapproveAction = "6-Close PDR" OR BusinessDisapproveAction = "4-Close PDR) AND ReasonForClose = ""

This question has probably been answered before but I was unable to find anything when searching through the forums.