Do you have any updates from Airtable about this @Sergey_Filimonov ?
The selectRecordsAsync
method automatically collects all fields from all records. This a) takes more processing time for large tables, and b) could potentially eat a lot of memory with high record counts and lots of fields and data. It’s best to only collect the fields needed later in the script. This is done by passing an object to selectRecordsAsync
with a “fields” property that contains an array of field names.
const queryOrders = await base.getTable("Orders").selectRecordsAsync({
fields: [
"Field Name 1",
"Field Name 2"
]
})
Only those field names listed can be used later in the script for things like getCellValues
, etc.
The selectRecordsAsync
method automatically collects all fields from all records. This a) takes more processing time for large tables, and b) could potentially eat a lot of memory with high record counts and lots of fields and data. It’s best to only collect the fields needed later in the script. This is done by passing an object to selectRecordsAsync
with a “fields” property that contains an array of field names.
const queryOrders = await base.getTable("Orders").selectRecordsAsync({
fields: [
"Field Name 1",
"Field Name 2"
]
})
Only those field names listed can be used later in the script for things like getCellValues
, etc.
This worked like a charm. Thank you!
The selectRecordsAsync
method automatically collects all fields from all records. This a) takes more processing time for large tables, and b) could potentially eat a lot of memory with high record counts and lots of fields and data. It’s best to only collect the fields needed later in the script. This is done by passing an object to selectRecordsAsync
with a “fields” property that contains an array of field names.
const queryOrders = await base.getTable("Orders").selectRecordsAsync({
fields: [
"Field Name 1",
"Field Name 2"
]
})
Only those field names listed can be used later in the script for things like getCellValues
, etc.
Fantastic, thank you.