
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
1 Solution
Accepted Solutions

Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 );
Reply
1 Reply 1

Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 );
Reply
