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!