Aug 23, 2022 10:15 AM
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?
Solved! Go to Solution.
Aug 23, 2022 10:33 AM
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 );
Aug 23, 2022 10:33 AM
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 );