Outputting specific fields in table

I’m trying to test a very simple script, but I can’t seem to output specific fields to a table, no matter which fields I specific in selectRecordsAsync, the output is always the same: fields id and name.
My code:

let table = base.getTable("Procedimentos");
let query = await table.selectRecordsAsync({fields: ["Procedimento","Descrição"]});
output.table(query.records);

What am I missing?

To get the cell values, you need to use getCellValue().

let table = base.getTable("Procedimentos");
let query = await table.selectRecordsAsync({fields: ["Procedimento","Descrição"]});

const data = query.records.map(record => ({
  "Procedimento": record.getCellValue("Procedimento"),
  "Descrição": record.getCellValue("Descrição"),
}))

output.table(data );
1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.