AirOps Consulting

Airtable Mastery

The world's most comprehensive course on Airtable

Build on your existing Airtable skills and learn to design, create, and manage Airtable Bases that adhere to the highest industry standards.

Artboard 1
Play Video
Artboard 1 copy 2
Ethical Swag (1)
Prosper-Portland-logo-tagline-300x300
OutbackPresents-square
PH_fulllogo_pink
Artboard 1 copy 4
BECOME AN AIRTABLE CHAMPION

A Course Designed for those who want to learn Airtable the right way.

Excellence in Airtable is a course designed for those looking to work and use Airtable professionally in their their career.

Throughout the course, students will learn everything they need to manage and grow the Airtable bases they work with each day. The course will start with fundamentals, but quickly dive into advanced topics like database schema design, data management, custom fields and formulas, advanced interfaces/views, and automations.

The course is instructed by award winning, Airtable certified instructor Cherry Yang - who will be there each step of the way as you grow your skills as an Airtable developer.

Airtable Mastery Course Overview

About the Instructor

Cherry Yang, is the founder of AirOps Consulting. She is a Airtable Consultant Partner and certified Zapier expert with the experience of building and implementing databases and workflows for over 100 clients. Passionate about helping corporations untangle complex processes and streamline operations.

Course Overview

Our guiding principle behind designing Airtable Mastery is to teach Airtable in the way we as consultants who have delivered Airtable solutions for over a hundred clients for all different industries and clients around the world, would have wanted to learn if we had to learn it all over, from the very beginning.

Completing this course will help you:

Who is the course for?

This course is designed for people who really see themselves as someone who want to use Airtable professionally and help their team innovate and collaborate better. It is aimed at individuals who want to leverage Airtable in a professional setting, who are looking to become an Airtable champion for the organization and to become an innovator . Those who will benefit the most, are the people who have a vested interest in the software who are invested in learning it the right way.

This course is here for innovative organizations that want to leverage Airtable to help their teams communicate, collaborate, and automate. By having a single source of truth and giving people access to relevant data, The entire organization is able to be more effective. It’s also such an amazing learning experience to build these kinds of airtable projects because it forces people to think logically and strategically about your organizational workflows and processes.

Play Video

Learning Path

Module 1: Database Design

Module 1 explores the concept of scalable database design and the fundamental principles of implementing modular, maintanable, and scalable Airtable bases. In Module 1 we'll cover: ➣ Defining database scope ➣ Relational database principles ➣ How to define business needs ➣ How to define Airtable base requirements ➣ Designing Airtable base architecture ➣ Creating an Airtable base

Lesson Structure

Lesson 1 - Types of Relationships in Airtable
Lesson 2 - Airtable Taxonomy
Lesson 3 - Airtable Relationships Demonstration
Example 1 - Airtable Base -
Example 2 - Airtable Base -
Example 3 - Airtable Base -
Lesson 4 - Setting up an Airtable Base
Lesson 5 - Using the Base Schema Extension
Extra Credit - Airtable Pricing
Extra Credit - Airtable Sharing
Extra Credit - Airtable Permissions
Extra Credit - How to get help on Airtable
Extra Credit - Start with a template
Lesson 6 - What is design?
Module 2: Implementation

In Module 2 we take a deep dive into Airtable and create an Airtable base from scratch - exploring all the features available to you when building a base. In Module 2 we'll cover: ➣ Fields and tables (All 28 types) ➣ Formulas (Text, Numeric, Date/Time, Arrays, Record Functions) ➣ Views (Grid, Form, Calendar, Kanban, Timeline, Gantt, Gallery) ➣ Automations (Triggers & Actions, Tools, Email, Time Based, Zapier, Conditionals, 3rd Party Integrations) ➣ Reporting (Rollup Fields, Pivot Tables, Quarterly/Annual Reporting, Charts/Graphs) ➣ Interfaces & Portals

Lesson Structure

Section 1 - Airtable Bases
Lesson 1 - Introduction to Bases
Lesson 2 - Field Types
Section 2 - Formulas
Lesson 1 - Introduction to Formulas
Lesson 2 - Text Formulas
Lesson 3 - Numeric Formulas
Lesson 4 - Date and Time Formulas
Lesson 5 - Arrays
Lesson 6 - Record Functions
Section 3 - Views
Lesson 1 - Introduction to Views
Lesson 2 - Grid View
Lesson 3 - Form View
Lesson 4 - Calendar View
Lesson 5 - Kanban View
Lesson 6 - Timeline View
Lesson 7 - Gantt View
Lesson 8 - Gallery View
Lesson 9 - Organizing Views
Lesson 9 - Conclusion
Section 4 - Automation & Integration
Lesson 1 - Automation Introduction
Lesson 2 - Triggers and Actions
Lesson 3 - Tools for Automations
Example 1 - Email Example
Example 2 - Gmail Example
Lesson 4 - Time Based Trigger
Lesson 5 - Zapier Automations
Lesson 6 - Conditionals
Example 1 - Zapier: Calendy Demo
Example 2 - Zapier: Create or Update Contact
Example 3 - Zapier: Wrap Up
Section 5 - Reporting
Lesson 1 - Reporting Introduction
Lesson 2 - Understanding your reporting needs
Lesson 3 - Reporting with rollup fields
Lesson 4 - Pivot Tables
Lesson 5 - Quarterly or Annual Reporting
Lesson 6 - Charts & graphs
Section 6 - Permissions and Sync Tables
Lesson 1 - Permissions
Module 3: Support

Module 3 wraps up the course by exploring the various third-party tools available to supercharge an Airtable database. In Module 3 we'll cover: ➣ Useful 3rd Party Tools (On2Air, MiniExtensions, Pory, Stacker, and more!) ➣ Permission Management ➣ Data Integrations ➣ Data Synchronization ➣ Ongoing training & team onboarding ➣ Best practices for maintaining your database

Lesson Structure

Lesson 1 - Introduction to Interfaces and Third Party Tools
Section 1 - Stacker
Lesson 1 - Stacker
Lesson 2 - Stacker Permissions
Lesson 3 - Stacker Fees
Lesson 4 - Stacker Use Cases
Lesson 4 - Stacker Live Demo
Lesson 5 - Stacker considerations and conclusion
Section 2 - Pory
Lesson 1 - Introduction to Pory
Lesson 2 - Pory Pricing
Lesson 3 - Pory Use Cases
Section 3 - MiniExtensions
Lesson 1 - Introduction to MiniExtensions
Section 4 - On2Air
Lesson 1 - Introduction to On2Air
Section 5 - Addons
Lesson 1 - Automation Addon: Daily Digest
Section 6 - Interfaces
Lesson 1 - Introduction to Interfaces
Lesson 2 - Common use cases for Interfaces
Example 1 - Interface Use Case
Lesson 3 - Before the build
Lesson 4 - Interface Layouts
Lesson 5 - Record Review
Lesson 6 - Dashboard Template
Lesson 7 - Record Summary Template
Lesson 8 - Form Template
Lesson 9 - Interface Elements Overview
Lesson 10 - Interface Permissions
Lesson 11 - Conclusion
Section 4 - Automation & Integration
Lesson 1 - Automation Introduction
Lesson 2 - Triggers and Actions
Lesson 3 - Tools for Automations
Example 1 - Email Example
Example 2 - Gmail Example
Lesson 4 - Time Based Trigger
Lesson 5 - Zapier Automations
Lesson 6 - Conditionals
Example 1 - Zapier: Calendy Demo
Example 2 - Zapier: Create or Update Contact
Example 3 - Zapier: Wrap Up
Section 7 - Supplemental Resources
Lesson 1 - Hotkeys
Lesson 2 - Retrieving Deleted Data

Course Outcomes

We've designed our course with two primary learning objectives in mind:

1) We want to our students to internalize good principles of database design
We want to help our students understand the fundamental principles that make up good database design. Databases that are organized, structured, and planned right the first time lead to cleaner, easier to manage, and modular Airtable applications.

and;

2) We want our students to leave with extrordinarily usable skills
We want our students to develop the intermediate/advanced skills they'll need to manage, extend, and improve the bases they build and work with on the daily. We want our students to leave the course comfortable bringing the skills they've learned back to their organizations; implementing their own new ideas with confidence and creativity.

What students are saying

Are You Ready To Start?

Preview a Sample Lesson

Module 1 - Lesson 5 - What is Design

Custom Airtable Database Implementation

Harness the power of your data to transform your organization.

Databases to Write Home About

AirOps Consulting creates bespoke, streamlined Airtable solutions that let you connect information, collaborate, and build powerful databases to help your business reach its potential.

Design

How to scope your project Understanding and analyzing the business needs Architecting your base

Implementation

- configuring fields and tables - Automations - Implementations

Support

Ongoing training Onboarding your team Best practices for maintaining your database

6

Course Modules

100+

Video Lessons

40+

Airtable Templates

10+

Hours of Content

Customizable

All of our databases are built from the ground up to fit the needs of your organization and team.

Scalable

Our Airtable solutions are designed to grow alongside the success of your business.

Simple

All of our databases are streamlined, intuitive, and easy to use.

Course Curriculum

Our approach is named The AirOps Advantage.

The AirOps Advantage contains 3 steps:

  1. Database Strategy and Design – The first step allows our client’s internal team and AirOps Consulting to be entirely aligned on the process and what the outcome of the project will look like. The deliverable for this phase is the mockup of your database so the client can know how it will be set up.
  2. Database Implementation – The second step is for the AirOps Consulting consulting team to build the database by configuring fields, setting up automation, and implementing views and interfaces for various team members. The client team and AirOps team will have periodic meetings to communicate on the progress and clarifying questions
  3. Team Training and Support – The third step of our projects is to train the client team on how to use their database. AirOps Consulting can also provide ongoing support to the client through a monthly retainer.

Our approach is named The AirOps Advantage.

The AirOps Advantage contains 3 steps:

  1. Database Strategy and Design – The first step allows our client’s internal team and AirOps Consulting to be entirely aligned on the process and what the outcome of the project will look like. The deliverable for this phase is the mockup of your database so the client can know how it will be set up.
  2. Database Implementation – The second step is for the AirOps Consulting consulting team to build the database by configuring fields, setting up automation, and implementing views and interfaces for various team members. The client team and AirOps team will have periodic meetings to communicate on the progress and clarifying questions
  3. Team Training and Support – The third step of our projects is to train the client team on how to use their database. AirOps Consulting can also provide ongoing support to the client through a monthly retainer.

Airtable is a customizable database solution. Since 2019, we have worked with over 100 organizations from many industries. The list below contains common industries that our clients are from:

  • Retail
  • Entertainment and Media production
  • Event Management
  • Technology
  • Manufacturing
  • Real Estate
  • Non-profit organizations
  • Government organizations
  • Professional Services and Agencies

Our projects typically take 5 – 12 weeks to complete depending on the size of the project. Larger and more complex projects could take up to 6 months.

AirOps Consulting can provide ongoing support to the client through a monthly hourly retainer. Clients use this retainer for many purposes like ongoing training, technical support, feature updates, and other database inquiries.

We integrate with a wide array of third-party apps through various methods. Airtable is constantly adding new integrations with different tools like Twilio, Outlook, Gmail, and Google Calendar. We also integrate with thousands of other apps using Zapier and Integromat like Quickbooks, SignNow, Shopify, and Mailchimp. If you need special integration requests, we can also create custom scripts to connect your Airtable.

We also have extensive knowledge of the apps listed below:

  • On2Air
  • Pory
  • Stacker
  • AirPower
  • MiniExtensions
  • Zapier

We work with many large teams and have built databases that enable collaboration with many stakeholders. Typically, we will use a combination of forms, portals, and automation to help our clients save on costs and properly configure the view and editing capabilities of various stakeholders.

Consistent, smart, thinks up stuff you never thought about.

Cherry is a consummate professional when it comes to Airtable and business in general. She has been working as a part of my team for several months now to create and launch an amazing new CRM for my business. I am thrilled with her results.

Jason Ford
Owner, Property Problem Solvers
Questions about the course