Airtable Course

Lesson 1 • Understanding Bases, Tables, and Records

Explains the three-tier data hierarchy: base, table, and record. Students can distinguish these units and understand how data is organized.

Lesson 2 • Airtable's Interface and Navigation

Introduces the workspace, sidebar, and toolbar so students can orient themselves confidently. Establishes the mental map needed for all subsequent work.

Lesson 3 • Adding and Editing Records

Covers data entry methods including manual input, CSV import, and copy-paste. Students can populate a table with real data efficiently.

Lesson 1 • Date, Time, and Checkbox Fields

Teaches date, time, and checkbox configuration including format and time-zone settings. Students capture temporal and boolean data accurately.

Lesson 2 • Attachment, URL, and Phone Fields

Covers file attachments, URL, email, and phone fields for rich-media and contact data. Students store diverse data types within a single record.

Lesson 3 • Choice and User Fields

Explains single select, multiple select, and collaborator fields for controlled vocabularies and ownership. Students enforce data consistency through field design.

Lesson 4 • Computed and Auto-Generated Fields

Introduces formula, autonumber, created time, last modified, and created-by fields. Students automate metadata capture without manual entry.

Lesson 1 • Alternative View Types

Introduces gallery, calendar, kanban, timeline, and Gantt views. Students match the right view type to each workflow or reporting need.

Lesson 2 • Filtering Records

Teaches single and compound filter conditions using AND/OR logic. Students isolate exactly the records relevant to a task or audience.

Lesson 3 • Grid View Fundamentals

Covers column resizing, row height, field hiding, and field reordering in grid view. Students customize the default view for clarity and efficiency.

Lesson 4 • Saving and Sharing Views

Covers personal vs. collaborative views, view locking, and shared view links. Students distribute tailored data perspectives without exposing the full base.

Lesson 1 • Rollup Fields and Aggregations

Covers rollup functions such as SUM, COUNT, and CONCATENATE across linked records. Students compute summary metrics directly within the table.

Lesson 2 • Relational Data Concepts

Explains one-to-many and many-to-many relationships in plain terms. Students understand why normalization reduces redundancy before building links.

Lesson 3 • Creating Linked Record Fields

Walks through linking two tables bidirectionally and selecting linked records. Students connect related entities across tables accurately.

Lesson 1 • Formula Field Basics

Introduces formula syntax, referencing fields, and common operators. Students write their first working formulas with confidence.

Lesson 2 • Numeric and Aggregate Functions

Explains SUM, AVERAGE, MIN, MAX, ROUND, MOD, and ABS functions. Students perform financial and statistical calculations within records.

Lesson 3 • Logical and Conditional Functions

Teaches IF, AND, OR, NOT, SWITCH, and BLANK functions for branching logic. Students encode business rules directly into field values.

Lesson 4 • Text and Date Functions

Covers UPPER, LOWER, TRIM, LEFT, RIGHT, MID, TODAY, and DATEADD functions. Students manipulate string and date data programmatically.

Lesson 1 • Record-Based Triggers

Covers triggers fired when a record is created, updated, or matches a condition. Students activate automations based on precise data events.

Lesson 2 • Testing and Debugging Automations

Covers test runs, run history inspection, and common failure patterns. Students validate automations before activating them in production.

Lesson 3 • Automation Concepts and Architecture

Explains triggers, conditions, and actions as the three building blocks of automations. Students map a manual process to an automation blueprint before building.

Lesson 4 • Conditional Logic in Automations

Adds conditional branches and repeat groups to handle multi-path workflows. Students build automations that respond differently based on data values.

Lesson 1 • Workspace and Base Permissions

Explains owner, creator, editor, commenter, and read-only roles at workspace and base levels. Students assign the minimum necessary access to each collaborator.

Lesson 2 • Comments and Record Activity

Shows how to add, reply to, and resolve comments on records and fields. Students use in-context communication to reduce external messaging.

Lesson 3 • Table and Field-Level Restrictions

Covers hiding fields from specific roles and restricting table access on paid plans. Students protect sensitive columns without restructuring the base.

Lesson 1 • Forms and Data Entry Interfaces

Teaches form elements and record creation flows embedded in interfaces. Students enable non-collaborators to submit data without base access.

Lesson 2 • Building Record List Interfaces

Covers list, gallery, and timeline elements connected to table data. Students build browsable record interfaces for end users.

Lesson 3 • Publishing and Managing Interfaces

Explains interface sharing, access control, and version management. Students deploy interfaces to the right audience with appropriate permissions.

Lesson 4 • Introduction to Airtable Interfaces

Explains the Interface Designer canvas, pages, and element types. Students understand how interfaces differ from views and when to use each.