Airtable Builder Certification study plan

Build a base from scratch with at least four tables, defining field types appropriate to each data element

Configure primary fields, linked records, and lookup fields to connect the tables

Write a one-page glossary of core platform concepts (base, table, field, record, view) in your own words

Set up two grid views with filters and sorts to validate the data model

Implement rollup fields that aggregate values across linked records and verify the results by hand

Create formula fields covering text, math, date, and logical functions

Configure field-level validation and conditional logic where supported

Document each field's purpose and type in a schema table inside the base

Design a many-to-many relationship using a junction table and confirm it with test records

Build views (grid, calendar, kanban, gallery) each serving a distinct use case

Apply filters, sorts, groupings, and field visibility to tailor each view

Explain when to use linked records versus lookups versus rollups in writing

Configure base-level settings, collaborators, and sharing options appropriate to a scenario

Create an interface with a record detail page and an interactive list page

Add interface elements (buttons, filters, charts) that match a stated user task

Restrict interface visibility and permissions to a defined user role

Build a dashboard interface with summary charts and metrics from the base

Design a form interface for data entry and test it end to end

Customize interface layout, branding, and navigation for a target audience

Audit the interface against three usability criteria and log fixes

Create a trigger-based automation that fires on record creation or field change

Add conditional logic and at least one action beyond a simple update (email, record creation, or script-free action)

Test the automation with sample records and confirm expected outcomes

Document the trigger, conditions, and actions for each automation built

Build a scheduled automation that runs on a recurring basis and processes records

Chain multiple actions with branching conditions and handle a failure case

Connect an automation to data in a linked table and verify the update propagates correctly

Review automation run history and interpret statuses

Assemble a capstone app combining a multi-table base, an interface, and at least two automations

Review each domain's objectives and list any weak areas with remediation notes

Walk through the capstone end to end simulating a user workflow

Write a final self-assessment mapping your work to all four domains