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?
Best answer by kuovonne
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 );
+29To 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 );
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.