Editing a Numbers script to enter form data in the first empty line of a table with a last header row

Dubbia wrote:

enter the form data in the first empty line of the table even with the last header line.

I'm guess by "last header line" that you mean you have a Footer Row at the bottom of the table and you want to add a row above that and transfer the values from the table "Form". If so, then you can subtract footerRowCount before addRowBelow, something like this:

// get the two tables involved
var Numbers = Application("Numbers");
var database = Numbers.documents[0].sheets[0].tables["Anagrafe 2025"];
var form = Numbers.documents[0].sheets[1].tables["FORM"];
// get all the values from the form
var values = [];
for(var i=0;i<form.rows.length;i++) {
var value = form.rows[i].cells[0].value();
values.push(value);
}
// create a new row at the bottom of the database
var newRow = database.cells["A"+(database.rows.length-database.footerRowCount())].addRowBelow();
// put the values into that row
for(var i=0;i<values.length;i++) {
newRow.cells[i].value = values[i];
}
// clear out the form, going backwards so to end on the first cell
for(var i=form.rows.length-1;i>=0;i--) {
form.rows[i].cells[0].value = "";
}

SG

P.S. Good to see an example of JXA scripting of Numbers in these forums.