mermberfix logo x
The MemberFix Team’s got you covered.
Membership plugins

How we organize our business using Airtable

airtable business


The goal of every business is to be productive, which is determined by how efficient and organized you can make all of the functions within your company.

That’s why it can be such a grind to find a best-in-class solution to help you keep all of the components of your company neatly organized and working together smoothly.

If you are running a startup, your team is most likely virtual and scattered across the globe, which greatly compounds the chance for misunderstandings and confusion about who is working on what, and how much time is being spent on various activities / customers.

The conventional idea of putting your team in a room with a Gantt chart is not going to work. And project management software is often expensive and cumbersome.

As a company, one of your main operational goals is to spend as little time as possible on management activities. Using a corporate grade software (e.g., JIRA) is not always a great solution due to its complexity and cost. Good luck getting team buy-in to spend 6 months to learn a new app.

Here at MemberFix we’ve found and fallen head-over-heels in love with what we think is one of the best, most flexible, most user friendly, and most affordable solutions on the market.

It has most everything we need with almost nothing we don’t. This tool is called:


Why Airtable?

Airtable boasts a familiar spreadsheet-esque structure, customizable data fields, sophisticated formulas calculations, and much more. At first glance this may seem to be yet another hunk of software in a long line of spreadsheets tools. But that is where the similarities end.

Airtable is a totally different type of tool working solely in the cloud, designed to have speed and stability and to boost the creation of datasets to unbelievable speed using visual tools.

Airtable might not be as well-known as other solutions like Jira, Trello, Asana, etc., especially when it comes to the use case we’ve adopted it for—managing business processes. But it has become THE essential part of managing our projects and processes. In fact, we even call our shared Airtable base “The MemberFix Control Center”—because that’s exactly what it is!

Image2525202019 02 27252520at2525202.50.12252520PM - How we organize our business using Airtable

Airtable allows you to log entries in spreadsheets which can be turned into diverse, expandable, versatile sets of data. Pieces of data can be linked to each other to contain a web of information for everything relating to your company, tasks, documents, making it perfect for tracking large-scale, detailed data sets.

In English, that means—unlike a Google Sheets spreadsheet—you don’t duplicate the same piece of data in different places. You simply LINK to existing data from another sheet.

Combine this with the ability to generate different views from traditional spreadsheets to calendars and Trello-style Kanban boards and you have an extremely powerful data, process, and project organizational tool.

This article is the first one in a series where I am going to explain how we use Airtable in our company.

How we use Airtable in our company

Below you’ll find a quick overview of this tool and how we use it.

MemberFix Control Center  Timesheet Airtable Google Chrome 2019 02 20 03.00.05 - How we organize our business using Airtable

In the screenshot above you can see that Airtable looks like the typical spreadsheet you’re used to. This entire collection of data including all of the tabs is called a “base”.

But unlike an Excel spreadsheet, Airtable lets you pull data from one tab into another tab within the same base. You don’t need to be a professional Excel user to create these bases because almost everything is done in a user-friendly, visual interface.

For example, in the screenshot below you can see that our team members’ names are all entered in the ‘Team’ tab. When a team member starts to work on a task for one of our customers he makes a timesheet entry in the ‘Timesheet’ tab. Instead of entering his name over and over again for each timesheet entry, he simply pulls his name (and all of the related data) as a linked record from the ‘Team’ tab directly into the timesheet tab. And the same goes for customers—we pull their data from the ‘Customers’ tab.

Airtable’s “linked” records

Linked records work in both directions. So we can easily create an on-the-fly filter to figure out how much time a particular team member has spent working on a particular customer’s tasks in a given date range. This is just a preview of the incredible filtering and sorting power of Airtable; it can do so much more! But it all ultimately depends on this unique ability of being able to link records in different tabs, which is what makes Airtable so special.

This ability saves you untold amounts of time, prevents duplication of data in the database, and preserves (and in fact, encourages!) you to organize the structure of your company along logical lines.

MemberFix Control Center  Timesheet Airtable Google Chrome 2019 02 20 03.06.13 - How we organize our business using Airtable

Perhaps even more exciting is that you may edit data from another tab directly from within the tab you’re working in by opening that linked record entry!

There’s no need to open the tab that actually contains the data, search for your required record, etc. You have everything you need here in the linked record location!

You may we wondering, can you link a record from another table “into” this view? Yes, you can have as many layers of linked data in your base as you want!

For instance, in the example below we are pulling records from the ‘Team’ table and ‘Customers’ table into the ‘Timesheet’ table:

MemberFix Control Center  Articles Airtable Google Chrome 2019 02 20 03.38.37 - How we organize our business using Airtable

Airtable “views”

As mentioned earlier, you can filter and sort data within the views, hide/show fields, assign different data types, group data by single or multiple fields. And this is only the tip of the iceberg! Here is the example of our table that we use to keep all of our Operating Procedures (SOPs) updated:

MemberFix Control Center  SOPs Airtable Google Chrome 2019 02 20 03.22.23 - How we organize our business using Airtable

Besides the usual table view you may use the Kanban view (in our business we use it for scheduling our long term tasks, like this blog post you are reading now) 😉 :

MemberFix Control Center  Articles Airtable Google Chrome 2019 02 20 03.35.46 - How we organize our business using Airtable

Or you can use the Calendar view to keep your schedule, time off, etc., for your team on track:

MemberFix Control Center  Schedule Airtable Google Chrome 2019 02 20 03.35.13 - How we organize our business using Airtable


Hopefully you’ve now got a little tast of the incredible power of Airtable as an organization tool.

It provides numerous ways to track performance and time on tasks while setting controls to keep certain groups focused on a particular project and getting the right information to the appropriate people.

Of course, let’s be fair and point out that there’s no perfect app.

Much like Trello, Airtable’s use in terms of dedicated process management is pretty limited. While it is great for managing your projects and starting off your processes, there is very little room for giving instructions for tasks and even less so for automatically providing said instructions.

(For this component of our business we’re building our own custom training portal for our team.)

Overall, Airtable is a great solution to store interlinked data and projects/files, generate reports, and organize all of the disparate data and information of your business into a central location where it’s easy to interact with and understand that data.

In the next articles of this series, I will dive deeper into some of the specific ways we use Airtable to manage different areas of our business using real life examples…

Stay tuned!

Other articles in this series

1 – How to use Airtable to manage your team’s schedule

In this article I explain how we set our entire team’s schedule using Airtable’s awesome calendar view. This is critical if you’re running a remote (distributed) company with team members across different time zones and in different employment arrangements (e.g. full time, part time, contractor).


You may also enjoy...

WordPress based membership sites have certain requirements, and make use of certain applications that, in my experience, makes most of the popular hosting providers a poor choice.
Need to protect some content but don’t have time? MemberFix it. Need to create a new membership level? MemberFix it. Need to link up some videos in your members area?
Learn how to migrate your community from Invision Power board (IPBoard) to
Jane Copeland is a business coach for successful female entrepreneurs based mainly in Australia. Jane started her online journey with nothing but a blog and a whole lot of determination.
Notify of
Inline Feedbacks
View all comments