Airtable

We're looking for a better way to gather complex data from our members and provide visualisations in a PDF report or online dashboard. Currently, we use Stacker to collect data, Airtable to store it, and PowerBI Desktop to build reports.

The data we collect is greenhouse gas emissions data, including several years of utility data, vehicle consumption data, waste production, paper consumption, and so on. Hundreds of possible data points for each member with a large degree of variation and dependency within those data points. One member might have a fleet of a hundred vehicles, and we need to know the make/model/year/fuel type of each one, plus the actual fuel consumption, while another member doesn't have any fleet emissions, but produces a large amount of refrigerants, and so on.

Stacker does not give us the dynamic flexibility we need for this ingestion project. Airtable Interfaces could potentially get us there, but we're not sure if it is as sophisticated as we need it to be especially with all the conditionals. We haven't explored Jotform or Appscript or other options yet.

Thanks!

Node.js and ExpressJS is a good choice for backend, the stack makes it really easy to build a REST API.

I'm not exactly sure what you mean by using ExpressJS as an admin panel. Express is a lightweight backend framework for Node.js that lets you build your endpoints quickly and with minimal code. If you're looking for an admin panel to manage the data on your mobile app, check out BaseDash. It lets you view and edit data from your SQL database with the simplicity of Airtable.

If you're a developer using Google Docs or Google Sheets... just stop. There are much better alternatives these days that provide a better user and developer experience.

At FeaturePeek, we use Slite for our internal documents and knowledge tracking. Slite's look and feel is similar to Slack's, so if you use Slack, you'll feel right at home. Slite is great for keeping tabs on meeting notes, internal documentation, drafting marketing content, writing pitches... any long-form text writing that we do as a company happens in Slite. I'm able to be up-to-date with everyone on my team by viewing our team activity. I feel more organized using Slite as opposed to GDocs or GDrive.

Airtable is also absolutely killer – you'll never want to use Google Sheets again. Have you noticed that with most spreadsheet apps, if you have a tall or wide cell, your screen jumps all over the place when you scroll? With Airtable, you can scroll by screen pixels instead of by spreadsheet cells – this makes a huge difference! It's one of those things that you don't really notice at first, but once you do, you can't go back. This is just one example of the UX improvements that Airtable has to the previous generation of spreadsheet apps – there are plenty more.

Also, their API is a breeze to use. If you're logged in, the docs fill in values from your tables and account, so it feels personalized to you.

Rich feature set. Enjoyable UX design. Good integrations with several other tools we use. Airtable

Simple tracking tool for which customers (CBO's) and districts are on board with the system. Airtable