What We Backup and How It Works

On2Air Backups creates automated backups of your Airtable data and sends the data to your storage drive in Google Drive, Dropbox, and Box.

In this tutorial

In the U.S.

The Cybersecurity and Infrastructure Security Agency, America’s Cyber Defense Agency, deems data backup as an essential element for ensuring cybersecurity in businesses and organizations.

One of the essential elements of being prepared against cyber risks is to “Employ a backup solution that automatically and continuously backs up critical data and system configurations.”

The recommended backup structure by the US Computer Emergency Readiness Team is the 3-2-1 structure.

In the UK The National Cyber Security Centre recommends making backing up part of your everyday business. All businesses, regardless of size, should take regular backups of their important data, and make sure that these backups are recent and can be restored.

Airtable is susceptible to outages, incidents, and downtime just like any other software tool.

When you export your critical data from Airtable into another location, you’ve implemented best practices for protecting your business.

Many of our customers create an automated Airtable backup with On2Air Backups for one or more of the following reasons:

We back up Airtable

We create CSV files (.csv) and export Attachments in the same format they are uploaded into Airtable. We also include a JSON file with a backup timestamp.

You can see the structure of how we add data to your storage drive:

The Airtable API doesn’t yet provide options for us to backup:

We back up the entire Airtable Base as individual CSV files per Table in your base. Linked Records are backed up as a Record ID field in the CSV. This will be a Record ID field in the CSV file and can be used to match records if needed.

We are unable to create automatic bi-directional links from a record to a linked record. You will need to open the other Linked table CSV file and search for it via Record ID.

On2Air Backups is a service to provide you an additional backup location for your Airtable data in a separate location and format other than Airtable.

If you were to completely lose your base, no 3rd party tool is capable of re-building it from scratch. Airtable doesn't yet make it possible through their API for a 3rd party tool to programmatically fully restore an Airtable Base, Table, and Fields (example: can't create Formula fields with the API, etc).

While some companies who have an Airtable backups app offer an automatic backup restore option, the process in which they both backup and restore your data violates Airtable’s Terms of Service. We do not recommend their method.

If a field value was deleted in a record, we encourage you to first use Airtable’s Revision features

Learn how: Record-level revision history overview

You can also view the Base Trash. The trash function allows to see and restore the tables, views, fields, extensions, and records that have been deleted in a base in the past seven (7) days.

Learn how: Base Trash

You can view more in their Data Recovery and Deletion section

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.

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

Every cloud storage provider, Google Drive, Dropbox, and Box offers Revision History, so you can see any changes made in your Backup files.

Version History in Google Drive

Version History in Dropbox

Version History in Box

You can view your Airtable data in a backed up version in your storage drive. The files should be used only as a reference for viewing data, not editing data. Any changes you make are not synced back into Airtable.

On2Air Backups creates the backup files as CSV files and each table is its own CSV file. You’ll need to make each CSV file available offline.

Regarding Linked Records - We display the Linked Record as the Record ID. We are unable to create automatic links from a record to an attachment.

You won’t be able to to click to get to the linked record like you do in Airtable. You will need to open the other linked table file and search via Record ID.

Google Drive Offline

Use Google Drive files offline

Dropbox Offline

Make your Dropbox files available offline

Box Offline

Make Box files Available Offline

Subsequent backups will not take as long as we back up only the specific changes made.

For fields, tables, and views, you can limit changes and deletions by making Users at an Editor level rather than Owner/Creator.

For further mitigation of altering records or base layout schema, a portal/dashboard like Airtable Interfaces, Noloco, Glide, Softr can come in extremely valuable.

You don't have to create them as a User in Airtable and you can customize what data and fields they can view/edit. You're sharing data to create or edit, but not allowing any schema changes or allowing access to the base.