An extension of Airtable’s Currency Conversion script: Airtable Scripting
Rather than assuming what currency you want to convert to, this script pulls in the list of all known conversions into its own table (using USD as the base currency). You can t...
OpenAPI is an API specification format which provides a way of creating a standard format to represent a given REST API. There’s a large community of tools built on top of the OpenAPI definition, including mock servers, schema visualizers, and SDK g...
A common theme we are seeing with project management bases is the desire to have project and task templates. When you create a new project, it can then generate the corresponding set of tasks, and maintain the basic details about those tasks, includ...
422 errors generally mean either the request was formatted incorrectly or the datatypes you are trying to insert into the base don’t map to your schema.
The only thing I can see that potentially indicates the API might be rejecting the request format...
For single select values, you have to structure the data as an object where the object either contains the option ID or the name you see in the product. In practice, I generally use the single select name (since a single select does not allow duplic...
This is the section of code where you define what the “live” tasks should look like after they are duplicated from your templates. This example only fills in the basic values that we need:
for(let t of task_temps) {
payloads.push({
field...
It’s likely because the project template you are linking to doesn’t have any tasks assigned to it. When you do r.getCellValue(field_name) on a linked record field, it returns “null” if the field is blank (and you can’t iterate over null).
At line 52...
Airtable’s API allows you to issue create, read, update and delete operations into any base you have access to. It also dynamically modifies itself to match a given base’s schema. As you add and modify fields and tables, the API will automatically ...
