📐
Thunkable Docs
Build an AppDrag and Drop DocsSnap to Place Docs
Snap to Place
Snap to Place
  • 👋Welcome to Thunkable Docs
  • 👶Getting Started
    • Signing In
    • Your Thunkable Projects Page
    • Tutorials
    • Live Test your App
  • 🆕Create New Project
    • Project Settings
    • Project Assets and Sizes
  • Thunkable Sample Projects
  • Public Gallery of Projects
  • 🛠️ Components
  • 🔘User Interface
  • Button
  • Label
  • Text Input
  • List Viewer
  • Web Viewer
  • Switch
  • Slider
  • Alert
  • Loading Icon
  • Date Input
  • Time Input
  • PDF Reader
  • Rating
  • 📊Data Viewers
  • Data Viewer List
  • Data Viewer Grid
  • Custom Data Viewer Layout
  • Data Sources
  • 📐Layout
  • Top Tab Navigator
  • Bottom Tab Navigator
  • Stack Navigator
  • Drawer Navigator
  • Screen
  • Row
  • Column
  • 📷 Image
  • Image
  • Photo Library
  • Camera
  • Barcode Scanner
  • Image Recognizer
  • Animation by Lottie
  • Video
  • Video Recorder
  • 🗄️ Data
  • Local Storage
  • Local DB
  • Realtime DB by Firebase
  • Airtable
  • Media DB by Cloudinary
  • File Picker
  • Web API
  • 🌍Location
  • Maps by Google and Apple
  • Location Sensor
  • 💲Monetization
  • Ads by AdMob
  • In-App Purchase
  • 🌐Sensors
  • Gyroscope
  • Magnetometer
  • Accelerometer
  • Timer
  • Bluetooth Low Energy
  • 🔊Voice
  • Sound
  • Text to Speech
  • Speech Recognizer
  • Translator
  • Audio Recorder
  • 🤝Social
  • Share
  • Email Sign In by Firebase
  • Push Notifications by One Signal
  • 🎮Gaming
  • Canvas
  • Sprites
  • Sprite Gallery
  • Canvas Label
  • 🤖Gaming Blocks🎮
  • Events
  • Motion
  • Looks
  • Direction
  • Sensing
  • Add & Remove
  • Stage
  • Canvas Label
  • 🤖Blocks
  • Control
  • Logic
  • Math
  • Text
  • Lists
  • Color
  • Objects
  • Device
  • Variables
  • Functions
  • "Any Component" Blocks
  • 🖥️ App Services & Emulators
  • 🔒App Data Privacy
  • ➕Make Copy
  • 📥Download
  • 📤Share
  • 📱Publish
  • Publish to App Store (iOS)
    • TestFlight Overview
      • TestFlight in Depth
  • Publish to Play Store (Android) with AAB
  • Publish as a Web App
  • Generate Screenshots
  • 🔎Troubleshooting
    • Login Issues
    • FAQs
  • 📏Intro to Spacing
  • 🖼️ Intro to Sizing
  • 🔤Fonts
  • 💾Managing Storage
  • 📝Bugs and Product Feedback
  • Snap to Place Hour of Code Videos
Powered by GitBook
On this page
  • Video Tutorial
  • Airtable Overview
  • Getting Started
  • Create your free Airtable base and account
  • Connect Your Airtable Base with Thunkable
  • API Key
  • Base ID
  • Table Name and View Name
  • Getting, Uploading, Updating, and Deleting data
  • Getting Data
  • Uploading and Updating Data
  • Deleting Data

Was this helpful?

Export as PDF

Airtable

PreviousRealtime DB by FirebaseNextMedia DB by Cloudinary

Last updated 8 months ago

Was this helpful?

Effective February 1, 2024, Airtable no longer supports connecting via API key. You must connect your Thunkable project to .

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

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

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

Create your base and account

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

free Airtable
Airtable API documentation
Airtable via OAuth and use Data Source blocks