Deborah,
I almost never use Formcalc. It lacks some features - and you find sample scripts almost only for JavaScript.
In my next book („XML und Scripting – SAP Interactive Forms und Adobe LiveCycle Designer", espresso Verlag) you can find this funktion (here is a sneak preview). Hope it helps:
function copyTable(oMasterTable, bIgnoreBindingName ) {
// Purpose:
// In case there are duplicates of the table oMasterTable in the form
// then this function copies oMasterTable to these duplicates.
// The duplicates must have the exactly same structure. All subform- and field names must be identical.
// When is this function necessary?
// If you fill a table with an XML file as it is impossible to fill more than one table with an XML file.
// (It is possible to fill several tables if their bindings are "by name".)
// Parameters:
// oMasterTable: the subform encapsulating the repeating subform within (the repeating subform is the table row)
// bIgnoreBindingName: to identify the other duplicate tables correctly you can also compare the table's bindings
// (it might be possible to have subforms with other binding names. They would not be filled it
// you set this parameter to "false"
// Result:
// always returns true
// Usage:
// the function call should be placed in oMasterTable's form-ready event and might look something like this:
// Tablerow.copyTable(this, true);
// Prerequisites:
// The duplicate tables must have the same same structure as oMasterTable
//
// Author: Ulrich Bähr (paperless-process.de), 20.12.14
//+-----------------------
//| Find oMasterTable's repeating subform:
//+-----------------------
// now we look for rows or repeating subforms. They must be direct child-nodes of the table-subform node:
var oMasterRow;
for (var iIndexChildObject = 0; iIndexChildObject < oMasterTable.nodes.length; ++iIndexChildObject) {
var oMasterChild = oMasterTable.nodes.item(iIndexChildObject);
if (oMasterChild.isContainer && oMasterChild.className == "subform") { // this node appears to be a subform. It should be page.
if (oMasterChild.occur != "") {
// the child is a repeating subform. Headers, "overflowLeaders" and such are also repeating subforms.
if (oMasterChild.assist.role == "" || oMasterChild.assist.role != "TH") { // Headers look like this in XML: <assist role="TH"/>
oMasterRow = oMasterChild;
oMasterRowName = oMasterChild.name;
break;
} // if oMasterChild is not a header
} // if oMasterChild is a repeating subform
} // if oMasterChild.isContainer
} // for iIndexChildObject
//+-----------------------
//| Find all tables with the same name as oMasterTable
//+-----------------------
arrayOtherTables = new Array();
arrayTables = oMasterTable.all;
for (var i = 0; i < arrayTables.length; i++) {
if ((arrayTables.item(i) != oMasterTable) &&
((arrayTables.item(i).bind.ref == oMasterTable.bind.ref) || bIgnoreBindingName )) {
arrayOtherTables.push(arrayTables.item(i));
} // if (arrayTables.item(i) == oMasterTable)
} // for i
//+-----------------------
//| Iterating over all other tables found:
//| Run thru all rows of oMasterTable and create a new row in the other table
//+-----------------------
for (var iOtherTable = 0; iOtherTable < arrayOtherTables.length; iOtherTable ++) {
var oOtherTable = arrayOtherTables[iOtherTable];
for (var iRow = 0; iRow < oMasterRow.instanceManager.count ; iRow++) {
oOtherRow = oOtherTable.resolveNode(oOtherTable.somExpression + "." + oMasterRowName + "[0]"); // here we assume that the rows in all tables have the same name
if (iRow > 0) oOtherRow.instanceManager.addInstance(true);
oTargetRow = oMasterTable.resolveNode(oOtherTable.somExpression + "." + oMasterRowName + "[" + iRow + "]");
//+-----------------------
//| copy the master table's row to the newly created other table's row:
//+-----------------------
oMasterRow = oMasterTable.resolveNode(oMasterTable.somExpression + "." + oMasterRowName + "[" + iRow + "]");
Tablerow.copyRowFields(oMasterRow, oTargetRow);
} // for iMasterTable
} // for iOtherTable
return true;
} // function copyTable()
function copyRowFields(oMasterRow, oTargetRow) {
// Purpose:
// Copies each field within oMasterRow to the corresponding field within oTargetRow.
// Parameters:
// oMasterRow: the subform containing the source values. It's fields are being copied to oTargetRow
// oTargetRow: the subform with the identical structure as oMasterRow.
// Result:
// always returns true
// Prerequisites:
// The two subforms must have the identical structure (names of subforms and fields etc.)
// ToDo:
// This function is not prepared for not identical subform structures. It should check more and not assume identical structure.
// The function might call itself recursivly if oMasterField.isContainer to handle rows with subforms instead of plain fields.
// Author: Ulrich Bähr (paperless-process.de), 20.12.14
try {
for (var iIndexChildObject = 0; iIndexChildObject < oMasterRow.nodes.length; ++iIndexChildObject) {
var oMasterField = oMasterRow.nodes.item(iIndexChildObject);
if (oMasterField.className == "field") {
if (oMasterField.resolveNode("ui.#checkButton") == null) {
// we actually copy a field's value here:
oTargetField = oTargetRow.resolveNode(oTargetRow.somExpression + "." + oMasterField.name + "[" + oMasterField.index + "]");
oTargetField.rawValue = oMasterField.rawValue;
} // if oMasterField is not a checkbox
} // is oMasterField is a field
} // for iIndexChildObject
} // try
catch (e) {
//console.println("Error: " + e);
return false;
} // catch
return true;
} // function copyRowFields()
