Latest Articles

Steps for Building a No Code App

These are uncertain times - that much is undeniable.

There are so many questions and fears that I continue to hear echoed on social media. For many of those questions, I don't have good solid answers - however, there are some questions that I have personally worked to solve for the past several years...

How do I transition my business to work remotely?

How can I work more...

Continue Reading...

How to Automate an Approval Process in Airtable

An approval process is an important check and balance for any business. As your team grows and you add layers of complexity to an operation, you'll want to empower your leadership with a clean and simple way to manage. For this, you can leverage the power of Airtable and Zapier to organize and automate the necessary steps.

In this tutorial, I walk through an enhanced approval process...

Continue Reading...

Coda Project Part 2: Using Buttons in Coda

When we left off with our Coda project (Part 1 here), we needed to add functionality to buttons inside our doc. To set the stage here, this specific part of our process is to determine an outcome from a consultation. Ideally, if a consultation goes well and the prospective client can use our help, we'd like to offer some next steps. Perhaps this is in the form of a proposal, or maybe we...

Continue Reading...

Coda Project Part 1: Bringing Data into Coda

For the past couple of years, GAP Consulting has managed all of our ongoing leads, projects, payments, etc. (basically our entire business) from an Airtable database. I hope this comes as no surprise, seeing as this is exactly how we help our clients. As I mentioned in an email from a couple of weeks ago, we realized that we essentially help create low-code apps for our clients. To...

Continue Reading...

Using Zapier Paths in an Automation

Last week, I showed the power of using Conditional Form Logic - the end result is a form that adjusts as it is answered. Different questions become available based on inputs as they are received. As you might imagine, building automation for this type of form is more advanced, giving us the perfect excuse to explore Zapier's Paths.

Before we get too far, I would be remiss not to mention...

Continue Reading...

Using a Conditional Form with Airtable (Part 1)

There are two common ways to get data into a database. You can either:

  1. Import a dataset in bulk
  2. Bring in data one with each new record submitted

For the most part, I recommend the first option, bulk imports, only when first setting up a database. Ideally, once the base is established, it makes the most sense to bring new records in automatically (saving you the need to import data...

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...

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...

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...

Automating with Multiple Data Sets

My recent posts have covered a variety of use cases for automation. However, in all the commotion of “create documents in the cloud” or “automatically create folders for projects,” I realize there’s a complicated (and critical) step that we’ve never taken the time to address. Specifically: building an automation between multiple tables.

Imagine this...

Continue Reading...
1 2
Close

50% Complete

You're almost there!

Get our FREE Airtable Crash Course delivered to your inbox!