Given Airtable's flexibility, it's not surprising that users sometimes struggle to build the optimal architecture for their databases. One question I've received numerous times over the past month has been in relation to structuring around attendance for a schools, classes, or events.

When I hear the word attendance, I think back to the scantrons that my high school teachers used. Student...

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

One of the newer Airtable Blocks makes data scraping from the internet pretty easy. In fact, with a few mouse clicks, it allows you to add an extension to your Chrome Browser that will plug website data directly into your Airtable database. I'm talking, of course, about the Web Clipper Block.

When I first heard about the Web Clipper, I was a bit skeptical. My initial thought was that I...

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

By default, Airtable is a relational database software. That's an important place to start, given that this post will be going into detail on Airtable Forms. Let's temper our excitement from the start - Airtable's purpose was never to create the most robust "form software" for the modern era. That said, they did include form functionality and the forms have some pretty cool use-cases.

...

Confession time...

For several months, our development team has been developing in a system other than Airtable **gasp**!

This might come as a shock, since we've built a name for our firm as Airtable Experts. But, as is true with all software - sometimes you need additional functionality. As I tell all my clients, Airtable is fantastic, but it has its limitations (what doesn't?)

So, we...

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

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

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

As you transition to Airtable, there's a great chance that you'll need to first import data from your previous or current system. In many cases, this can sound quite cumbersome, but Airtable has actually created a simple process by which to do this.

One thing that should be added to this is the need to get accurate date/time stamps of the creation of your data. Already available to you,...