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

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

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

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

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

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

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

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

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

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