Data Sources
Connecting your project to a data source allows you to work with the information that you have stored in Airtable, Google Sheets, Webflow or a local table.
Last updated
Was this helpful?
Drag and Drop
Connecting your project to a data source allows you to work with the information that you have stored in Airtable, Google Sheets, Webflow or a local table.
Last updated
Was this helpful?
The data sources blocks allow you to perform a variety of CRUD (Create, Read, Update, Delete) operations on records you have stored in Airtable, Google Sheets, Weblow or a local tables.
There are two ways to connect your app to a source:
Add a Data Viewer (list or grid) to your project. More on Data Viewers is available here: Data Viewers, OR
Click the Data Sources icon in the menu on the far left and click the ⊕ icon.
In the modal that appears, select a previously connected Data Source, or add a new one.
When connecting to a new data source, select from one of the following options: • Create your own table • Airtable • Google Sheets • Webflow
To create your own table as a data source:
Follow the steps above: Connect Your App to a Data Source and select Create your own table.
Give your local data source table a name.
Click Create.
To add data to your local table, copy and paste it from another source or click into a cell and type to input the data.
To modify the table's columns:
To update the table’s column headers, click their names and typ a new header name.
To add additional columns, click the + New Column button.
To delete columns, click the x in the column’s title box.
To modify the table's rows:
To add additional rows, with your cursor in the bottom row, press your keyboard’s enter or return key.
To delete a row, right-click on it and select Remove row.
Select your preferred storage option:
App Data Source - If the data is changed while the app is open, the table's data resets when a user of your app closes and reopens the app. This reduces the time it takes for the app to load on the user's device.
Stored Data Source - If the data is changed while the app is open, the table's data persists when a user closes and reopens the app.
When your table is complete, click the X in the upper right.
The newly created local data source is now listed in your project's list of data sources.
Click the pencil icon to rename the data source.
Click the data source's name to review and edit the data.
Click the trash can icon to delete the data source from your project.
When using Airtable as your data source, a base is connected to Thunkable. To connect your Airtable base to your Thunkable project, you have two options:
API Key (supported until Jan 31, 2024)
OAuth
Navigate to your Airtable account page.
Copy your API key (a 14-character code beginning with "key").
Return to your Thunkable tab.
Paste the copied Airtable API token into the corresponding field.
Click Refresh to see your Airtable bases.
Select the base you want to use as your data source.
Click Create.
Click Connect to Airtable.
An Airtable authorization screen opens.
Click + Add a base.
Select the bases you want to authorize access to.
Click Grant access.
Select the correct base from the dropdown menu.
Click Create.
In Airtable, a table is similar to a sheet in a spreadsheet. You can have multiple tables within your Airtable base, and each table can have multiple views. A view indicates how the data is presented within the table. For example, you can use views to show only specific fields or records and apply other configurations to manage the information in that view. The initial default view for an Airtable table is the grid view.
When connecting an Airtable base as your Thunkable project’s data source, you can select a custom view instead of the default grid view. This will apply only to the first table in your base. For subsequent tables, Thunkable will use the default grid view. If you have a base with two tables and the second table has a custom view, you can reorder the tables within the base in Airtable so that the custom view is applied to the correct table.
Once you've connected your Airtable the Thunkable account via OAuth, API keys are no longer used.
In Google Sheets, the entire document is considered to be the data source.
To use a Google Sheet as a data source the following must be true:
The first row in your sheet must be a header row and every column must have a header.
Your Google Sheet must be sharable so that Thunkable can access the data.
To connect a Google Sheet, sign in and grant permission for your Thunkable project to access your Google Drive.
Some users have reported issues connecting to Google Sheets if they are using G Suite for Education accounts. You may need to contact your G Suite administrator to review your security settings.
Once you have allowed this, you will see a list of spreadsheets in your Google Drive. If you don't see the sheet you are looking for you can switch to list view, sort alphabetically or search for the one you need. Click Select to return to your Thunkable project.
At this time, connecting to .xlsx files that are hosted on Google Sheets is not supported. You can convert your .xlsx file to a Google Sheet before connecting it to your Thunkable app project. Simply open your .xlsx file on Google Sheets, then click File > Save as Google Sheets.
When using Weblow as the data source for your Thunkable app, you’ll connect to a Webflow CMS or Content Management System collection.
To connect your Webflow CMS to your Thunkable project, you have two options:
API Key
OAuth
Within the Webflow platform:
Navigate to your site settings.
Click the Integrations tab
Under the API access header, click Generate API token.
Copy the Webflow API token.
Within the Thunkable platform:
Paste the copied Webflow API token into the corresponding field.
Click Refresh to see your Webflow sites.
Select the site you want to use as your data source.
Click Create.
Click Connect to Webflow.
A Webflow authorization screen opens.
Select the sites or Workspaces you want to authorize access to.
Click Authorize app.
The create row inblock allows you to append new rows to the end of your data tables.
The inputs are dynamic so if you change the name of Column 1 or Column 2 in the designer these changes will be reflected in the block too.
The get value from blocks allows you get read one value from a specific cell in your data table. You can specify the column name in the block itself and pass the unique row id as an input.
Note that each row has its own unique 24 character ID. You must use this ID to refer to rows of your Airtable and Local data sources in the blocks below.
If your data source is a Google Sheet, you can refer to the row by its integer position (1 for the first row, 2 for the second row, etc.)
Get row object will return the row object of the specified row ID. The row object can be used with Objects blocks.
The list of values in block allows you to read an entire column of data from a table and returns it as a list that you can then manipulate with the built-in List blocks.
The number of rows in block returns an integer corresponding to how many rows are in a given table.
You can use the update value in block to modify or update an existing cell in your data table. The column name is specified in the block itself. Both the row id and new value are passed as inputs.
You can use the Delete Row block to delete a row of data from your Data source.
The row id is passed as an input.
If there is an error, the error message is passed as an output.
You can use the delete all rows block to delete all rows in your data source.
If there is an error, the error message is passed as an output.
Have feedback on this doc? Please take a moment to share your feedback here: Thunkable Docs Feedback. Your valuable insights will help us improve and better serve you in the future.
