Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 01, 2021 11:29 PM
after using the API documentation it’s confusing trying to find info for the scripting app. I was expecting to be able to use maxRecords to grab the first record but that doesn’t seem to work. What am I missing here?
let queryResult = await table.selectRecordsAsync({
sorts: [
// sort by "ID" in ascending order
{field: "id"},
// then by "Title" in descending order.
{field: "title", direction: "desc"},
],
maxRecords: 1
});
Jun 02, 2021 01:22 PM
Hi @Jared_Ingold - yeah the APIs are just different and maxRecords isn’t a param you can use in the scripting app. I’m sure you know this, but you can get to the same result with:
let table = base.getTable("Table");
let queryResult = await table.selectRecordsAsync();
let record = queryResult.getRecord(queryResult.recordIds[0]);
output.inspect(record.getCellValue("ID"));
I guess there’s an argument to say “why do I have to return all of the records in a table or view to get just one”, but for most bases (all?), this won’t be too much of an overhead.
=======================
Want to learn Airtable Scripting? 1 day bootcamp coming soon!
=======================
Jun 02, 2021 02:33 PM
I guess there’s an argument to say “why do I have to return all of the records in a table or view to get just one”, but for most bases (all?), this won’t be too much of an overhead.
To say the least; the record loading/base cloning times are arguably one of the most impressive aspects of Airtable.
Can’t say I ever came close to pushing both the 500-row and 50k-record limit in a single base, but this truly ain’t a major issue.