I’m wondering if there is a tool, like the API encoder codepen, which helps build filterByFormula to send to the API via getTableAsync.
The API encoder accepts a filterByFormula, but it doesn’t help you formulate one.
I have a large Vue site with che...
I’m trying to simply copy one text field to another text field in a table with 10,000 records, in batches of 50 with the Scripting App.
What am I doing wrong in this block:
let table = base.getTable('TableName');
let query = await table.selectRecords...
I know there is getView(‘ViewName’) to retrieve a particuilar view of a table, but what if you don’t know the name of a view, or how many views there are?
Is there a way to fetch ALL the views of a given table? Something like this:
let table = base.g...
Is it possible to pull all the “Views” of a given table via the API? I don’t mean specify a particular view as part of an API call, but rather, I want to pull ALL the views of a given table as its own list.
The table object doesn’t seem to have a vie...
I’m trying to build a sort URI with multiple sort fields and directions, but I don’t understand the syntax. Suppose I have this sort object with three fields/directions:
const sort = [
{ field: "title", direction: "asc" },
{ field: "value", direc...
Case_Larsen:
'Field SingleLineText cannot accept the provided value
I wish this said: Field SingleLineText cannot accept the provide value… because e.g. its type ‘Object’ is incompatible with the ‘String’ type of the field. (or something like ...
Yes! I do love me a Rube Goldberg machine, but this is [eventually] to convert image URLs to base64 strings with an async conversion function hitting each record. However, I’m now realizing that the Scripting app can’t utilize a lot of things like Fi...
Thanks @Kasra This is a VueJS app and my airtableClient for retrieving table records is below. Can I do something similar to retrieve a views object of a given table that contains the views id, name, record ids, etc. of that view?
getTable(table) {...