Make the best use of Airtable via Shortcuts.

How to Use

Get an API Key

You will need a personal API key. You can get one by visiting your Airtable account page under the API section. Have the API key ready when you first run the shortcut.

Setup

With your API key ready, run the shortcut. You will be prompted with a set of steps on how to setup your configuration. Configuration includes the following items

Creating the /AirtableKit/ folder

folder Creating the /AirtableKit/airtable.json file

file Storing the API key.

(optional) Saving a list of your base IDs in the /AirtableKit/ folder

Usage

You can download a demo shortcut by running AirtableKit and choosing Download Demo .

The way it works is that you will need to pass a dictionary of the function that needs to be called and the relevant data.

Common Arguments

Key Description fn The function to call base The base name or base ID of the relevant base table The table the is needed to be accessed

Functions and arguments

createRecord

Key Description fields A dictionary of keys and values for the data to be added

updateRecord

Key Description record_id record id of the record that needs to be updated fields A dictionary of keys and values for the data to be updated

listRecords

Key Description filter optional. A filter expression view optional. View name of a custom view defined in Airtable pageSize optional. The number of records returned in each request. Must be less than or equal to 100. Default is 100. maxRecords optional. The maximum total number of records that will be returned in your requests. If this value is larger than pageSize (which is 100 by default), you may have to load multiple pages to reach this total.

getRecord

Key Description record_id record id of the record that needs to be accessed

deleteRecord

Key Description record_id record id of the record that needs to be deleted

Format of the fields parameter

fields is a dictionary containg the Airtable field names as keys and their corresponding values. A simple fields value would be something like this:

{ "Field1": "value1", "Field2": "value2", "Field3": "value3" }

In case of values that are linked to records to another table, you usually pass an array of the id s of the related records. Example:

{ "Field1": "value1", "Field2": "value2", "Field3": "value3", "LinkedField": [ "reqQead8349" ] }

AirtableKit allows this, it would mean that you need the id s beforehand. As of v1.3.0, it is easier to add linked records when creating or updating records.

{ "Field1": "value1", "Field2": "value2", "Field3": "value3", "LinkedField.linked": { "table" : "Another Table", "filters" : [ "field1='xvalue1'", "field2='xvalue2'" ] } }

The format of the linked field would be as follow:

Key : The fieldname suffixed by .linked to signify AirtableKit that this is a linked fields. Value : A dictionary containing 2 keys, (2) the name of the table where to find the linked record, and (2) an array of filters to locate the linked record.

Table1

T1Col1 T1Col2 Value1 Some Description Value2 Another Description

Table2 - T2Col2 is a link to a record in Table1

T2Col1 T2Col2 V1.1 Value1 V1.2 Value1 V2.1 Value2

If we were to insert a record in Table2 for example, the fields parameter would be structured like this:

{ "T2Col1": "V2.2", "T2Col2.linked": { "table" : "Table1", "filters" : [ "T1Col1='Value2'" ] } }

Roadmap

~~Save API Key~~

~~Basic CRUD~~

~~Cache base list~~

Attachments

Cached tables list

Links