Hello,

I've got a pdf that is calculating a large amount of fields. I'm wanting to use the same javascript function for each total column.

Beginning Mileage | Ending Mileage | Reimbursable
---------------------------------------------------
Odometer.1 | Odometer.2 | Total.1
---------------------------------------------------
Odometer.3 | Odometer.4 | Total.2

I suppose I could just create a function something like this:

function reimbursableMileage(ending, beginning)
{
var tempEnd = this.getField("Odometer." + ending).value;

var tempBegin = this.getField("Odometer." + beginning).value;

var Total = tempEnd - tempBegin;

event.value = Total;

}

I'm just wanting to make sure this is the faster way of applying this script to hundreds of Reimbursable Mile Fields.

Thanks for any help/advice!

Using some more advance JavaScripting, on can reference an array of fields and then create an array of field objects and use one or all of the arrays to process the form. One does need to carefully name their fields. Having field names 'start.#', 'end.#', and 'total.#' and 'grandTotal', one could use the following script as the custom calculation script for the 'grandTotal' field:

function Difference (fEnd, fStart) {
return fEnd - fStart;
}


// obtain the total field highest level
var oTotal = this.getField('total');
// convert oTotal oject to an array of member fields
var aTotal = oTotal.getArray();
// make array for start and end
var aStart = this.getField('start').getArray();
var aEnd = this.getField('end').getArray();
var fGrandTotal = 0; // variable for Grand Total
var fTotal = 0; // variable for difference
// use elements of aToal array to control computation of each row
for( i = 0; i < aTotal.length; i++){
fTotal = 0;
// compute total for row i if end is not zero
if(aEnd[i].value !=0) {
fTotal = Difference(aEnd[i].value, aStart[i].value);
}
// update total field
aTotal[i].value = fTotal;
// add result to grand total
fGrandTotal += fTotal;
}
// update field value for grand total
event.value = fGrandTotal;

SumArrayFields.pdf Summing an array of fields