Data Validation on Field Within Repeating Table - InfoPath Dev
in

InfoPath Dev

Data Validation on Field Within Repeating Table

Last post 04-09-2007 08:05 AM by Matt Faus. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 04-09-2007 06:07 AM

    Data Validation on Field Within Repeating Table

    I have a repeating table with fields SerialNO1 to SerialNo10 on different Rows.
    I need to make sure that when the user types in the serial number, it has not been input further up the form.
    I have tried using data validation, but it only allows me to put in 5 conditions, so think I will need to add code to the jscript when choosing "On Validate".
    This is where I get completely stuck, not really having too much exposure to this type of code.
    I also need to continue the validation when more rows are added to the repeating table, can this be done?
    Is there an easy way to set up this type of data validation that I am completely missing?
  • 04-09-2007 08:05 AM In reply to

    Re: Data Validation on Field Within Repeating Table

    Hi srf1980 and welcome to the forums!

    You can workaround the problem where you can only input 5 conditions by changing the last condition to "The expression" and then you can OR or AND together as many conditions as you want.

    This is a common scenario and I suggest you read through our HowTos to see if there is anything in there that might help you. One that came to mind is through this link:http://infopathdev.com/howto/tutorials/default.aspx?i=1fe635d7e2cd4c478b7a1eea929153ea
    Matt Faus / Microsoft InfoPath MVP
    Qdabra® Software / Streamline data gathering to turn process into knowledge
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.