Select Page
Get Started with On2Air Backups
Get Started with On2Air Backups

Get Started with 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 tutorial

On2Air Backups Trial Information

In the On2Air Backups Trial, it will back up:

1 Airtable Base

10 Tables in that base

100 Records per table

25 Attachments (total)

After the trial creates a backup to your storage drive, it deactivates.

💡
To enable automated backups, upgrade to a plan

Once you’ve upgraded, you’ll then need to set the Schedule and Reactivate the backup.

📽️ How to Get Started with On2Air Backups - 5 minute video tutorial

📝 Step-by-Step Tutorial

1. Install the On2Air Backups Airtable Extension OR Use App.On2Air.com

💡
You have 2 options to set up your Airtable backups with On2Air. 1. Install the On2Air Backups Extension inside your Airtable base(s) to create the backup automation. 2. Use the On2Air web app at app.on2air.com If you need to backup multiple Airtable bases, it’s best to use app.on2air.com. You can start at Step 2 if you use app.on2air.com

  • First, open your Airtable base and click Extensions

image

  • Click Add an extension

image

  • Type On2Air in the search box and choose On2Air Backups

image

  • Click Add Extension to add it to your Airtable base

image

  • You’ll now click Create New Account to create an On2Air account. You’ll go through the account creation process.

If you’ve ever added On2Air Backups to other bases in your Airtable workspace, Select your On2Air account.

image

image

2. Connect Your Airtable Account

Now, you’ll need to connect your Airtable account via OAuth

  • Click the Configure Airtable API button

image

  • Go through the OAuth connection process

  • You’ll see an important message about being sure to choose All current and future bases in all current and future workspaces in the following OAuth settings window.

image

  • Click Connect to Airtable

image

  • Next, you’ll see a page to authorize On2Air to connect to Airtable

  • IMPORTANT: Click Add a base FIRST

image

  • For best results, choose All current and future bases in all current and future workspaces.

image

  • While you can choose individuals bases or workspaces, you will need to continually create OAuth connection authentications to On2Air if you ever want to use more than a single workspace, base, or all bases in your Airtable workspace.

  • Click Grant access

image

  • Your page will reload and display an “Authenticating” message”

image

  • You have now connected Airtable and On2Air!

Final

image

3. Connect Your Backup Location - Google Drive, Dropbox, or Box

Next, you’ll connect your cloud storage account in Google Drive, Dropbox, and Box.

  • Click Configure Backup Destination

image

  • Once you’ve connected to Storage, click Configure Backup Destination again, close the popup, and On2Air Backups will refresh and connect

4. Create a Backup Project

Once you’ve connected your storage drive, create your backup project

  • Click Create New Project
    • A Backups Project allows you to add 1 or multiple bases to a Project
    • image

Choose your Airtable base(s)

  • If you’re using the Extension, On2Air Backups will automatically detect the Airtable base you’re in.
  • Otherwise, choose your Airtable base

💡
If you see don’t see all of your Airtable bases, this likely means you only gave On2Air access to 1 Airtable base when setting up the OAuth connection. Go to the Accounts and Integrations page in your On2Air account. Choose your Airtable connection and click Reconnect to Airtable. This will go through the Airtable to On2Air connection process again. To allow us to access all Airtable bases and workspaces, choose 'All current and future bases in all current and future workspaces". You can also select specific bases if you prefer.

  • Click Configure Settings

image

Choose or create a folder in your storage drive

  • Next to Storage Connection, choose Update

  • By default, we’ll add the backup to the root of your storage drive. You can change to a specific folder

image

  • Now, you can Choose a folder from your storage drive or Create a New Folder where your backups will be sent

image

Then click Save Backups Details

image

Enable the Trial Schedule

  • Now that your folder is chosen, the Trial Schedule is automatically set to One-Time
  • Click Create Schedule

image

In the On2Air Backups Trial, we allow 1 Airtable Base, 10 Tables, 100 Records per table, and 25 Attachments (total). After the trial creates a backup to your storage drive, the backup project deactivates.

To enable an automated backup schedule, upgrade to a plan .

Once you’ve upgraded, you’ll then need to set the Schedule and Reactivate the backup.

To enable full automated backups, upgrade to a plan - Learn about backup schedule options and plans

5. Click Start Backup

  • Click Start Backup to start your Backup

image

  • The Status will change to Active while it creates a backup in your storage drive

image

  • Click Backup History to see the backups begin and when it’s done processing.

Backups will begin within approximately 1 minute. The initial backup takes time to complete the backup, depending on the number of records/fields in your Airtable base and the number of attachments. Subsequent backups will not take as long as we back up only the specific changes made.

  • You can click Refresh on the Backup History page to watch the progress.

image

6. Upgrade for Automated Backups

To fully automate Airtable backups, upgrade to a Backups plan

On2Air Backups Plan

The Backup Schedule options available will depend on your plan

Available Plans and Schedules

STARTER - $9.99/month - UPGRADE 1 Airtable Base, 50,000 Records, 2,500 Attachments - Monthly Backup Schedule

ESSENTIALS - $29.99/month - UPGRADE 15 Airtable Bases, 250K Records, 25K Attachments, - Monthly or Weekly Backup Schedule

PROFESSIONAL - $49.99/month - UPGRADE 50 Airtable Bases, 1 Million Records, 500K Attachments - Monthly, Weekly, or Daily Backup Schedule

PREMIUM -$79.99/month - UPGRADE 250 Airtable Bases, 5 Million Records, 1 Million Attachments - Monthly, Weekly, Daily, Hourly Backup Schedule

SCHEDULE OPTIONS

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)

7. Choose Your Backups Automation Schedule (Paid plan)

  • Once you’ve upgraded, you need to set your new automated Schedule
  • In your Backups Project, click Settings, then click Schedule

image

  • Choose your Backup Project Interval and Interval Value

image

  • Click Update Schedule

Enable Your Backup

Once you’ve set your backup schedule (paid plans), click Start Backup

image

Customize Your Backup (Include/Exclude Fields, View, and Attachments)

You can customize what’s included in your Airtable base backup, such as specific fields, views, or attachments.

Backups History Log

See how you can view all your backups details and history

Backup Folder Structure and File Name Convention

Learn how we name the files and attachments in your storage drive

Need Support?

Send us a message. If we’re online, we’ll get back to you as soon as possible. If not, we’ll follow up by email.

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

  • In your Backup Project, click the Settings tab
  • Click Schedule

image

  • Choose your Backup Project Interval - Trial mode will allow you to select a One Time backup interval
image
  • Click Create Schedule

image

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_