Skip to main content

Hi all


Hope you can help.


Using the scripting block, how could I loop through the records and return the value of a lookup field. All other fields are fine but linked and lookup fields throw an error.


Here’s my code…


let table = base.getTable("Daily Orders");

let view = table.getView("Unfulfilled Daily Orders");

let sku = table.getField("Line Items: Sku"); //Lookup Field







let result = await view.selectRecordsAsync({

sorts: t{field: "Line Items: Variant Id", direction: "asc"}]

});



for (let record1 of result.records) {

  output.text(record1.getCellValue(sku)); // throws an error

 }

ERROR


Error: Unknown value ‘AlexSaleBeanieAdultCharcoal’ passed to output.text()


at main on line 12



Please help!


Thanks


Claire

Lookup fields return arrays, even if they’re only looking up from a single linked record. Instead of output.text, use output.inspect. This will display the literal item you’re receiving, even if it’s an array.

Reply


Terms & Conditions