Project Management is something many of us struggle with in some shape or form. Given the focus on efficiency, we want to make sure that we are getting the most out of our 'work-time' and this means finding ways to do things faster and with greater accuracy. This becomes even more true when your...
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...
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...
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.
...
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...
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...
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...
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...
There are two common ways to get data into a database. You can either:
- Import a dataset in bulk
- 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...
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...
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...
Gantt Charts are a commonly used tool in project management, so it’s no surprise that Airtable recently added these as an option as a Block. (Blocks are one of those ‘pro’ subscription features and they allow you to visualize your data in customizable ways.)
As is true with...
