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

}

]);

};