Loop through HTML table and calculate field
Posted on 2007-10-17
I have a simple problem (I think). I have a html table (15 rows 6 columns) that I need to loop through each row and check the value of the first cell (ddEarningsType1-15) and depending on the value need to add the value of the third cell (ddhours1-15) to one of 2 text fields (TotNormalHours, TotOTHours) and then sum the TotNormalHours and TotOTHours and populate TotHours text field. Hope this makes since, but if you need more information just let me know.
TextField = TotNormalHours TextField = TotOTHours TextField = TotHours
EarningType BillingCode Hours
Normal 4 8
OT 45 2.5