Bring your workflow into Airtable

Workflows are built on top of information—in some cases, mountains of it!

With Airtable, you can organize that data to best suit your needs. And now that you’ve done the work of mapping your workflow, you can optimize your Airtable base to match.

In this step, we’re going to take the workflow you’ve created, and start making it quicker, easier, and more reliable with Airtable. With your workflow map as your guide, set up (or update!) your base’s tables, fields, linked records, and views.

 

1. Organize your workflow’s structure

To create your workflow map, you outlined the information required across each step and organized that information into groups. It’s now time to translate that work into Airtable—where each group will become its own table.

Pro tip

If you have existing information that lives in spreadsheets or other data sources, you can import this data directly into your tables.

For example, our web agency would set up tables for projects, assets and clients:

 

Take action: Create new tables

Create a table for each key group of information that you established in your workflow map. Then, add records to every table to capture all of the items in each group.


Try it now

Create a table

2. Track your workflow's details

You’ve organized your tables to hold your key types of information. Now it’s time to add in the other important details your team needs. 

Each piece of information that you listed under a particular group becomes a field for that table. If there’s a detail you need or an action you need to take, add it as a field.

Pro tip

Airtable includes over 25 different field types to choose from, such as multi-selects, checkboxes, URLs, emails, phone numbers, and formulas. Feel free to experiment with field types—if you find a field type that better matches your requirements, switching is easy!

For example, the web agency might apply these field types to their Project table like so:

The fields you add to your tables will depend on your specific workflow, but here are some field  types that are commonly used across workflows:

Single select

Attachment

Tag each record according to pre-selected categories, such as status, priority, or size.

Capture relevant documents, images or videos, such as contracts, proofs, and assets.

Date

Collaborator

Track important dates for each item in your list, such as project timelines, asset due dates, or contract start and end dates.

Assign ownership or communicate with the appropriate stakeholders you’ve identified in your workflow.

Take action: Create new fields

Add fields to capture each piece of information in your workflow map. Add as many fields as you need—you can always add or remove fields later, as your needs change.


Try it now

Add a field

3. Connect your workflow together

While building these tables, you probably found that some fields and records will relate to each other across different tables. Airtable is built to handle exactly this type of relationship, so your new tool can be as dynamic as your workflow!

Linked records allow you to reference data across tables—without having to make updates in multiple places.

Pro tip

Linked records can eliminate redundancy, enforce data integrity, and enable new methods of automation—turning your list of records into a fully fledged relational database.

Linked records allow data to be entered once, and updated on multiple tables instantly, saving time and ensuring accuracy. They also give you access to some powerful field types—count, lookup, and rollup, which allow you to perform calculations and actions across tables.

For example, the web agency might want to associate each project to its respective clients. Instead of creating a new, manual “Clients” field in the Projects table, they can link directly to the Clients table:

 

Take action: Create linked records

Take a moment to understand your workflow’s relationships by reviewing the data in your tables and drawing connections. Which items are common across groups? Once you have identified important relationships for your workflow, you can add them into your base using the linked record field type.

4. Curate how you view your workflow

Different information will be relevant at different moments and for different people in your workflow. With views, you can build custom ways of looking at your data, to give each stakeholder quick access to the information they need.

For example, a project owner at the web agency could set up an “In progress” view that filters out completed projects and shows only the fields necessary to better prioritize design assets:

 

You can customize any view with several options: filter down to relevant records, hide unnecessary fields, sort to a preferred order, and group similar records together. You can also use different view types to create different visual ways to look at your data.

If you're tracking...

Use this view...

All the details

Grid view

Survey responses from your email newsletter

Form view

Project status or team workload

Kanban view

Upcoming due dates for the next 2 weeks or month

Calendar view

Multiple overlapping parts of a major project over time

Timeline view

Use these tools to create views for your team members so they can see the most important information for their roles—and to give them space to customize their interface to their own needs.

Our web agency could build a view for designers to show design assets due in the next two weeks:

 

Take action: Create new views

Create as many views as you need to support the different steps and stakeholders in your workflow. 


Try it now

Create a view

Now you have a series of tables based around your workflow, all of which keep track of important factors for your work, and connect in key ways. Next, we’ll show you how to import data from other tools, to bring your existing information into Airtable.


About the author

AirtableOur mission is to democratize software creation by giving everyone the power to create—and not just use—the tools they work with every day.

Filed Under

Build your workflow

SHARE

Next up in Airtable for Build your workflow

11 of 12

Join us and change how you work.