Airtable gives you the structure of a database with the familiarity of a spreadsheet — and for course creators juggling many lessons, multiple content types, and a production timeline, that combination is hard to beat. Here's how to set up an Airtable base that turns your course plan into a working system.
Why Airtable for Course Outlining
A simple bulleted list works fine when your course has eight lessons. But once you're managing 20, 30, or 50 lessons across multiple modules — each with its own content type, production status, and estimated duration — a flat document starts to fight you. You're scrolling constantly, losing track of what's recorded and what's still in draft, and struggling to see the big picture.
Airtable handles this because it stores your data once and lets you view it in multiple ways. The same table of lessons can appear as a grid for editing details, a kanban board for tracking production status, a calendar for scheduling your recording sessions, and a gallery for a visual overview. You don't duplicate anything — you just switch views.
It also lets you link tables together. Your Lessons table can point to your Modules table, so every lesson knows which module it belongs to. Change a module name in one place and it updates everywhere. If you've ever tried to maintain a spreadsheet where Module 3 is referenced in fifteen different cells, you know why this matters.
Step-by-Step: Building Your Course Outline in Airtable
Step 1: Create a New Base
Open Airtable and create a new base from scratch (not from a template — you'll understand the structure better if you build it yourself). Name it after your course: "Yoga Teacher Training Outline" or "Leadership Coaching Program." Specificity helps when you have multiple bases later.
You'll see a default table called "Table 1." Rename it to "Modules." This will hold your course's top-level structure.
Step 2: Build the Modules Table
In your Modules table, set up these fields:
- Module Name (the primary field — already there by default). Write clear, numbered names: "1 — Foundations," "2 — Core Framework," etc.
- Description (Long text). A one-sentence summary of what the module covers and what students will achieve by the end.
- Order (Number). The sequence number. This makes sorting reliable even if you rename modules.
- Lessons (Linked record — you'll create this link in Step 4). Leave this for now.
Add a row for each module. Most courses land between four and seven modules. Don't overthink this — you can split or merge modules later.
Step 3: Build the Lessons Table
Create a second table and name it "Lessons." This is where the bulk of your planning happens. Add these fields:
- Lesson Title (primary field). Keep titles action-oriented: "Record client intake walkthrough," "Explain the 3-pillar framework." The title should tell you what the student will do or learn.
- Status (Single select). Create these options: Draft, In Progress, Recorded, Edited, Published. Color-code them — gray for Draft, yellow for In Progress, blue for Recorded, purple for Edited, green for Published. The colors make your grid instantly scannable.
- Content Type (Single select). Options: Video, Text, Worksheet, Quiz, Discussion, Live Session. Again, assign colors. This field lets you see at a glance whether your course has a healthy variety of learning activities.
- Estimated Duration (Number, in minutes). How long you think the lesson will take students. This forces you to think about pacing before you create anything.
- Actual Duration (Number, in minutes). Fill this in after you've created the content. Comparing estimated vs. actual helps you plan more accurately for your next course.
- Notes (Long text). Key talking points, resources to reference, questions to address. Think of this as your lesson brief.
- Order (Number). The lesson's position within its module.
Step 4: Link Lessons to Modules
In your Lessons table, add a new field of type "Link to another record" and point it at the Modules table. Name the field "Module." Now every lesson row has a dropdown where you select which module it belongs to.
Go back to your Modules table — you'll see that Airtable automatically created a "Lessons" field there, showing which lessons are linked to each module. This two-way link is the core advantage over a spreadsheet. You can click into any module and see all its lessons, or click into any lesson and see its parent module.
If you want to see total lesson count or total estimated duration per module, add a Rollup field in the Modules table that counts or sums the linked Lessons records. This tells you at a glance if one module is overloaded.
Step 5: Set Up a Kanban View for Status Tracking
In your Lessons table, click "Views" and add a new Kanban view. Group the cards by the Status field. You'll now see columns for Draft, In Progress, Recorded, Edited, and Published — with each lesson as a card you can drag between columns.
This view becomes your production dashboard. At any point, you can open this view and see exactly how much of your course is done, what's in progress, and what hasn't been started. Drag a lesson from "Draft" to "In Progress" when you start working on it.
Step 6: Add a Calendar View for Production Scheduling
Add a Date field to your Lessons table called "Production Date" — the day you plan to create that lesson's content. Then create a new Calendar view using that date field.
Now you can see your production schedule visually. Drag lessons to different days to balance your workload. If you see five video lessons stacked on a Tuesday, spread them out. This view is especially useful if you're coordinating with a videographer, editor, or co-instructor.
Step 7: Create a Gallery View for Visual Overview
Add a Gallery view to your Lessons table (available on paid plans). Choose the Content Type or Status field as the cover, and configure the card to show the lesson title, module name, and estimated duration. Gallery view gives you a visual "storyboard" of your course — each card is a lesson, laid out in a grid.
If you're on the free plan, you can get a similar overview by grouping your grid view by Module and then sorting by Order within each group. It's not as visual, but it gives you the same structural overview.
Step 8: Review and Refine
Switch between your views and look at your course from different angles. In grid view, check that your estimated durations add up to a reasonable total. In kanban view, confirm that your status labels are set correctly. In calendar view, make sure your production schedule is realistic.
Read through the lesson titles in order, module by module. Ask yourself whether a student would feel a clear progression. If two consecutive lessons cover similar ground, consider merging them. If there's a big conceptual jump between lessons, you might need a bridging lesson.
Course Creator Tips
Add a "Parking Lot" Module
Create a module called "Parking Lot" (or "Maybe Later") in your Modules table. Link any lesson ideas that don't have a clear home yet. This keeps stray ideas from cluttering your working outline while making sure they don't get lost. Review the Parking Lot after you've finished your first draft — some ideas will find homes, and others will become bonus content or material for a future course.
Use Formulas to Track Progress
Add a Rollup field in your Modules table that counts how many linked lessons have Status = "Published." Pair it with a count of total lessons, and you have a built-in progress tracker: "Module 2: 4 of 6 lessons published." You don't need a separate project management tool for this level of tracking — Airtable handles it natively.
Start with the Grid, Graduate to Views
Don't try to set up every view on day one. Start in grid view, get all your lessons entered, and link them to modules. Once you have real data in the base, the kanban and calendar views will be immediately useful. If you build the views first with empty tables, they feel pointless and you'll lose momentum.
Limitations (And When to Use Something Simpler)
Airtable has a steeper learning curve than a document or a basic kanban board. Concepts like linked records, rollups, and filtered views are powerful once you understand them, but they take time to learn. If your course has six lessons in two modules, Airtable is probably overkill — a Google Doc or Trello board will get you there faster.
The free tier limits you to 1,000 records per base and 1 GB of attachment storage. For outlining purposes, you'll rarely hit the record limit (even a 50-lesson course with modules and supplementary records stays well under 1,000). But if you're also storing video files, scripts, and design assets in the same base, you could run into the storage cap.
Airtable is also a planning tool, not a course delivery platform. It can't enroll students, track their progress, process payments, or host your content. Once your outline is solid and your content is created, you'll need to move everything to a platform built for teaching.
Related Guides
- How to Outline Your Course Using Notion — a flexible alternative with database views and templates
- How to Outline Your Course Using Trello — a simpler kanban-based approach to course planning
- How to Structure an Online Course — frameworks for organizing modules and lessons
- How to Build a Course Production Schedule in Google Sheets — track your production timeline in a spreadsheet
From Airtable to Live Course
A well-organized Airtable base gives you something most course creators lack: a clear, complete picture of your course before you've recorded anything. You know how many lessons you have, how long the course will take, what content types you're using, and what still needs to be created. That clarity saves weeks of rework.
When your outline is ready and your content is created, Ruzuku lets you build your modules and lessons in the same sequence you planned. Upload your videos, add activities, and open enrollment — all in one place, with zero transaction fees.