Airtable Updates

Airtable mention · April 18, 2019

The Best Project Management Software for Small Businesses and Individuals in 2019

Managing projects in a small business setting can be even more challenging than doing so within a larger company. A big business might have a project manager for marketing, another for sales, another for product development. The small business project manager, on the other hand, oversees multiple departments and more
Airtable mention · April 8, 2019

Organize Your Life with the Agile Method

A to do list can help you keep track of the tasks you need to complete. But when it comes to actually completing those tasks—that's a different story. It's hard to decide which tasks to take on first, and it's tempting to start with whatever' more
Airtable mention · January 5, 2018

How Support & Product Teams at Calendly Save 10 Hours Every Week

How you communicate within your company depends on things like your size, your industry, and your tools. Small startups might talk across the kitchen table to each other. Titans of banking have guidelines on how to share information with other teams. But how does a smaller company—that isn' more
Airtable mention · November 8, 2017

How youthSpark Created an Automated System Without Developers

A leading innovator in the battle against human trafficking, Georgia's youthSpark transforms the lives of youths at risk for exploitation and abuse. They have become a thought leader in reducing child exploitation and sex trafficking rates in Georgia and across the country, too. Part of youthSpark's mission more
Airtable mention · October 31, 2017

InVision Saves 10 Hours Each Week with Automated Workflows

We've all heard "work smarter, not harder." Maybe you see it every day on a poster hanging in the break room or in an email signature. Cliche though it may be, small teams take this mantra to heart. With fewer resources at their disposal, they have to be more
Airtable mention · October 9, 2017

How an eCommerce Business Saves 40 Hours Every Week with Automation

Thanks to smartphones, navigation systems live in your pocket with your handheld computer, instant messenger, camera, and phone. No more bulky GPS devices wired into your car's lighter and windshield mounts. Between Waze, Google Maps, and Apple Maps, you'll find your way wherever you're headed. But more
Airtable mention · August 30, 2017

ScholarMatch Tracks Donations Across Databases & Email Automatically

Applying for college intimidates many a high school junior and senior. Getting an acceptance letter is only part of the complicated, daunting process. There's securing financial aid, getting into a dorm, registering for classes, buying books. But not everyone makes it that far. Maybe college is a financial more
Airtable mention · February 6, 2017

How the Zapier Team Uses Airtable

The secret's out. Here at Zapier, we have a major app crush on Airtable, an easy-to-use relational database. Over the past year, Airtable has emerged as an app darling across the Zapier team, used by nearly every team from data science to product marketing. We even have an more
Matthew Guay
Written by Matthew GuayLast updated June 6, 2018

Databases are the beating heart of almost every app business app. CRMs, project management apps, content management systems, accounting tools, and more are often a database with a form to enter data and ways to view it. You could make your own that worked exactly like you want—though if you're not a developer, making your own database powered app is daunting. They may only be a way to store lists of data, but cryptic SQL commands and outdated admin interfaces make databases feel like the domain of those willing to invest significant time.

And so, for simpler lists, we reach for spreadsheets, copying and pasting data from other sheets as necessary. It's not perfect, but it is simple.

Airtable's hybrid spreadsheet and database tool changes that. Similar to Microsoft Access on PCs, it's an incredibly simple way to make a relational database.

The basic difference between a database and a table is that most databases are *relational*—they let you easily pull in data from parts of a data table into other views. Airtable takes that a step further, letting you pull in data from other tables and view it in a card-like popover without needing to open that other table. You can include images, checkmarks, tags, formatted text descriptions, and more in your tables to make a visual database that looks and work just like you want.

Adding your data is as simple as using a spreadsheet. Type in text, drag in photos, add checkboxes for tasks, link files from Dropbox, notes from Evernote, and more, and organize everything in cells. List locations, say, in one table, then lodging options that are tagged to those locations in another, and you can view the relevant data without switching between tables. Bring in your whole team to collaborate, just as you would in Google Sheets—complete with comments and discussions on every individual piece of data.

Then, use filters and sorting to drill down and find what you need. Instead of searching for items you need each time, you can filter by checked off items, show only items with a specific category, and stack filters to look for multiple things at once. Once you've found the data you need, you can save it as a view to jump back in and see that set of data again anytime in a click.

If you already have an idea for the database you need, it's simple to turn it into a working tool for your team in Airtable. Or, you can start out with with an Airtable template, for a simple way to start an HR database, task management tool, product tracker, and more. Each comes with pre-written data, so you can get an idea for how the database should work and then replace it with your own data.

Airtable can also work with your own apps. Using Zapier integrations, you can connect an Airtable database to automatically send emails, log customers, and more. Or, you can use their API to build your own integrations and add extensions to do even more with your data.

Microsoft Access doesn't have to be the only way to make a simple database. Airtable gives you a modern way to organize data as a team online, one that's simple enough for anyone to use but powerful enough to organize any data you need.

Originally published February 1, 2016; updated June 6, 2018 with new features and screenshots

Have any feedback on this overview, or something we should change? Let us know!

Use our free platform to build a single Zapier integration and instantly connect your app with 1,500+ others.

Become a Zapier Integration Partner

Organize anything with Airtable, a modern database created for everyone. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management.