take one record, for example, values are:
rec.getCellValue(‘Person’)
rec.getCellValue(‘Project’) - array of links
you need to map array of links (Project) and get smth like this
const converse=rec=>rec.getCellValue(‘Project’).map(x=>
[ rec.getCellValue(‘Person’) , x ] )
^^Bob^^ ____________^^ProjX^
// link obect read format has id and name. to write, we need only object with id. so, x should be changed to {id:x.id}
then transfer it to create record format
const create=(el)=>({fields:{‘Title’:el.Title,‘ID’:el.ID }}) //just example from other script
const create=(el)=>({fields:{‘Person’:el[0], ‘Project’:el[1]}})
//link should be an array of object, even if it’s single link, so ‘Project’:[el[1]]
final version:
const sourcetable = base.getTable('source');
const desttable = base.getTable('dest');
const query=await sourcetable.selectRecordsAsync({fields:['Person','Project']});
const converse=rec=>rec.getCellValue('Project').map(x=>[rec.getCellValue('Person'),{id:x.id}])
const create=(el)=>({fields:{'Person':el[0], 'Project':[el[1]]}})
const crt=query.records.flatMap(converse).map(create)
while (crt.length) await desttable.createRecordsAsync(crt.splice(0,50))
