on2air schema

On2Air Schemas

Visualize relationships and schema in your Airtable base

On2Air: Schemas generates a diagram to visualize your Airtable base structure and keep a history log of changes to meta information for all tables, views, fields, and relationships. Get an understanding of your base design and relationships with Schema.

Products

Schema - app landing main image
on2air schema

On2Air Schemas

View your Airtable base layout, design, and relationships

Schema - app landing main image

Products

On2Air: Schemas generates a layout design of your Airtable base structure and keeps a history log of changes to meta information for all tables, views, fields, and relationships. Get an understanding of your base design and relationships with Schema.

App Highlights

Schema General view

View the Layout Design of Your Airtable Base

Automatically generate the layout design of your base to view all tables, fields, and relationships.

R

See the entire base design and relationships

R

Create filters to view specific field types

Highlight Relationships Between All Fields

View which fields are linked to each other as linked records. Display linked records and relationships between fields that are used in formulas, lookups, and rollups.

R

Understand the relationship between linked records

R

View referenced relationships for fields, such as lookups, rollups, and formulas

view field references and relationships per indiv field _ schemas
view actual changes in a field in a snapshot_schema

Track Changes of Meta Information

Know when changes are made to table, view, or fields names. View a history log of any new or deleted tables, views, or fields.

R

View any changes made to tables, views, or fields

View Formulas in Formula and Rollup Fields

View the actual formula in formula and rollup fields while also seeing any fields used in the formulas.

R

View Formulas and Referenced fields

Schema_viewformula_actual_opt
view list of tables

View a Detailed List and Field Type of Your Base Layout

Display every field in your base with a link to the details and history of the field. 

R

Detailed list of tables, views, and fields

Keep a History Log and Create Snapshots

Anytime a field, view, or table changes, generate a snapshot of the change.

R

View name changes, additions, or deletions

create a new snapshot_Schema
create a new snapshot_Schema

Share or Print Your Base Design Layout

Easily share a link or print your base schema

R

Share your design with other team members with a link

R

Print a custom view of all or specific sections of your layout

Pricing

on2air schemaOn2Air Schemas

Essentials

$29.99

/month

OR

 $299.99/year 

Billed Annually
(Save 16% and Get 2 Months Free)

  • 10 Airtable Base Schemas
  • 2 Years of History Snapshots
  • Visual Design and List of Meta-Data in Airtable Base Layout
  • View Linked Record Relationships
  • View Referenced Relationships from Lookups, Rollups, and Formulas
  • Generate Shared Link for Others to View
  • Print Entire Layout Design or Specific Sections

Professional

$49.99

/month

OR

 $499.99/year 

Billed Annually
(Save 16% and Get 2 Months Free)

  • 25 Airtable Base Schemas
  • 5 Years of History Snapshots
  • Visual Design and List of Meta-Data in Airtable Base Layout
  • View Linked Record Relationships
  • View Referenced Relationships from Lookups, Rollups, and Formulas
  • Generate Shared Link for Others to View
  • Print Entire Layout Design or Specific Sections

Premium

$79.99

/month

OR

 $799.99/year 

Billed Annually
(Save 16% and Get 2 Months Free)

  • 50 Airtable Base Schemas
  • 10 Years of History Snapshots
  • Visual Design and List of Meta-Data in Airtable Base Layout
  • View Linked Record Relationships
  • View Referenced Relationships from Lookups, Rollups, and Formulas
  • Generate Shared Link for Others to View
  • Print Entire Layout Design or Specific Sections

We also have a Free Plan – You can view the schema for 1 Airtable base – history snapshots not included – Get started

Full Feature Comparison

Essentials

$29.99/month

Professional

$49.99/month

Premium

$79.99/month

Airtable Bases 10 25 50
History Snapshots 2 Years 5 Years 10 Years
Visual Design Layout of Airtable Bases
List View of Tables, Views, and Fields
View Linked Record Relationships
View Referenced Relationships
Generate Shared Link of Layout
Print Layout
Two-factor Authentication
Chat Support
Community of Other Airtable Users
Phone Support

 

 

 

$29.99/month
Essentials
On2Air Schema
Airtable Bases 10
History Snapshots 2 Years
Visual Design Layout of Airtable Bases
List View of Tables, Views, and Fields
View Linked Record Relationships
View Referenced Relationships
Generate Shared Link of Layout
Print Layout
Two-factor Authentication
Community with Other Airtable Users
Chat Support
$49.99/month
Professional
On2Air Schema
Airtable Bases 25
History Snapshots 5 Years
Visual Design Layout of Airtable Bases
List View of Tables, Views, and Fields
View Linked Record Relationships
View Referenced Relationships
Generate Shared Link of Layout
Print Layout
Two-factor Authentication
Community with Other Airtable Users
Chat Support
$79.99/month
Premium
On2Air Schema
Airtable Bases 50
History Snapshots 10 Years
Visual Design Layout of Airtable Bases
List View of Tables, Views, and Fields
View Linked Record Relationships
View Referenced Relationships
Generate Shared Link of Layout
Print Layout
Two-factor Authentication
Community with Other Airtable Users
Chat Support

We also have a Starter plan for $99/year 

Use Cases

commercialrealestate
marketing
consulting
businessdata
marketing
commercialrealestate
ecommerce
consulting

Premium Customer Service and Support

We’re Airtable experts and we’re here to help. We’ve been building Airtable apps and Airtable business systems for years.

customer support

Visualize Your Airtable Base Design and Layout

Start a 14-day free trial. No credit card needed, just add the app to your Airtable base, and create your 1st schema

Airtable Schemas Resources

15 Airtable Design Best Practices Checklist What You Need to Know

Airtable is a powerful tool to use as a central source of information for your business and your team, but it can be overwhelming to get started. We’ve created this 15-point checklist of Airtable best practices for companies using Airtable. 

Visualize and Monitor Your Airtable Base Structure with Schemas

If your company uses Airtable as a central source for all your business operations, you probably have multiple bases and a variety of base structures. With the On2Air Schema app, you can view the design of your Airtable base and relationships between tables, views, and fields.

sailcoredemobase_templatemainpage-1

Use this Customer Management and Sales Airtable Base Template to easily store all your essential company information. This base contains tables to track your Company clients, Contacts, Deals, Sales Reps, Deliverables, Services, Interactions, and Documents.

Features

View your data hierarchy and table relationships at a glance.

Understand the relationships and links in your data in tables and fields.

Control your data structure and establish proper database administration.

Identify each field type and ensure you have proper field type configurations for all your data.

Easy to use, just click-and-create. An intuitive layout, a mobile-friendly interface, and helpful documentation so you can get setup and back to business.

Dedicated data and technical specialists who are ready to help your business succeed.

FAQ

What is 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.

What is a Schema?

A Schema is a visual representation diagram of your Airtable base used to view base structure and relationships and to track meta changes to tables, views, and fields.

How do I create Schemas?

Head over to the Help Desk to get started.

How many Schemas can I have?

Choose the plan that works for you. From a single schema to multiple schemas, we have pricing plans to fit your needs.

Why do I have to enter my Airtable API key?

In order to use this product, we need to connect to your Airtable data which requires entering your API key into our connector.

Check out more On2Air Apps for Airtable

amplify logo

On2Air: Amplify

A brand new way to view your Airtable data. With custom views, a full-screen viewer, record customizer, editor, and dashboard, On2Air: Amplify will change the way you use Airtable!

On2Air: Forms

Create and configure advanced forms using your Airtable data completely integrated with a third-party form’s powerful features, including prefilled data, search, and more. 

On2Air: Actions

An advanced connector to integrate your Airtable data with any other software,  including over 2,500 apps with 15+ additional action options beyond the standard Airtable actions.

On2Air: Backups

An automated backup solution for your Airtable bases. Create scheduled backups of data stored in Airtable and export your information to Dropbox, Box, or G Drive.

On2Air: Schema

A generated diagram to visualize your Airtable base structure and track changes to meta information for all tables, views, fields, and relationships. 

On2Air: Scripts

Create, edit, maintain, and integrate multiple scripts from a single codebase and sync across multiple Airtable bases, integrated with Airtable’s Scripting block. 

View Your Airtable Base Relationships and Design

Start a 14-day free trial. No credit card needed, just add the app to your Airtable base, and create your 1st schema.