
How can I get the proper data for OTHERS description
here is the script that I used
var others = FormInvoiceRequest.Subform1.Table1.Row14.Cell3.rawValue; // this is the data for Table 1
var rows = xfa.resolveNodes(" FormInvoiceRequest.Subform1.Table2.Row1[*]"); // this is the data for Table 2
//Table1.Row1.Cell1 = qty[0];
for (var i = 0; i <= rows.length; i++) {
var row = rows.item(i);
var rowQty = row.Cell1.rawValue;
var rowUnit = row.Cell2.rawValue;
var rowUnitprice = row.Cell4.rawValue;
var rowAmount = row.Cell5.rawValue;
var rowDesc = row.Cell3.rawValue;
if (rowDesc = others) {
Table1.Row14.Cell1 = rowQty;
Table1.Row14.Cell2 = rowUnit;
Table1.Row14.Cell4 = rowUnitprice;
Table1.Row14.Cell5 = rowAmount;
}
}