Free Training

Blog Posts

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

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

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

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

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

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

Continue Reading...