Airtable

Effective February 1, 2024, Airtable no longer supports connecting via API key. You must connect your Thunkable project to Airtable via OAuth and use Data Source blocks.

Video Tutorial

Airtable Overview

Airtable is a service that looks like a spreadsheet but actually acts like a database so it can do database-like things like store attachments i.e. images in your spreadsheets (and not just text) and link records between spreadsheets.

We like Airtable because set-up is relatively a breeze for a spreadsheet

Getting Started

Create your free Airtable base and account

Connect Your Airtable Base with Thunkable

There are four properties that you need to retrieve from Airtable to connect it with Thunkable: API key, Base ID, Table Name and View Name

API Key

To retrieve the API key, you'll have to navigate to the Account page and generate an API Key

Base ID

To retrieve the Base ID, navigate to the Airtable API documentation page and select your spreadsheet. You will see the Base ID in the 'Introduction' section of this page.

Table Name and View Name

The Table Name and View Name can be retrieved by grabbing the fields from your spreadsheet as shown below. Your default Table Name should be "Table 1". Your default View Name should be "Grid View".

Getting, Uploading, Updating, and Deleting data

Getting Data

Getting items for a ListView from an Airtable column

Event

Description

Get Cell (rowNum, columnName)

Returns the value of a specific cell

Get Column (columnName, maxNumRows)

Returns a column as a list

Get Row (rowNum)

Returns a row value as an object

Get All Rows

Returns rows as an object

Get Selected Rows (startingRowNumber, numRows)

Returns rows as an object based on a specified startingRowNumber and numRows

Uploading and Updating Data

Event

Description

Create Row (rowObject)

Uploads a new row of data based on a rowObject

Set Cell (rowNum,columnName,value)

Updates the valueof a cell in a particular rowNum and columnName

Update Row (rowObject)

Updates a row based on a rowObject

Update Row Num (rowNum, rowObject)

Updates a row based on a rowObject and a rowNum

Replace Row Num (rowObject)

Replaces a row based on a rowObject

Replace Row (rowNum, rowObject)

Replaces a row based on a rowObject and a rowNum

Deleting Data

Event

Description

Delete Row Num (rowNum)

Deletes a row based on rowNum

Delete Row (rowNum, rowObject)

Deletes a row based on a rowObject and a rowNum

Last updated