Hi there

I want to copy certain fields of a record to another table.

Example:


table 1 has 3 fields with names: 1,2,3


table 2 has 4 fields with names: 1,3,4,5

When the script is run, all records of table 1 should be copied to table 2 into fields 1 and 3 (leaving fields 4 and 5 empty). Could you give me some direction as to what should go into the bold section?

What I have so far:

let table1 = base.getTable(‘Table 1’);


let table2 = base.getTable(‘Table 2’);


let copyQuery = await table1.selectRecordsAsync();


for (let record of copyQuery.records){


table2.createRecordsAsync(d


{


//what should be here


}


]);


};