Using 'And' and 'Or' in Data Validation - InfoPath Dev
in

InfoPath Dev

Using 'And' and 'Or' in Data Validation

Last post 09-29-2006 11:58 AM by Shiva. 5 replies.
Page 1 of 1 (6 items)
Sort Posts: Previous Next
  • 09-27-2006 01:20 PM

    Using 'And' and 'Or' in Data Validation

    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.


  • 09-27-2006 08:58 PM In reply to

    • Shiva
    • Top 25 Contributor
    • Joined on 04-15-2005
    • India
    • Posts 694

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

    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
  • 09-28-2006 09:44 AM In reply to

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

    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.

  • 09-28-2006 11:07 PM In reply to

    • Shiva
    • Top 25 Contributor
    • Joined on 04-15-2005
    • India
    • Posts 694

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

    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.
  • 09-29-2006 10:17 AM In reply to

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

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

    Thank you for your help. :)
  • 09-29-2006 11:58 AM In reply to

    • Shiva
    • Top 25 Contributor
    • Joined on 04-15-2005
    • India
    • Posts 694

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

    Anyway, glad to see you figured it out! :)
Page 1 of 1 (6 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.