How do I loop through an array that is a set of (Product) RECORD_IDs; creating a record in the ‘Order Items’ table forEach Product, and also linking to the related order?
For example, Brutus the Buckeye has the ‘CertainTeed - Highland Slate’ product package applied to his Order.
I am having trouble wrapping my head around creating records in the ‘Order Items’ table. This was somewhat inspired from the record template example. This would allow for very common/repetitive list of pre-determined “packages” to be automatically applied as ‘Order Items’ for ‘Orders’.
// pick order
let order_table = base.getTable("Orders");
let order = await input.recordAsync('Pick an order', order_table)
if (order) {
output.text(`You picked '${order.getCellValueAsString("Order Name")}'`)
}
// pick a package(template)to apply to an order
let product_package_table = base.getTable("Product Packages")
let packagE = await input.recordAsync('Pick a product package', product_package_table)
if (packagE) {
output.text(`You picked the '${packagE.getCellValueAsString('Package Name')}' for the '${order.getCellValueAsString("Order Name")} Order'`)
}
//array of product's record_ids that belong to 'packagE'
let product_ids = packagE.getCellValue('Products')
let product_list = product_ids.map(linkedRecord => linkedRecord.id);
// for every item in product_list array, create record linking to the corresponding 'Product' and with every line item linked to the related order
let order_items_table = base.getTable("Order Items")
