Airtable vs. Grist vs. Mode Analytics

Airtable is an ideal platform for small and growing businesses to keep track of just about EVERYTHING they need to keep things running smoothly. It's a great way to keep tasks organized, and keep everyone on the same page with progress on all things. Our company finds the kanban particularly useful, as products go through a lifecycle from ideation to retirement, it's good to keep a database of what is in production, what's working, and what we've tried before. I can see the platform being challenging with much larger businesses, but for the small to medium businesses I've used the platform with, it is ideal.

Incentivized

This is well suited to someone (or a team) who are technically minded and have a dataset that they need to be able to use in many ways. It's less appropriate for a team who isn't technically minded and/or don't have the data they need to manipulate. It would be useful for things that you could use a database or spreadsheet for such as CRM, Advertising database, Business tracking, Health tracking etc.

Incentivized

Mode is a clear category winner for how it easy it is to go from interactive analysis to professional quality reporting. You can easily do all your SQL and quite a bit of R/Python. If you want to quickly go from your database to simple charts, this is your pick. If you need to do heavier data modeling, scheduling jobs, or ML, you'll need something else, like Databricks. In my opinion, the quality of visualizations and some developer/analyst features make Databricks an unacceptable substitute.

Incentivized

• I can create tables, create and customize fields
• Airtable has capabilities commonly found in spreadsheet applications, but also has some of the features found in databases.
• The ability to filter fields. I set up a filter on the status field, so when a project is marked, complete, on hold, or canceled, that record is hidden from my current projects table view. If it is marked complete, the record is moved to the completed projects table view. In this way I can easily access a record of past projects
• Being able to duplicate tables and create alternate views
• Collapse and expand records. When I collapse the rows, I can easily scan current projects, next steps, project status, and due dates. When I expand the row, or field, I can see more detailed information about that field or record very easily. I can also expand or open the entire record. This is is helpful, when I am entering a lot of information to multiple fields in that record.

Incentivized

• Provides amazing customer service, help, examples, and explains what they are having you do
• The layout is easy

• It allows me to undertake data visualization tasks by creating really insightful charts and dashboards
• It allows for easy sharing and work collaboration on data analysis tasks
• Mode has an easier to use SQL editor as well
• I love how it organizes all our SQL data tables into easy-to-view data we can draw insights on

Incentivized

• When records are deleted, there could be more options for what happens to associated records in other tables.
• Multi-select fields should be sortable.
• The per-user pricing model can be cumbersome when you need to share bases with third parties but can't use a publicly accessible URL.

Incentivized

• Making the user permissions more obvious on how to use them - They are highly adaptable, but hard to understand how to use them
• Small changes such as auto colouring the choices/toggles options and being able to edit them once set.
• Being able to copy the formatting from one column to the next

Incentivized

• Date ranges aren't always the most intuitive to set, strangely
• Faster refresh rates would be ideal
• Would love more dynamic mobile device integration (alerts, etc)

Incentivized

We will 10/10 renew the use of Airtable because it has brought great value to our team. Not only is Airtable affordable, but it's also user-friendly and helps our team be efficient. We no longer need to rely on Excel spreadsheets being passed from person to person via email. Furthermore, we aren't dealing with corrupt Excel spreadsheets and the need to salvage data when a file is accidentally altered.

IMO the usability of this product is its greatest asset. The UI is clean and the menus are intuitive to the point where I'd feel confident having a non-spreadsheety colleague take on building an Airtable for the first time with next to no training. I can't say that about every table-like software product that I've used such as Notion.

Incentivized

For the advanced user already familiar with Python. It is just the same tool, already managed and connected to the data.

Incentivized

I have rarely experience downtime, compared to other tools, and given how much time we spend on the tool. Even if there were to be, their updates on it are very timely, and our support team are able to provide any questions regarding

Incentivized

I never had any issues with load time, even with the integrations that we use today (google sheets) However, I'm curious if adding additional layers of integrations would slow down performance. We do carry quite a bit of data in Airtable, but, again, no impact on overall performance

Incentivized

Airtable has great support. They have a variety of support features to answer any questions. They have great self teaching instructions for templates and product tours. They also have support for teams and project management. They also have a fantastic customer help line. They are able and willing to answer customer questions and never have customers waiting long

Incentivized

Mode has dedicated agents who are online in a chatroom, ready to take on any questions and provide helpful feedback.

Incentivized

This training was done in-house, but the Airtable team provided resources and how to guides to ensure that we covered all components of the system

Incentivized

Recorded trainings were provided by the Airtable team. Great as an evergreen resources to new team members and for anyone that wants to refresh their Airtable knowledge

Incentivized

Training all users was an important part of the implementation, which did take considerable time and effort. At first glance without training, the content calendar can be overwhelming because of the amount of data. The features within Airtable seem to be endless but our team was able to identify the most important to be successful.

Airtable was a really good fit for this specific use case as it provided a huge number of collaboration features in an intuitive and pleasant-to-use interface. The free tier worked initially with our work, and the upgrade pathway was fair and made sense for us.

Incentivized

Grist is easier to use, faster, and loads quicker with heavy data.

We used both Qlik and Mode at our organization. The mode was used a quick analysis SQL tool while Qlik was our enterprise BI solution.

Incentivized

I did not help purchase the product, but Airtable's per user pricing structure is inconvenient when some users only need occasional or read-only use.

Incentivized

There are TONS of opportunity to scale, but I think it's a matter if you have the time and resources to do so because the initial setup can be fairly time consuming and prioritized dedication

Incentivized

• It gives us a real-time experience of working.
• Through this platform, I always have the idea bout which of my team member is working on which particular part of the project, I can easily track their progress, and also I can easily correct them where it is required by adding sticky notes, by sending the attachments and URLs.
• Quality services.

Incentivized

• It's saved a lot of time in both creating an advertising database and managing it week to week effectively. I had previously created in others that haven't worked, and this does, saving me a good 1 hour weekly, and 5 hours or more each time I had problems with the last ones
• Being able to stay on track with this has meant I'm following up at the right time (advertisers) and keeping a professional manner and not losing business due to missed communication
• Saving me $ from buying a program like Access (or Airtable monthly) and then the learning curve that that has. This has a much easier learning curve to say the least.

Incentivized

• Extremely positive. It's a key feature in our application.
• Were it not for the account management bit, Mode would be hands-down our recommendation for anyone looking for cloud BI.

Incentivized