let table = base.getTable("Copy-Orders");
for (let record of resulttxt['Data']) {
let recordId = await table.createRecordAsync({
"Order": Number(record['orderNumber']),
"Due Date": record['dueDate'],
"Order Total": record['orderTotal'],
//...
"Quote Number": [{id: '24229'}],
});
}
output.text("Created orders records OK!");
//tips:The field name is "Quote Number", the associated table name is "Quotes", the associated field is "Quote", and record['quoteNumber'] is the value to be inserted.
how to deal with the "Quote Number": [{id: '24229'}], for example,the value of Quote Numbe is '24229'. thank you.
