You can create apps in AppSheet with data from AirTable. To do this, you need to first add an AirTable data source to your AppSheet account. In your account page, open the Data Sources tab and click on the add data source button.
Name your new data source and select AirTable. To connect to AirTable, you need to provide the following information:
- Your AirTable API key
- The ID of your AirTable base
- The names of tables in your AirTable base
To learn how to obtain your AirTable API key, please read the relevant documentation on the AirTable site. A valid AirTable API key must always start with the word "key".
To obtain the ID of your AirTable base, open the AirTable Standard API page and click on the AirTable base that you want to use. This will open the API page of the base.
The base ID can be found in the URL of the API page of the base. In the URL, the base ID is immediately after "https://airtable.com/" and starts with the word "app".
Finally, type in the names of the tables in your AirTable base. The table names must be separated by commas. Test and save the connection.
Once you have added your AirTable data source, click on Make a new app on the My Apps page, select your AirTable data source as shown in the images below, and you'll be able to create an app using one of the tables in AirTable that you have added.
Select a table and AppSheet will analyze the table and attempt to create a new app using the table's data. If the table is empty, i.e. the table has no row, AppSheet won't be able to analyze the table at all. If the table isn't empty but contains blank columns, all blank columns will be skipped by AppSheet. Therefore, to enable AppSheet to analyze and derive the column structure of the table you select, you must ensure that there is at least one row in the table that contains no blank column.
When you add a new table from AirTable to your app, AppSheet will analyze the data types of the table's columns, and will map these data types to their corresponding AppSheet data types. Below is a list of AirTable data types that are currently supported by AppSheet and their default AppSheet counterparts. Note that for certain AirTable data types, such as Currency, you can override the default types selected by AppSheet and choose a more appropriate type, such as Price.
- Single line text: Text
- Long text: Text
- Attachment: Image or File
- Checkbox: Yes/No
- Single select: Text
- Multiple select: Enum List
- Collaborator: Email, Name
- Date or Created Time without time field: Date
- Date or Created Time with time field: DateTime
- Phone number: Phone
- Email: Email
- URL: URL
- Number: Decimal
- Currency: Decimal
- Percent: Decimal
- Rating: Decimal
- AutoNumber: Number
- Barcode: Text
- Formula: the AppSheet data type is determined by the output data type of the formula
Certain AirTable data types allow the user to store multiple values per cell. For instance, multiple images or files can be stored in a single cell of an Attachment column. Except for Multi-select columns, this behavior is currently not supported by AppSheet.
The values of AirTable columns of type Created Time, AutoNumber, and Formula are automatically computed by AirTable. As such, these columns must be marked as read-only in AppSheet. Any attempt to edit these columns via an AppSheet app will result in an error.
AirTable differs from other cloud-storage providers, such as Google, in that it does not have a file system. In the case of AirTable, images and files are always stored in the main cloud file system associated with the app creator's primary AppSheet account, be it Google Drive, Dropbox, Office 365, or Box.
When your AppSheet app captures and saves an image or file, AppSheet creates a new file in the main cloud provider's file system for each image or file, and writes the image or file data to that file. It then places the URL of this file into the attachment column in AirTable. The files will be saved in a sub-folder of your account's default folder path (usually .../appsheet/data). You can view and change the default folder path in your account page under the Settings tab.
Note that files or images that are added directly to AirTable will be saved in AirTable's server instead of your cloud storage provider's.