Create a Backup


On2Air: Backups is an automated backup solution 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.

Learn more about On2Air: Backups



In this article

How to Create a Backup Project
Backup Folder Structure
Adding Your Airtable Bases to Your Backup Project
Customize Your Base Backup
Set Your Backup Schedule
Enable Your Backup
Backup Project Settings
Individual Base Backup Settings
History Log

How to Create a Backup Project

Before creating a backup project, it’s best to first connect your Airtable account and backup storage location such as Google Drive, Dropbox, or Box, in Accounts and Integrations.

Learn how to set up new connections

Creating Your Backup Project

Click New Backup or Create New in the Backups menu

Select Configure in Settings

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



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



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



Customize Your Base Backup

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 Views, all Fields, and all Attachments are included in your Backup

To customize what’s included in a table backup, click the name of your desired table or click the Detail Button

Table Settings

Table - Displays a menu of the Airtable connection, Airtable base, and table from the base you are currently viewing and editing

Refresh - Populate any new tables from your Airtable base to display in your table list
Click Refresh

Customize Views and Fields

To customize by View or Field

Click Update next to Views and Fields
Views and Fields - Customize Views and Fields in a table
You can choose to Include Fields or Exclude Fields

Once a view or field is chosen, click Add new option to add more views or fields

Click Update Fields



Customize Attachments

To customize Attachments

Click Update next to Attachment Fields

Enable Attachments - Choose whether to enable or disable attachments

Attachment Fields - Customize specific Attachment Fields
You can choose to Include Fields or Exclude Fields

Click Update Attachments



Set Your Backup Schedule

From your Backup Project homepage, click the Settings tab

Click Schedule

Choose your Backup Project Interval

Schedule - You can choose to backup your bases

The backup schedule intervals 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

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



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



Set Your Backup Schedule

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

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

History Log

The History Log is a log of every backup instance in your project 

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

Was this article helpful?
Cancel
Thank you!