Get Started with On2Air Schemas. On2Air Schemas generates a diagram to visualize your Airtable base structure and track changes to meta information for all tables, view, fields, and relationships. Understand and view your Airtable base configuration at a glance.
- 1. Install the App from the Airtable Marketplace
- 📽 Get Started Videos
- 2. Generate Your New Schema
- 3. About the Schema Diagram
- 4. Diagram Expanded Field Information
- See all available Options included in the Details tab
- 5. Field History - Expanded View
- 6. Field Relationships - Expanded View
- 7. Field Visibility within Views - Expanded
- 8. Field Notes - Expanded
- Create Filters to View Your Schema in Different Ways
- Snapshot History of your Schema
- See Changes in Base, Tables, Views, and Fields
- TABLES Tab
- VIEWS Tab
- FIELDS Tab
- Share Your Schema
- Print Your Schema
- Export Your Schema
- Delete Your Schema
- 💬 Need to Chat?
- 📽 Leave Video Feedback
- 💻 Want a Demo?
1. Install the App from the Airtable Marketplace
📽 Get Started Videos
You can expand each video to full width by clicking the expand icon on the bottom right of the video
📽 Start Using On2Air Schemas
📽 On2Air Schemas - Filters
📽 Snapshots and History Tracking
📽 Schemas List View
📽 Share, Export, or Print Your Schema
2. Generate Your New Schema
Once you’ve added the app, your schema diagram will automatically be created!
If you have between 1 - 49 tables, you’ll see the diagram right away
If you have 50+ tables, they will be minimized. Click on each table to expand the table.
3. About the Schema Diagram
You can move all your tables around to view the schema.
You can hover over the fields to see Field Descriptions and the Field type
If you have Relationships chosen in your filter, you can hover over fields and click on each field to see connected fields and tables
4. Diagram Expanded Field Information
When you click on any field from the Diagram area, another window will showcase more details about each field, such as the field type, formula, referenced fields in the formula, and more. Depending on the field type, you can see a variety of advanced information about each field.
See all available Options included in the Details tab
- Field Type
- If the Field is Editable
- If the field is a Primary Field
- If the Formula is Valid
- Actual Formula
- Formal Result Type
- Rollup Linked Record Field
- Rollup Field in Linked Table
- Is the Result is an Array
- Fields Referenced in the Formula (Click any reference field to see details about that field)
- Linked Records - Inverse Linked Field
- Linked Record - Allow Multiple Links
- Linked Record - Reverse Order
- Single or Multiple Select - Choices
- Single or Multiple Select - Colors Disabled
- Button - Label
- Button - Color
- Button - Action
- Button - Formula
- Lookup - Linked Record Field
- Count - Linked Record Field
- Currency Symbol
- Decimal and Currency Precision
- Currency and Number - Allow Negative
- Number Format
- Attachments - Is Reversed
- Collaborators - Notify on Select
- Date Format
- Date Timezone
- Checkbox Icon
- Checkbox Color
5. Field History - Expanded View
You can view any changes to the specific field and when it happened. You can view changes to formulas, and name changes to fields, tables, or the base.
6. Field Relationships - Expanded View
You can view all Field Relationships, where they are linked, and where they are referenced. You can view any formula, rollup, lookup, count and other relationships. You can click through to any other related or referenced field.
7. Field Visibility within Views - Expanded
In View, you can see if the field is visible or not visible in specific Views
8. Field Notes - Expanded
Add internal notes to any field. These are only visible in the Schemas app. Once you add a new note, it will be displayed on the Details tab of the field
Create Filters to View Your Schema in Different Ways
You can create custom filters to showcase specific tables, specific field types, or relationship types.
Save your filter
Once you have filter options selected, you can create a custom filter
Click Save Filter
Enter the name of your filter
You can Manage your filters and switch between different ones.
Click Manage Filters
Note: After 50 tables, you won’t be able to see the relationships on the diagram. You’ll need to expand each table and click on the field to see related fields and tables
Snapshot History of your Schema
Each time your Schema changes, you can create a Snapshot to track changes.
You’ll be prompted to “Save Schema Changes” and create a snapshot when it changes
Click the button to generate a new snapshot
You can then see a list of your Snapshots. When you click them, you can see what was changed.
In this example, you can see we changed the table name of Events to a new name of Company Events
See Changes in Base, Tables, Views, and Fields
You can display the changes in the base name, tables, views, and fields in each tab
Click the tab you want to see and then choose the specific table, view, or field
The Snapshot column will show you which snapshot the change occurred. When you click the Snapshot name, you can see what change was made in that Snapshot
In the Tables tab, you can see a list of Tables and the associated Snapshot
You can also enable or disable Deleted Tables
In the Views tab, you can see a list of Views and the View Type.
You can then switch between Tables to see the Views for various tables
You can also enable or disable Deleted Views
In the Fields tab, you can see a list of Fields and the Field Type
You can then switch between Tables to see the Fields in various tables
You can also enable or disable Deleted Fields
Share Your Schema
You can share the base schema with others
Go to the Share tab and Enable sharing with the toggle
You can then choose to View Public version of the Schema or Copy the Schema link to your clipboard
Print Your Schema
You can print your schema for easier viewing
Click View Print Layout above the diagram
Export Your Schema
You can export and download your Schema in the Export tab
Choose between JSON or CSV format and click Download
There is a code for security purposes.
Code is used for security purpose of transmitting your schema data.
Refresh to generate a new code and invalidate previous code.
Delete Your Schema
Delete your Schema by clicking Delete Schema in the Settings tab
💬 Need to Chat?
Contact us via chat and if we are online we’ll get back to you as soon as possible
📽 Leave Video Feedback
Need to show us an issue or have a question?
Record your screen and show us what you need.
💻 Want a Demo?
We would love to walk you through a demo of our apps and help you get set up!