Select Page
How to Create an Airtable Backup in On2Air Backups

How to Create an Airtable Backup in On2Air Backups

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.

image

In this article

Quick Video Overview

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

image

  • Paste your Airtable API key into the On2Air Backups API Key field

image

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

image

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

image

  • The Backups app will automatically detect the Airtable base you’re in

Click Configure Settings

image

  • 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

image

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

image

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

image

Box Folder Structure

image

Google Drive Folder Structure

image

Airtable Base Used in Backup

image

Previous Versions

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**

image

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

image

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

  • Select the Base you want to add to your backup
  • Click Add New Backup Base
image

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

  • 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
image

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_