Airtable is a popular cloud-based spreadsheet and database service. It allows you to link tables to each other or third-party services and build various business applications without writing much code.
Airtable profile
Their headline claims that one can “build apps that connect everything.” Regardless of the data source, users can bring it into Airtable to organize, connect, and format it the way they want. The platform was founded in 2013 by Howie Liu, Andrew Ofstad, and Emmet Nicholas. At first, investors had no clue why they needed another spreadsheet service, considering Excel and Google Sheets were around. The founders, however, managed to convince them that Airtable provides a new approach to working with data.
Sure thing: Airtable can do the same things as spreadsheet processors like Excel, but the platform’s potential shines when working in conjunction with low-code platforms. The platform can be used to create both simple tables and large multi-linked databases or applications for business and management.
Working with Airtable tables is convenient owing to a streamlined workflow and useful features that most competitors don’t have. For instance, when you create a column, you must specify the name and type of the field. Unlike most spreadsheet processors, Airtable has a dedicated space for the field name.
Certainly, you can change tables the way you want. List items are highlighted in different colors, images in the Attachment field have thumbnails, and cell sizes are adjusted from “small” to “very large” in two clicks. However, Airtable is much more than tables. In the Views tab, you can create:
- Forms;
- Calendar;
- Gallery;
- Kanban board;
- Gantt charts.
The main features of Airtable are:
- About 30 built-in data types;
- Relationships between tables;
- Six ways to display data, including a Kanban board and forms;
- Embedded JavaScript scripts;
- API for interacting with other applications.
What’s inside
Airatable features are rich. For instance, you can add and store data in different forms - from standard (text, number, and dates) to additional ones, such as links, attachments, or dropdowns. It’s possible to:
- Establish relationships between tables and create a relational database;
- Customize the workspace and customize the expression of data using color schemes and icons, convenient customization of columns and rows of tables;
- Work using pre-defined templates. There are about a couple hundred of them.
- Connect extensions and scripts, making an interactive tool from a data table.
- Connect third-party services via API and make integrations with other tools, including no-code builders.
- Make a web application from a table with data.
- Import third-party application files into Airtable: CSV files from Excel, Trello, and others.
- Work with a remote team in a single workspace and streamline the collection and processing of information.
It’s possible to create tables from scratch or use ready-made templates. The library contains more than 60 standard solutions for business, marketing, education, routine tasks, and other areas. Plus, the marketplace offers more than 200 applications that extend the possibilities of spreadsheets to a great extent. For instance, you can visualize colorfully, summarize posts and directly integrate databases with third-party services using a page builder.
Pricing plans
Airtable offers four pricing plans. Let’s have a quick overview, shall we?
Free
For one person or small teams. 2 GB of attachments, 1200 entries in the database, one application, one integration, 5 authors and editors. There are no restrictions on the number of bases, comments and access to view. Great for learning how to use Airtable.
Plus
$10/month per person. It has everything in the free plan, plus 5.000 entries, 3 integrations, 3 apps, 5 GB of attachments, more customization options, six months of saving the history of changes.
Pro
$20/month per person. Everything in the free plan, plus 50.000 entries, 10 apps, 7 integrations, 20 GB, a year of revision history, and more personalization capabilities.
Enterprise
Ideal for big businesses, and there’s no fixed price for this plan. Available resources are doubled, plus, you have 3 years of change history, and personalized customer support.
Pros and cons
Below is the most interesting part for many of our readers - the Pros and Cons section. Without further ado, let’s dive straight into Airatable’s peculiarities.
Pros include:
- Working with data is easy. It’s possible to use tables with any type of data, formulas, and analytics;
- The ability to turn a table from an interactive workspace into a web application. Plus, you can connect tables with third-party services;
- Rich customization and management features;
- One can maintain a strict order of information. For example, a separate place is reserved for the column’s name - this is not available in many spreadsheet editors;
- Airtable has a clear and pleasant interface;
- Awesome data visualization features. Different data presentation options help you work more efficiently;
- Airtable is a powerful tool for working remotely;
- Lots of learning material and strong user community.
…and cons:
- Due to its multi-functionality, Airtable can be a bit difficult to master;
- It is impossible to fine-tune the access rights to the database, access to each participant is given immediately to the entire database, and this may be unsafe;
- The limit per database is only 50.000 rows. When many entities are created, it’s a bummer.
Verdict
Airtable is one of the main low-code tools for building separate tables and databases on top of them. You can get the most out of Airtable with code and a RESTful API. You'll find the official JavaScript API client and community versions in Ruby and .NET on GitHub.
Once you create a database, Airtable will generate an API that your applications or third-party services can use to create, update, delete records in tables, or get data. Entries in requests are packaged in JSON and sent over HTTP. You cannot send more than five requests per second to the API. If you exceed the limit, Airtable will send a message with the code 429, and you will have to wait up to 30 seconds before the next send.
All in all, mastering Airtable is both easy and difficult at the same time. On the one hand, due to the abundance of features, one may not know where to start. On the other hand, the interface is so intuitive that many functions are understandable at a subconscious level. If you still can’t figure it all out, there are lots of video tutorials and user tips on the Internet.
But enough with theory. What about some actual user reviews?
“If you’re familiar with JIRA settings, you would definitely come to the conclusion that any “issue tracker” or CRM is a table with records from the required fields, where the records go through a certain workflow. Each service developer rivets “their own tables” with their own fields, names the statuses of the workflow in their own way, hoping to guess your needs. But everyone has their own tasks, so one thing is suitable for someone, another for someone else.
Airtable goes the other way, it allows you to create your own solution for your needs, and it's as easy as a spreadsheet. Within one database, you can create different tables, link them, define statuses, labels, add files, pictures. Tables can have different views and filters. Data for any table can be collected in the form of a form. Up to the point that you can post a form on the site and collect applications directly in Airtable, then assign them to people, track progress. Everything is very simple and clear”. - Alex, Product Hunt.
“A good UI allows you to implement almost any business functionality. Task list, client list, applicant list and all activities around them. This is actually a database, only with a human interface”. - Gleb, Product Hunt.
Low-code platforms for you
All in all, Airtable is great. However, you might be interested in getting familiar with low-code builders you can use in conjunction. So far, we’ve covered:
Hire low-code experts
Nowadays, software development with little coding is synonymous with low code. The rise of no-code platforms is the biggest trend that allows citizen developers to create apps and launch MVPs. However, often you need a technological partner to make it work right.
Do you look for low code/no code development experts? With more than eight years of low-code development experience, we help businesses deliver powerful applications that cater to specific business needs. Our seasoned consultant team provides expert advice on low-code platforms for companies willing to innovate and helps to implement your low-code strategy from day one.
P.S. We often write about trends in low code. Subscribe to our blog to get the latest insights right in your inbox.
Lead Generation Tool to Reduce Manual Work
Our client, Afore Capital, a venture capital firm focused on pre-seed investments, aimed to automate their lead generation processes but struggled with existing out-of-the-box solutions. To tackle this challenge, they sought assistance from our team of Akveo Retool experts.
The scope of work
The client needed a tailored solution to log and track inbound deals effectively. They required an application that could facilitate the addition, viewing, and editing of company and founder information, ensuring data integrity and preventing duplicates. Additionally, Afore Capital aimed to integrate external tools like PhantomBuster and LinkedIn to streamline data collection.
The result
By developing a custom Retool application, we streamlined the lead generation process, significantly reducing manual data entry. The application enabled employees to manage inbound deals efficiently while automated workflows for email parsing, notifications, and dynamic reporting enhanced operational efficiency. This allowed Afore Capital's team to focus more on building relationships with potential founders rather than on administrative tasks.
Learn more about the case
Retool CMS Application for EdTech Startup
Our client, CutTime, a leading fine arts education management platform, needed a scalable CMS application to improve vendor product management and user experience.
The scope of work
We developed a Retool application that allows vendors to easily upload and manage product listings, handle inventory, and set shipping options. The challenge was to integrate the app with the client’s system, enabling smooth authentication and product management for program directors.
The result
Our solution streamlined product management, reducing manual work for vendors, and significantly improving operational efficiency.
Building Reconciliation Tool for e-commerce company
Our client was in need of streamlining and simplifying its monthly accounting reconciliation process – preferably automatically. But with a lack of time and low budget for a custom build, development of a comprehensive software wasn’t in the picture. After going through the case and customer’s needs, we decided to implement Retool. And that was the right choice.
The scope of work
Our team developed a custom reconciliation tool designed specifically for the needs of high-volume transaction environments. It automated the processes and provided a comprehensive dashboard for monitoring discrepancies and anomalies in real-time.
The implementation of Retool significantly reduced manual effort, as well as fostered a more efficient and time-saving reconciliation process.
Creating Retool Mobile App for a Wine Seller
A leading spirits and wine seller in Europe required the development of an internal mobile app for private client managers and administrators. The project was supposed to be done in 1,5 months. Considering urgency and the scope of work, our developers decided to use Retool for swift and effective development.
The scope of work
Our developers built a mobile application tailored to the needs of the company's sales force: with a comprehensive overview of client interactions, facilitated order processing, and enabled access to sales history and performance metrics. It was user-friendly, with real-time updates, seamlessly integrated with existing customer databases.
The result? Increase in productivity of the sales team and improved decision-making process. But most importantly, positive feedback from the customers themselves.
Developing PoC with Low Code for a Tour Operator
To efficiently gather, centralize, and manage data is a challenge for any tour operator. Our client was not an exception. The company was seeking to get an internal software that will source information from third-party APIs and automate the travel itinerary creation process. Preferably, cost- and user-friendly tool.
The scope of work
Our experts ensured the client that all the requirements could be covered by Retool. And just in 40 hours a new software was launched. The tool had a flexible and easy-to-use interface with user authentication and an access management system panel – all the company needed. At the end, Retool was considered the main tool to replace the existing system.
Testing New Generation of Lead Management Tool with Retool
Our client, a venture fund, had challenges with managing lead generation and client acquisition. As the company grew, it aimed to attract more clients and scale faster, as well as automate the processes to save time, improve efficiency and minimize human error. The idea was to craft an internal lead generation tool that will cover all the needs. We’ve agreed that Retool will be a perfect tool for this.
The scope of work
The project initially began as a proof of concept, but soon enough, with each new feature delivered, the company experienced increased engagement and value.
We developed a web tool that integrates seamlessly with Phantombuster for data extraction and LinkedIn for social outreach. Now, the company has a platform that elevates the efficiency of their lead generation activities and provides deep insights into potential client bases.
Building an Advanced Admin Portal for Streamlined Operations
Confronted with the need for more sophisticated internal tools, an owner of IP Licensing marketplace turned to Retool to utilize its administrative functions. The primary goal was to construct an advanced admin portal that could support complex, multi-layered processes efficiently.
The scope of work
Our client needed help with updating filters and tables for its internal platform. In just 30 hours we've been able to update and create about 6 pages. Following features were introduced: add complex filtering and search, delete records, styling application with custom CSS.
Together, we have increased performance on most heavy pages and fixed circular dependency issues.
Creating MVP Dashboard for Google Cloud Users
Facing the challenge of unoptimized cloud resource management, a technology firm working with Google Cloud users was looking for a solution to make its operations more efficient. The main idea of the project was to create an MVP for e-commerce shops to test some client hypotheses. Traditional cloud management tools fell short.
The scope of work
Determined to break through limitations, our team of developers turned Retool. We decided to craft an MVP Dashboard specifically for Google Cloud users. This wasn't just about bringing data into view; but about reshaping how teams interact with their cloud environment.
We designed a dashboard that turned complex cloud data into a clear, strategic asset thanks to comprehensive analytics, tailored metrics, and an intuitive interface, that Retool provides. As the results, an increase in operational efficiency, significant improvement in cost management and resource optimization.
Elevating CRM with Custom HubSpot Sales Dashboard
Our other client, a SaaS startup, that offers collaborative tools for design and engineering teams, was on a quest to supercharge their sales efforts. Traditional CRM systems were limited and not customizable enough. The company sought a solution that could tailor HubSpot to their workflow and analytics needs.
The scope of work
Charged with the task of going beyond standard CRM functions, our team turned to Retool. We wanted to redefine how sales teams interact with their CRM.
By integrating advanced analytics, custom metrics, and a user-friendly interface, our developers provided a solution that transformed data into a strategic asset.
In 40 hours, three informative dashboards were developed, containing the most sensitive data related to sales activities. These dashboards enable our customer to analyze sales and lead generation performance from a different perspective and establish the appropriate KPIs.
Building a PDF Editor with Low-Code
Our client, a leading digital credential IT startup, needed a lot of internal processes to be optimized. But the experience with low-code tools wasn’t sufficient. That’s why the company decided to hire professionals. And our team of developers joined the project.
The scope of work
The client has a program that designs and prints custom badges for customers. The badges need to be “mail-merged” with a person’s info and turned into a PDF to print. But what is the best way to do it?
Our developers decided to use Retool as a core tool. Using custom components and JavaScript, we developed a program that reduced employees' time for designing, putting the data, verifying, and printing PDF badges in one application.
As a result, the new approach significantly reduces the time required by the internal team to organize all the necessary staff for the conference, including badge creation.
