Airtable

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