Airtable is a flexible, cloud‑based tool that blends spreadsheets with relational databases. Designers use it to manage assets, track project status, and create live style guides. This guide shows you how to set up Airtable, run core workflows, apply advanced patterns, and avoid the most common mistakes.
Airtable stores data in tables that behave like spreadsheets. Each table can have fields (columns) of specific types: single line text, attachment, checkbox, collaborator, etc. The real power comes from linked records, which let you relate rows across tables, creating a network of data.
For designers, this means you can keep a master Asset Library table linked to a Project Tracker table. When a new project starts, you pull in only the assets you need, and any change to an asset updates all linked projects automatically.
| Table | Key Fields | Purpose |
|---|---|---|
| Assets | Name, Type (image, icon, illustration), File (Attachment), Tags (Multi‑select), Version (Number) | Store every design file in one place. |
| Projects | Title, Status (single select), Owner (Collaborator), Due Date, Assets (Linked to Assets) | Track progress and link assets. |
| Components | Component Name, Library (single select), Figma URL, Props (Long text), Assets (Linked) | Maintain a living component inventory. |
Each table can have multiple views: Grid, Kanban, Gallery, and Calendar. For designers:
1. Upload a new file to the Assets table.
2. Add tags like “brand”, “icon”, “illustration”.
3. Set the version number. Airtable automatically creates a revision history.
1. Duplicate a “Project Template” record.
2. Link required assets via the “Assets” field.
3. Assign a designer as the collaborator.
4. Use the Calendar view to see due dates at a glance.
Use the native Figma sync to pull component metadata into the Components table. Every time a component updates in Figma, the linked record refreshes, keeping documentation current.
This keeps stakeholders aware of version changes without manual emails.
Add a roll‑up in the Assets table that counts linked Projects. Field settings: “Count” → “Projects”. You instantly see how many projects rely on each asset.
Large design orgs often separate “Brand Assets” and “Product Assets” into two bases. Use Airtable’s “Sync” feature to pull the “Brand Assets” view into the product base, keeping a single source of truth.
Show overdue tasks in red:
IF({Due Date} < TODAY(), "⚠️ Overdue", "")
Place this formula field in the Projects table and filter on non‑empty values to create a quick “Overdue” view.
Designers sometimes create a table for every tiny concept (e.g., “Colors”, “Gradients”, “Shadows”). Consolidate related items into a single “Design Tokens” table with a “Category” single‑select field. This reduces view clutter and improves performance.
When you link assets to projects, always add a “Linked record view” field in the Projects table. It shows a live preview of each asset, preventing the need to open the Assets table repeatedly.
Each attachment adds storage overhead. Store high‑resolution files in a dedicated cloud folder (e.g., Google Drive) and keep only a preview thumbnail in Airtable. Use a URL field for the full‑size link.
Give “Read‑only” access to stakeholders who only need to view the style guide. Use Airtable’s “Workspace permissions” to avoid accidental edits.
Old project records still count toward record limits. Archive them by moving to a “Archive” table or base. This frees up space for active work.
| Feature | Free | Plus ($10/user/mo) | Pro ($20/user/mo) |
|---|---|---|---|
| Records per base | 1,200 | 5,000 | Unlimited |
| Attachment storage per base | 2 GB | 5 GB | 1 TB |
| Automation runs per month | 100 | 5,000 | Unlimited |
| Revision history | 2 weeks | 6 months | 1 year |
| Sync & API access | Limited | Full | Full + priority support |
Most solo designers stay on the Free plan. Small teams benefit from Plus because it lifts the 5,000‑record ceiling and adds more automation runs, which is enough for weekly asset syncs. Large product teams usually need Pro for unlimited records and advanced sync.
Airtable is a cloud‑based spreadsheet‑database hybrid that lets you organize, link, and visualize data without writing code.
The free plan covers most design tasks, but the Plus plan ($10/user/month) adds more records, attachment space, and automation runs, which many teams find useful.
Use Airtable’s native Figma sync or Zapier integration to push component data into a base, then embed the view back into Figma using the iframe widget.
Over‑nesting tables, ignoring linked record views, and using too many attachment fields can slow down the base and make collaboration harder.
Airtable can complement a design system by tracking assets, version history, and usage metrics, but it does not replace component libraries or code‑level token management.
With this guide, designers can set up Airtable quickly, run repeatable workflows, and avoid pitfalls that waste time. Start building your design base today and watch your organization improve.