Airtable Course

Lesson 1 • Understanding Bases, Tables, and Records

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

Lesson 2 • Airtable's Interface and Navigation

Introduces the workspace, sidebar, and toolbar so learners 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. Learners 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. Learners 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. Learners 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. Learners enforce data consistency through field design.

Lesson 4 • Computed and Auto-Generated Fields

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

Lesson 1 • Alternative View Types

Introduces gallery, calendar, kanban, timeline, and Gantt views. Learners 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. Learners 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. Learners customise the default view for clarity and efficiency.

Lesson 4 • Saving and Sharing Views

Covers personal vs. collaborative views, view locking, and shared view links. Learners 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. Learners compute summary metrics directly within the table.

Lesson 2 • Relational Data Concepts

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

Lesson 3 • Creating Linked Record Fields

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

Lesson 1 • Formula Field Basics

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

Lesson 2 • Numeric and Aggregate Functions

Explains SUM, AVERAGE, MIN, MAX, ROUND, MOD, and ABS functions. Learners 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. Learners encode business rules directly into field values.

Lesson 4 • Text and Date Functions

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

Lesson 1 • Record-Based Triggers

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

Lesson 2 • Testing and Debugging Automations

Covers test runs, run history inspection, and common failure patterns. Learners 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. Learners 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. Learners 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. Learners 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. Learners 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. Learners protect sensitive columns without restructuring the base.

Lesson 1 • Forms and Data Entry Interfaces

Teaches form elements and record creation flows embedded in interfaces. Learners 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. Learners build browsable record interfaces for end users.

Lesson 3 • Publishing and Managing Interfaces

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

Lesson 4 • Introduction to Airtable Interfaces

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