On2Air: Backups is an automated backup app for your Airtable bases. Create scheduled backups of your critical business data stored in Airtable and export your information to Dropbox, Box, or Google Drive.
_(2)/w=3840,quality=80,fit=scale-down)
In this article
- 1. Install the On2Air Backups App in Your Airtable Base
- 2. Connect Your Airtable Account
- 3. Connect Your Cloud Storage Account (Google Drive, Dropbox, or Box)
- 4. How to Create a Backup
- 5. Customize Your Base Backup (Include/Exclude Fields, View, and Attachments)
- 6. Set Your Backup Schedule
- 7. Enable Your Backup
- History Log
- Backup Folder Structure
1. Install the On2Air Backups App in Your Airtable Base
First, install the On2Air Backups app into your Airtable base from the Airtable Marketplace.
2. Connect Your Airtable Account
Now, you’ll need to connect your Airtable account
- First, copy your Airtable API Key - How to Find your Airtable API Key
- Click Configure Airtable API
- Paste your Airtable API key into the On2Air Backups API Key field
You can label the Connection whatever you would like
- Activate the Airtable Connection toggle
- Click Save Changes
3. Connect Your Cloud Storage Account (Google Drive, Dropbox, or Box)
Next, you’ll connect your cloud storage account in Google Drive, Dropbox, and Box.
- Click Configure Backup Destination
Depending on your cloud storage option, the setup will look slightly different
Once you’ve accepted permissions and connected your account, you can now create a backup.
4. How to Create a Backup
Click Create New Backup
- The Backups app will automatically detect the Airtable base you’re in
Click Configure Settings
- Next to Storage Connection, choose Update
- Now, either choose or create the specific folder in your storage where your backups will be sent
5. Customize Your Base Backup (Include/Exclude Fields, View, and Attachments)
- In the Bases tab, click the name of your desired Airtable base or click the Detail Button
- A list of all tables in your base will be displayed
- By default, all Tables, Views, Fields, and Attachments are included in your Backup
- To customize what’s included in a table backup, click the name of your desired table, find Views and Fields, and click Update
- Choose your view or fields to include or exclude in your backup
6. Set Your Backup Schedule
- From your Backup Project homepage, click the Settings tab
- Click Schedule
- Choose your Backup Project Interval
The backup schedule options available will depend on your plan - See On2Air Pricing for more information
Monthly - Choose a day of the month Options are: * 1st day of month * Mid month (15th) * Last day of month
Weekly - Choose any day of the week
Daily - Choose a time of day * Choose a specific hour of the day * Toggle Yes to Include Weekends (Optional)
Hourly - Choose hourly * Toggle Yes to Include Weekends (Optional)
Once you have chosen your backup schedule, click Create Schedule or Update Schedule if changing
7. Enable Your Backup
Once you have chosen all the Views, Fields, and Attachments, and have set your backup schedule
- Toggle your Backup Project to Enabled
History Log
The History Log is a log of every backup instance in your project with a link to the backup folder in your online storage
It displays:
- Backup Status
- Backup Destination Folder You can click this link to be directed to your backup folder
- Number of Bases
- Number of Tables
- Number of Records
- Number of Attachments
- Click Refresh to see the most up-to-date backups
Backup Folder Structure
The folder and file structure for your backups
YourFolderName --> BackupProjectName_AirtableID --> BaseName_AirtableID --> TableName.csv or TableName.json
BaseName_AirtableID --> Attachments --> TableName_AirtableID --> FieldID_RecordID_AttachmentID_NameOfFile
Also, in Attachments
Attachments --> Attachments_TableName.json
Dropbox Folder Structure
Box Folder Structure
Google Drive Folder Structure
Airtable Base Used in Backup
Individual Base Backup Settings
Base - Change the Airtable connection or Airtable base included in your Backup Project
* Click **Update** * Choose your desired Airtable base * Select **Update Backup Base**
Auto Add New Tables - Choose Yes if you would like any new tables added to your base automatically added to your Backup Project
Auto Add New Attachments - Choose Yes if you would like any new attachment fields added to your base automatically added to your Backup Project
Backup Format - Export the backup in CSV or in JSON format
Remove From Project - Remove a base from your Backup Project * Click Remove Base
Rename Backup - Click in the Backup Title field and rename your Backup * Click out of the field to automatically save
Back to Previous Page - Each page of the app includes a button at the top to go back to the previous screen
Adding Your Airtable Bases to Your Backup Project
- In the Bases tab, click Add Base to Backup
- Click Select Connection and choose your desired Airtable connection If you haven’t connected to your Airtable account, set up the connection in Accounts and Integrations by clicking Add a new connection in the integration settings
Learn how to set up new connections
- Select the Base you want to add to your backup
- Click Add New Backup Base
Backup Project Settings
Storage
- Click Select Storage Connection
You can connect to Google Drive, Dropbox, or Box depending on your plan If you have not connected your Backup Storage account, set up the connection in Accounts and Integrations by clicking Add a new connection in the integration settings
Learn how to set up new connections
- Click Select Connection and choose your desired backup storage location The root folder location in your storage account will appear
- Click Create New Folder (Recommended if first backup project) and give it a name such as On2Air Backups
- Choose your newly created folder
- Click Save Backup Details
Delete Your Project
Delete - If you no longer want your Backup Project
* From your Backup Project, select the **Settings** tab * Click **Delete Backup** _**WARNING**: Deleting a backup cannot be undone_