Latest Articles

Understanding Airtable Formula Syntax

A lot of people have asked me how I learned to write Airtable formulas. I wish there was a silver bullet solution, but the truth is that formulas are one of the more complicated parts of any software. However, that's no reason for despair. In this vlog I put together three tips for understanding the syntax of Airtable formulas... let's jump in!

The first tip is that a formula in Airtable...

Continue Reading...

Exploring the Gantt Chart in Airtable

Gantt Charts are a commonly used tool in project management, so it’s no surprise that Airtable recently added these as an option as a Block. (Blocks are one of those ‘pro’ subscription features and they allow you to visualize your data in customizable ways.)

As is true with most blocks, you must first tell Airtable in which table and view your underlying...

Continue Reading...

Finding an Airtable Record with a Zapier “Search Formula”

When building automation to support your Airtable databases, you’ll likely encounter the need to FIND A RECORD in Airtable. This is one of the action steps that Zapier makes available with the Airtable integration. Finding a record is commonly used in situations when you need to update a record (you have to locate it before you can update it) or when you need to link one record to another...

Continue Reading...

Building a Multi-step Approval Process

Recently, one of our coaching clients asked about building a multi-step approval process inside of Airtable. While there are several ways that someone could go about building this, they all rely on the same two building blocks. In brief, you’ll want to include a table to track the Process and then connect that to the Approvals. Once you’ve linked these two tables,...

Continue Reading...

Track Project Completion in Airtable

Project management is a massive undertaking – one that I couldn’t possibly do justice in a brief 15 minute YouTube video. That being said, there are definitely some factors that must be included with any kind of task tracking software. Often, I’ll speak to people using Trello or Asana, and they’ll explain to me how they need information to travel between their...

Continue Reading...

An Advanced Look at the Page Designer Block

I’ve been getting many requests on a deeper explanation of the Page Designer Block – so here it is!

The Page Designer Block is perfect for displaying the data in your base in a more visually appealing way. If you have reports that you need to see that summarize your underlying data, this may be a good solution for you.

As I’ve said many times before, the Page Designer Block...

Continue Reading...

Create a Simple Dashboard for Your Pipeline

Recently, I shared how you can build an automated process to document your payments as you receive them for your company. Accounting software is great at doing this already, but the part that it usually misses is its inherent lack at tracking the possible business that you have in your pipeline.

Quickbooks, Xero, and Wave (among others) are awesome tools at organizing your financial...

Continue Reading...

Organize Revenue with Automation and Airtable

Revenue. One of the most exciting words to business owners. It’s the fuel in our engines of change and the catalyst for a better life. Without revenue, every business would be little more than a shell of ideas and good intentions.

Why then do so many businesses neglect to pay attention to their revenue? Putting it simply, failing to track revenue is like sailing a ship without a compass....

Continue Reading...

Share Access to Limited Data – Introducing Airportal

A massive complaint that I hear from Airtable users is that they can’t grant partial access to their data. For example, imagine this case:

  1. A company has consultations with clients that are recorded
  2. Consultations are then shared with clients
  3. Clients want to see when they have another consultation, check previous versions, schedule new appointments, etc.

This is a pretty common style of...

Continue Reading...

How to Build an Email Funnel with Airtable

I struggle with business email in a big way – the main issues I have are as follows:

  1. I hate having multiple ‘systems’ in my business – why can’t everything happen from one place?
  2. Along those same lines, with a new system comes new procedures and practices… no thanks!
  3. The decision fatigue is real – there are so many Email Service Providers (ESPs) to...
Continue Reading...
1 2
Close

50% Complete

You're almost there!

Get our FREE Airtable Crash Course delivered to your inbox!