I have been digging but can't find my answer. I have a table that you can add rows to. In the same cell in each row I have to validate if the number in the field starts with a 4 or 5 ( the number is a total of 6 digits long). I have java script that validates the 4 or 5. but I need to loop through all the rows for that cell. Right now just validates on the first row.
var Grant = Main.PreApproved.Table1.Row1.Fund.rawValue
What it is supposed to do is check the Fund field for each person that is added. If any one of the people have a fund that has a 4 or 5 as the first number, then the whole form needs to be sent to the grants and contracts office first for approval. when Grants and contracts approves it they will then sent to Payroll.
If none of the fund fields have a 4 or 5 then the form goes directly to payroll.
Right now it seems to want to send an email for each of the form fields, vs. emailing just once.