Here’s how your files and attachments are structured and labeled inside your storage drive with On2Air Backups
In this tutorial
Backups and Backup Projects
Each Backup scenario you create in On2Air Backups is a Backup Project. You can add a single or multiple Airtable bases to a Backup Project.
Here’s an example of a Backup Project named Company Data that contains multiple Airtable bases that are backed up.
The main folder in your storage drive is the name of your Backup Project in On2Air Backups
Once inside the Backups Project folder in your storage drive, you’ll see a list of all the Airtable bases in your Backups project.
Bases are labeled by the Base name and the internal On2Air database ID
You’ll also see a latest_sync.json file
The JSON file contains data about your backup such as date backed up, number of bases, tables, attachments internal IDs, updated date, and other data.
Inside each Airtable Base folder are CSV files for each Table in your Base.
They are labeled:
Depending on your storage system, you may need to download them to your device to view as a CSV.
Each Airtable record will be a row in your CSV.
Most field types are displayed just like they are in your Airtable base. However, there are a few that display differently.
Linked Records - These will be displayed as a Record ID to ensure proper mapping of each unique linked record
- To “visualize” a Linked Record value, add a Lookup field in your base for each Linked Record field to view the name of the linked record
Attachments - You’ll see the auto-generated Airtable URL of each attachment. Attachment URLs in a single field are separated by a comma (,)
Dates - Dates are represented as YYYY-MM-DDTHH:MM:SS.SSS
- To “visualize” a standard format date, add a Formula field in your base that uses the SET_TIMEZONE and DATETIME_FORMAT operator
DATETIME_FORMAT( SET_TIMEZONE( Created, 'America/Los_Angeles'), 'MM-DD-YYYY h:mm A' )
Inside each Table folder is a folder labeled attachments for all the attachments in that specific folder. Attachments are exported in the same file format they are in our Airtable base.
Attachments are labeled in the following format in their respective folder
Attachments naming convention: