How to Use Airtable for Designers

Designers need a flexible database that feels like a spreadsheet but works like a visual board. Airtable gives you both. In this guide we walk through creating a design asset library, building mood‑board views, linking prototypes, and automating file naming. Follow each step, copy the sample formulas, and you’ll have a production‑ready Airtable base in under an hour.

Table of contents

• 1. Set up your first design base
• 2. Choose the right view for each design stage
• 3. Build fields that speak design language
• 4. Automate repetitive tasks
• 5. Connect Airtable with Figma, Sketch, and Cloud storage
• 6. Airtable vs. Notion for design assets
• FAQ

1. Set up your first design base

1.1 Create a new base

Log in to Airtable, click + Add a base, and choose Start from scratch. Name it Design Asset Library.

1.2 Define tables

We’ll start with three tables:

• Assets – all images, icons, and PDFs.
• Projects – each design brief.
• Clients – contact info and brand guidelines.

1.3 Import existing files

Drag a folder of PNGs onto the Assets table. Airtable creates an Attachment field automatically. It also adds a Name field populated from file names.

2. Choose the right view for each design stage

2.1 Mood‑board Grid view

Switch to Grid view. Click the Attachment column header, choose Customize field type → Show as thumbnails. Resize the thumbnail to 150 px for a clear visual board.

2.2 Kanban view for project phases

Add a Single select field called Phase with options: Concept, Design, Review, Handoff. Then create a Kanban view grouped by Phase. Drag cards between columns to update status instantly.

2.3 Calendar view for release dates

Insert a Date field named Launch Date. The Calendar view lets you see upcoming releases at a glance.

3. Build fields that speak design language

3.1 Color palette field

Use a Single line text field and store HEX codes separated by commas, e.g., #FF5733, #2E86C1, #F1C40F. Add a formula field to render colored squares:

ARRAYJOIN(
  ARRAYMAP(
    SPLIT({Color Palette}, ", "),
    HEX => "<span style='display:inline-block;width:12px;height:12px;background:" & HEX & ";margin-right:4px;'></span>"
  ),
  ""
)

Enable “Allow rich text” in the field settings to see the swatches.

3.2 Asset usage counter

Create a Rollup field in the Assets table that counts linked records in Projects. This tells you how many times an asset appears across briefs.

3.3 Versioning formula

Formula for automatic version numbers:

CONCATENATE(
  "v",
  FLOOR((DATETIME_DIFF(NOW(), {Created}, 'days') / 30) + 1)
)

The field updates each month, giving you a simple version tag like v2.

4. Automate repetitive tasks

4.1 Rename files on upload

Create an automation:

1. Trigger: “When a record is created” in Assets.
2. Action: “Run a script”. Use the script below to rename the attachment to {Project Code}_{Name}_{Version}.

let table = base.getTable('Assets');
let record = await input.recordAsync('Pick a record', table);
let attachment = record.getCellValue('Attachment')[0];
let newName = `${record.getCellValue('Project Code')}_${record.getCellValue('Name')}_${record.getCellValue('Version')}.${attachment.url.split('.').pop()}`;
await table.updateRecordAsync(record.id, {
  'Attachment': [{url: attachment.url, filename: newName}]
});

4.2 Notify designers on status change

Use the built‑in “Send email” action. When Phase changes to “Review”, email the lead designer with a link to the record.

5. Connect Airtable with Figma, Sketch, and Cloud storage

5.1 Airtable ↔ Figma plugin

Install the official Airtable Sync plugin. In Figma, click Plugins → Airtable Sync → Connect Base, select your Design Asset Library, and map fields to component properties. Updates in Airtable instantly reflect in Figma.

5.2 Zapier workflow for Sketch

Zapier can watch new records in the Assets table and add them to a Sketch library folder. Example Zap steps:

• Trigger: “New Record in View” → Assets Grid.
• Action: “Upload File” → Sketch Cloud (requires Sketch for Teams).

5.3 Sync attachments to Google Drive

Use Airtable’s native “Run a script” automation to copy attachments to a Drive folder. Sample script:

let table = base.getTable('Assets');
let query = await table.selectRecordsAsync();
for (let rec of query.records) {
  let att = rec.getCellValue('Attachment')[0];
  await fetch('https://www.googleapis.com/upload/drive/v3/files?uploadType=media', {
    method:'POST',
    headers:{'Authorization':`Bearer ${YOUR_TOKEN}`, 'Content-Type': att.type},
    body: await (await fetch(att.url)).blob()
  });
}

Replace YOUR_TOKEN with a short‑lived OAuth token. Store the token securely; do not hard‑code it in production.

6. Airtable vs. Notion for design assets

Feature	Airtable	Notion
Relational linking	Full‑featured linked records, rollups, lookups.	Limited relation via “Relation” property.
Attachment storage	2 GB free, 5 GB per Pro seat; per‑file limit 100 MB.	5 GB free, no per‑file limit (but slower preview).
Views	Grid, Kanban, Calendar, Gallery, Form, Gantt.	Table, Board, Calendar, Gallery (no Gantt).
Automation	Native automations, scripting, Zapier, Make.	Limited built‑in automations; relies on external tools.
Design‑specific plugins	Figma, Sketch, Adobe integrations.	No official design‑tool plugins.

For most design teams, Airtable wins on relational power and automation. Notion shines for documentation but falls short on asset handling.

FAQ

What is the best Airtable view for mood boards?

The Grid view with large attachment thumbnails works best, because you can see images side‑by‑side and reorder them with drag‑and‑drop.

Can I connect Airtable to Figma?

Yes. Use the Airtable Figma plugin or Zapier integration to pull records into a Figma file as components.

How do I automate file naming in Airtable?

Create a formula field that concatenates project code, date, and version. Then use an Airtable automation to copy the result to your cloud storage.

Is there a free plan that supports designers?

Airtable’s Free tier includes unlimited bases, 1,200 records per base, and 2 GB attachment space—enough for small design projects.

What are the main differences between Airtable and Notion for design assets?

Airtable offers richer relational fields, stronger CSV import, and native grid view. Notion excels at nested pages and documentation. See the comparison table above.

Using Airtable as a design hub saves time and reduces file‑hunting. Set up the base, pick the right view, add formula fields, and automate the boring stuff. In a few clicks you’ll have a living library that scales with your team.