Airtable Fundamentals: Go From Beginner to Expert

Visualize your database structure before building it, identify tables like contacts, schedule of events, and speakers, and decide when to merge or separate tables to plan an event database.

Create an Airtable base from scratch, name it, choose a color and icon, and build three tables: contacts, schedule of events, and speakers, then import CSV data.

Discover how Airtable uses fields with 28 field types, focus on 15 highlighted types, identify types by icons, and learn to rename, customize, insert, move, delete, and restore fields.

Identify and customize the primary field in Airtable, selecting session title for uniqueness, then compare text field types, including single line, long, rich text, and email or URL types.

Airtable fundamentals show how single select and multiple select fields save time with pre-defined category options like education, entertainment, technology, and marketing. Convert between types and customize options with colors.

Learn to manage dates and times in Airtable by creating a single date field with start and end times and enabling a consistent time zone for static schedules.

Use the attachment field to upload multiple files—photos, PDFs, and more—by drag-and-drop or from online sources, with previews, full-screen view, and a 20 GB per base limit.

Explore checkbox and rating fields to track status and ratings, manage numbers and currency with integer, decimal, and currency formats, and summarize data using Airtable's summary bar.

Learn Airtable’s formula fields to perform calculations across rows, using package cost and amount paid to compute balance due with currency formatting and the If function for conditional status.

Learn how to create, edit, delete, and expand Airtable records, navigate fields with tab and shift+tab, and use keyboard shortcuts for undo and quick data entry.

Learn to import a CSV into a pre-existing Airtable table using the CSB import app, with field mappings and limitations like no new fields and no long text.

Organize your records by sorting by session title, by category, and by start time, stack multiple sorts, then group by category and color records to visualize categories.

Learn how to quickly locate records in Airtable using simple find and advanced filtering, with multiple filters and visual cues like green highlights.

Learn how Airtable creates and customizes multiple views of the same records, with grouping, sorting, filtering, coloring, and renaming or adding new views with changes reflected across all views.

Add a calendar view from the views panel, set the start time (and end time on the pro plan), then color by room and filter by education or technology.

Explore kanban and gallery views in airtable, organize records as cards, customize fields, color by category, and create forms to add new records.

Create linked record fields to connect speakers with their events in a one-to-many relationship. Enable linking to multiple records, viewing linked details, and automatic reverse links between tables.

Explore how lookup fields pull information from linked records to display speakers' titles, bios, and photos in the schedule. Remember you cannot edit lookup fields directly.

Explore templates and the Universe library to browse sample bases and real-world solutions, and join the Air Table Community Forum to discuss everything about Air Table and continue learning.