Skip to main content

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.

Be the first to reply!