Latest Articles

Build Automation Using Table Sync

Airtable Sync allows you to now connect information across multiple databases - finally! However, the sync does come with a limitation, specifically that syncing requires data to be updated in the 'source.' This means that, while you can see the data in synced table, the underlying data can't be edited without going to the source base. As you might imagine, this limitation makes...

Continue Reading...

How to Create a Script in Airtable (without knowing code)

Confession time: For as much as I love Airtable, one of the biggest things that initially drew me to the software is that it was a "no-code" platform. This fit into my skillset nicely. I understood databases and automation, but code always felt just a bit out of reach for me. So naturally, I took to Airtable immediately. But slowly and over time, Airtable has been introducing bits of code into...

Continue Reading...

How to Map a Subscription Business

One of the most difficult parts of building a relational database is in establishing the ideal database architecture. To get the intended result, it's best to start with a mapping process to help you visualize the flow of data.

This video outlines the first steps of architecture for a subscription business. I start with a mapping tool (Whimsical) to build my mind-map. From there, I transition...

Continue Reading...

Creating a Weekly Summary of Events

Someone in the forums recently asked about creating a weekly summary of events to be submitted in an automated email. If grabbing bulk data was possible within Zapier or Airtable automation, this would be a fairly easy thing to automate. However, bulk data isn't natively available to these platforms... so then how can we build an automated process?

The secret lies in linking these records to...

Continue Reading...

Organizing Job Applications and Review

Building a workflow in Airtable is an important part of creating scalable processes. One workflow that almost all growing businesses have is the need to receive and review job applications. In this video, I break down how you can create an application process using Airtable and also how to automate the creation of managerial review.

Of course, review is a semi-manual process. There will always...

Continue Reading...

Using Airtable Sync

The future is looking very bright for Airtable. Not only did they receive another round of investment at $185M this week, they also released some incredible new features. The most anticipated of these is arguably what they have dubbed Airtable Sync. This new tool gives us the ability to connect data across our Airtable bases (databases)!

If you find yourself creating the same tables in...

Continue Reading...

September 2020: New Airtable Updates

Airtable has shipped some very exciting new updates for September, 2020! Check out this walkthrough as we review their new announcement and dive into the future for the software. Specifically, Airtable has focused on three new features:

  1. Blocks are now Apps and there's now a marketplace for developers to share their creations
  2. Airtable Automations are officially announced, including new trigger...
Continue Reading...

How Airtable Automations Differ from Zapier

With the new release of the Airtable Automations feature, Airtable has unlocked amazing new potential for its users. While it's still in the early stages, this feature allows us to automate from directly inside our databases, without needing to use a third-party software. But does this mean that users can completely abandon their Zapier accounts and run all of their automation directly inside...

Continue Reading...

Capture Historical Data Snapshots in Airtable

The most powerful feature of Airtable is that it is a relational database. However, this very capability can often prove troublesome. More specifically, a relational database is outstanding at presenting the current state of things. However, it's not always the best fit for demonstrating historical data.

For example, imagine you have an inventory tracking database built in Airtable. As new...

Continue Reading...

New Feature: Exploring Airtable Automations

For the past three years, I've been building my automated Airtable processes using Zapier. If you're unfamiliar with it, Zapier is a powerful tool that connects software on the internet using "If this, than that" logic. It allows you to set up processes that are governed by a set of rules. For example, if 'x' happens, then do 'y' and 'z.'

A lot of our work here at GAP Consulting relies heavily...

Continue Reading...
1 2 3 4 5 6 7 8
Close

50% Complete

You're almost there!

Get our FREE Airtable Crash Course delivered to your inbox!