• Home
  • Latest
  • Fortune 500
  • Finance
  • Tech
  • Leadership
  • Lifestyle
  • Rankings
  • Multimedia
NewslettersBusiness by Design

‘We are like a LEGO kit’: How Airtable mastered the art of the open-ended use case and became the premier database platform

By
Nicole Gull McElroy
Nicole Gull McElroy
Down Arrow Button Icon
By
Nicole Gull McElroy
Nicole Gull McElroy
Down Arrow Button Icon
March 29, 2022, 10:36 AM ET
Airtable Chief Product Officer Andrew Ofstad
Airtable co-founder Andrew Ofstad. Ofstad launched the cloud collaboration platform with CEO Howie Liu in 2012.Courtesy of Airtable

When Andrew Ofstad and Howie Liu first started their cloud collaboration company Airtable in 2012, they aimed to provide people who aren’t programmers with tools to build software. Pieces of that process, they realized, could readily be borrowed from childhood. “We are like a LEGO kit,” says Ofstad, co-founder at Airtable. “You have all the LEGOs and it’s easy to snap them together. But, one day, you want to build the Millennium Falcon. How do you make sure those components plug together in a very complex way?”

Answering that question has brought Airtable and its founders to an incredibly exciting point in the company’s trajectory. With 850 employees and 300,000 organizations using the program every day, Airtable is in extreme growth mode. In December 2021, the company announced $735 million in series F funding (which brought total investment to $1.36 billion) and clocked a valuation of $11 billion. It is, so far, a design-led success story and one that offers a handful of lessons on how to build a product with an open-ended use case.

In fact, use cases could not be more disparate: The April 2017 issue of Idaho Farm Bureau’s Producer details how one McKay, ID-based cattle rancher named Brett Zollinger used Airtable to manage his herd and seamlessly log and connect cattle vaccinations, pregnancy checks, and other records in one place. At the same time Blue Origin, Jeff Bezos’ effort to launch space vehicles, has used the system to track rocket parts. Others have turned Airtable into a tool to plan marketing campaigns, map out events, and even manage hobbies such as book clubs, craft supplies or recipe databases. Ofstad and Liu have been incredibly successful at striking a balance for their customers between a low barrier to entry and an incredibly high ceiling for innovation. 

Ofstad has said this tension between a low floor and a high ceiling is what differentiates Airtable from its competitors (of which there are now many: Monday.com, Asana, Smartsheet are just a few) and what informed its most recent offering,Interface Designer, which allows anyone in an organization to build visual apps to cover off any number of projects. For a deeper dive into the backbone of the company’s design philosophy, consider the following tenets that help make Airtable a simple interface with infinite possibilities.  

Start with the familiar

“The gravitational pull of the business is to make it more complex and add more features,” says Ofstad. “We will do that; it’s a huge focus. But we have to make sure we aren’t doing that at the cost of product simplicity: the low floor and the high ceiling.” One important way Airtable does that is through design decisions that aren’t about creating novelty, but establishing something familiar and safe-feeling. Says Ofstad: “We start with a known concept and build a bridge from it.” When you first open Airtable, it feels an awful lot like a spreadsheet. That is purposeful and is meant to offer a soft start to new users who may otherwise feel burdened by too many options, or bells and whistles.“

Ramp up with progressive disclosure

As users make their way through Airtable’s offerings, says Ofstad, options progressively present themselves in a slow build; it is called guided onboarding. “You don’t learn Airtable in a day,” he says. “You learn over time. When most people start using Airtable, they don’t know what a database is. They know what a spreadsheet is. Terms like ‘fields’ and ‘records’ are confusing and don’t mean anything to most people. Learning needs to happen in stages.” This notion of progressive disclosure is meant to give new users an ‘aha moment’ almost immediately so they feel successful and in sync with what they’re doing. The total power of how Airtable works and what it is capable of is pretty much hidden at first. Users are only shown as much as they need to take a few first steps to get started. Then, says Ofstad, if you’re maybe entering calendar dates, there may be a prompt to try the calendar view. You could then click on a button for calendar view and the information will be displayed in that way, allowing you to stick with it or revert to your initial plan. This approach keeps novices (and even seasoned users as they progress toward that Millennium Falcon high ceiling) engaged and on track as they build out more and more from the software’s low floor.

Design for approachability

Design is embedded throughout the organization at Airtable. “It’s an all-inclusive, cross-functional way of thinking about design,” says Chad Thornton, head of design at Airtable. From color to form and function, Ofstad says, the design team has obsessed over the software’s look and feel from the start. Plus, every team at the company has the ability to communicate with customers to understand better what matters to them, what hiccups they’ve encountered and what really resonates. It informs the look and feel of the product, from supreme “clickability” to a “consumer-y” vibe that makes the experience of using Airtable fun and uncomplicated, whether that’s inside an organization’s marketing team or at home to plan a wedding or run a book club. Says Thornton: “When people use a B2B product in their personal lives it’s usually a pretty good sign that the design is inviting and simple.”

Nicole Gull McElroy

nicolegull@gmail.com

NEWS IN DESIGN

Designing community

Out April 19, Design for Belonging by Susie Wise lays out how leaders of all kinds can leverage design tools to cultivate a sense of belonging through physical space, rituals, events, roles, responsibilities and more. The book is meant to be a guide of sorts on how to address diversity, equity and inclusion, but above all the universal human need to feel a part of a community at work, home, school, and so many other places where we participate in life. Wise is a designer and teacher and founder and former director at the K12 Lab Network at Stanford d.school.

 

Software Innovation Lab in Asia

SAP Labs, the German software company, is pouring $250 million into a new innovation lab in Singapore. The project (which is focused on A.I., machine learning, digital supply chain, and cloud transformation) is reported to double the company’s engineering headcount in Singapore by 2025. This will be the company’s fifth lab in the Asia-Pacific and advance the business’ product roadmap.

 

MIT’s latest offering

Thanks to a $100 million gift, MIT will launch later this year its brand-new Morningside Academy for Design, enabling the university to house under one roof the design academy with the school of architecture. The gift comes from the philanthropic arm of the T.H. Chan family, The Morningside Foundation. Professor of architecture John Ochsendorf will serve as the founding director at the design center, while the work there will center on leveraging engineering, architecture, computer science, management, urban planning, and the arts to tackle global issues. The center will be seen as a hub for best practices across disciplines and will be available to everyone at MIT, positioning all students as designers whether they study music, engineering, art, business or architecture.

This is the web version of Business By Design, a biweekly newsletter exploring design’s transformative influence on industry and enterprise. Sign up to get it delivered free to your inbox.

About the Author
By Nicole Gull McElroy
See full bioRight Arrow Button Icon

Latest in Newsletters

Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025

Most Popular

Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Fortune Secondary Logo
Rankings
  • 100 Best Companies
  • Fortune 500
  • Global 500
  • Fortune 500 Europe
  • Most Powerful Women
  • Future 50
  • World’s Most Admired Companies
  • See All Rankings
Sections
  • Finance
  • Fortune Crypto
  • Features
  • Leadership
  • Health
  • Commentary
  • Success
  • Retail
  • Mpw
  • Tech
  • Lifestyle
  • CEO Initiative
  • Asia
  • Politics
  • Conferences
  • Europe
  • Newsletters
  • Personal Finance
  • Environment
  • Magazine
  • Education
Customer Support
  • Frequently Asked Questions
  • Customer Service Portal
  • Privacy Policy
  • Terms Of Use
  • Single Issues For Purchase
  • International Print
Commercial Services
  • Advertising
  • Fortune Brand Studio
  • Fortune Analytics
  • Fortune Conferences
  • Business Development
  • Group Subscriptions
About Us
  • About Us
  • Editorial Calendar
  • Press Center
  • Work At Fortune
  • Diversity And Inclusion
  • Terms And Conditions
  • Site Map
  • About Us
  • Editorial Calendar
  • Press Center
  • Work At Fortune
  • Diversity And Inclusion
  • Terms And Conditions
  • Site Map
  • Facebook icon
  • Twitter icon
  • LinkedIn icon
  • Instagram icon
  • Pinterest icon

Latest in Newsletters

woman typing on a computer.
NewslettersMPW Daily
The ‘AI gender gap’ narrative is missing the full picture
By Emma HinchliffeApril 9, 2026
7 hours ago
Even Nvidia’s own research teams can’t get enough GPUs amid the race for AI computing power
NewslettersEye on AI
Even Nvidia’s own research teams can’t get enough GPUs amid the race for AI computing power
By Sharon GoldmanApril 9, 2026
7 hours ago
Senior executive team together in conference meeting room in contemporary modern office bright sunny daylight sunset dusk talking discussing planning organizing strategy.
NewslettersCFO Daily
The white-collar jobs most exposed to AI, according to Anthropic’s own data
By Sheryl EstradaApril 9, 2026
11 hours ago
Bobby Healy stands in front of a Manna drone with his arms crossed.
NewslettersTerm Sheet
ARK Invest is betting on underdog drone delivery company Manna to beat out Alphabet and Zipline
By Lily Mae LazarusApril 9, 2026
12 hours ago
Why CEO Michelle Gass is thriving at Levi’s after stumbling at Kohl’s
NewslettersCEO Daily
Why CEO Michelle Gass is thriving at Levi’s after stumbling at Kohl’s
By Phil WahbaApril 9, 2026
13 hours ago
Meta chief AI officer Alexandr Wang in New Delhi on February 19, 2026. (Photo: Ludovic Marin/AFP/Getty Images)
NewslettersFortune Tech
Meta takes the wraps off Muse Spark
By Andrew NuscaApril 9, 2026
13 hours ago

Most Popular

The U.S. government is spending $88 billion a month in interest on national debt—equal to spending on defense and education combined
Economy
The U.S. government is spending $88 billion a month in interest on national debt—equal to spending on defense and education combined
By Fortune EditorsApril 9, 2026
12 hours ago
The U.S. had a national debt ‘home run’ in its grasp, says Jamie Dimon. But the government did nothing, and now its best option is crisis management
Economy
The U.S. had a national debt ‘home run’ in its grasp, says Jamie Dimon. But the government did nothing, and now its best option is crisis management
By Fortune EditorsApril 8, 2026
2 days ago
2 years ago, Saudi Arabia quietly canceled the ‘petrodollar’ deal with America that wired the world economy for 50 years. Then war broke out in Iran
Energy
2 years ago, Saudi Arabia quietly canceled the ‘petrodollar’ deal with America that wired the world economy for 50 years. Then war broke out in Iran
By Fortune EditorsApril 7, 2026
2 days ago
Self-made billionaire MrBeast says his work-life balance is nonexistent and calls it a ‘miracle’ if he works less than 15-hour days: ‘I live to work’
Success
Self-made billionaire MrBeast says his work-life balance is nonexistent and calls it a ‘miracle’ if he works less than 15-hour days: ‘I live to work’
By Fortune EditorsApril 8, 2026
1 day ago
Gen Z workers are so fearful AI will take their job they’re intentionally sabotaging their company’s AI rollout
AI
Gen Z workers are so fearful AI will take their job they’re intentionally sabotaging their company’s AI rollout
By Fortune EditorsApril 8, 2026
1 day ago
Gen Z doesn't want your full-time job. They want several part-time roles, and it's reshaping the entire workforce
Success
Gen Z doesn't want your full-time job. They want several part-time roles, and it's reshaping the entire workforce
By Fortune EditorsApril 9, 2026
16 hours ago

© 2026 Fortune Media IP Limited. All Rights Reserved. Use of this site constitutes acceptance of our Terms of Use and Privacy Policy | CA Notice at Collection and Privacy Notice | Do Not Sell/Share My Personal Information
FORTUNE is a trademark of Fortune Media IP Limited, registered in the U.S. and other countries. FORTUNE may receive compensation for some links to products and services on this website. Offers may be subject to change without notice.