
Explore Airtable as a fast blend of spreadsheet and database for building apps. Learn to create tables and fields, organize data, and build calendars and web forms.
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.
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 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 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.
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.
In this course you will get up to speed on how to use Airtable.
Airtable is a spreadsheet-database hybrid, with the features of a database but applied to a spreadsheet. Airtable is an easy-to-use online platform for creating and sharing relational databases. The user interface is simple, colorful, friendly, and allows anyone to spin up a database in minutes.
While programs like Excel function only as traditional spreadsheets, Airtable works similarly to both spreadsheets and databases. As a spreadsheet, you can structure information in a grid view with the expected format of columns, rows, and cells.
We will begin the course on how to create a table and how fields work, such as text and number fields, date/time fields, value list fields, attachment fields, and formula fields. We'll go over how to work with records, including how to import external records; how to create, edit, and delete records; how to filter records; and how to sort and group records.
Airtable gives you several different ways to view your data, and we'll go through all the view options. You’ll learn how to link tables and how to incorporate lookup fields.
Simply, Airtable takes the best aspects of spreadsheets and databases, and puts them together.
Airtable can store information in a spreadsheet that's visually appealing and easy-to-use, but it's also powerful enough to act as a database that businesses can use for customer-relationship management (CRM), task management, project planning, and tracking inventory.