Latest Articles

How to Prefill a Hidden Form Field

One of the most common questions we get in our coaching program has to do with an advanced prefilled form feature. This is most often requested by businesses who want to send prefilled forms to their clients, but they want to be able to HIDE some of the prefilled data. For example, let's suppose that you want to send a prefilled form to your clients and ask them for feedback. When...

Continue Reading...

How to Import Data into Airtable without Duplications

Recently, I've received several questions about importing data into your Airtable database. Before I just jump right in and start discussing the how - let me first address some definitions and scope questions.

Firstly, when I think about IMPORTING data, I instantly imagine that we are discussing a bulk data transfer. If you have questions about bringing individual records into a...

Continue Reading...

How to Automate your Invoicing from Airtable

This morning, I was speaking to a prospective client - let's call him David. David had some questions about how Airtable could improve his business. We spoke about potential automation and process improvements for his business. Soon, the discussion turned to accounting - specifically Quickbooks Online. I was sad to hear that often David would set his clients up on payment plans, but without...

Continue Reading...

Why you Need a Custom UI for Airtable

One of the biggest limitations to Airtable is that the software is unable to link from one base to another. This is something that I've heard many clients complain about, but I think that this 'issue' is really rooted in a different problem. Ideally, all of our data would live in one single database (all interconnected). With everything in one database, we don't have to concern ourselves with...

Continue Reading...

Automate Email with Attachments

There are many ways to automate email and not all of them are appropriate in every situation. In this post, I'm outlining the steps for building an automated email that includes an attachment or file that is first stored in an Airtable database. This type of email automation is best utilized in the cases where (1) you are sending internal emails or (2) your email recipient has requested the...

Continue Reading...

Airtable Updates: April 2020

Airtable updates have been coming out at an increased rate recently and it's arguable that the updates from April 2020 are the most impactful to date. This past update included four massive improvements, each so powerful as to demand an entire post of its own. However, in the interest of expediency, I want to touch on them all from a high level to showcase the incredible improvements that...

Continue Reading...

Airtable Permissions: Editor vs. Creator (and Personal Views)

Sharing access to a database comes with a bunch of options - but it can be hard to understand the best choice for every case. In this video, I walk through the massive differences between the Editor and Creator levels of permission inside of Airtable.

As a general rule, I tend to advise clients to only have one or two users per base at the Creator permission level. Creators basically have...

Continue Reading...

Using Airtable to Assist the Elderly

The local Area Agency on Aging (AAA) is helping the elderly in our community to shelter in place during the COVID-19 pandemic by purchasing and delivering supplies to them. Employees of the AAA are driving around to purchase requested items at various stores, but they really needed a way to track the purchases that were being made. As a government funded program, the audit requirements...

Continue Reading...

Creating a User Portal for Airtable

Airtable is so incredibly powerful, but like all software, it has some limitations. Possibly the largest of those limitations is being able to limit access for your users.

Yes, Airtable has provided us with four levels of permissions (Creator, Editor, Collaborator, Read-Only). So, when you share access to your database, of course you can select from these four permission levels to determine...

Continue Reading...

Track Inventory and Reordering with Airtable

Tracking inventory is a vital part of so many businesses. Inventory is a tricky thing to manage - having too much is an inefficient use of capital, and having too little produces delays and lost opportunities. So how do you get that sweet spot and know how much inventory to keep on hand? How do you know when it's time to reorder?

Sure there are tons of expensive inventory solutions out...

Continue Reading...
1 2 3
Close

50% Complete

You're almost there!

Get our FREE Airtable Crash Course delivered to your inbox!