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?