Select Page
How to Create a Backup - Previous version

How to Create a Backup - Previous version

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.

image

In this article

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.

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
image

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

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
image

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
image

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
image

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

image

Weekly - Choose any day of the week

image

Daily - Choose a time of day * Choose a specific hour of the day * Toggle Yes to Include Weekends (Optional)

image

Hourly - Choose hourly * Toggle Yes to Include Weekends (Optional)

image

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

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

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
image