Create summary table from AGOL table

GISPro1 · ‎08-15-2022

Hello all!

We have convinced our customer to move away from Excel and Smartsheets into an ArcGIS Online environment. Woohoo!

We have created the dashboards that they need, but we can't seem to recreate a summary table like the one below. Any ideas?

Sample Tally Sheet

Katie_Clark · ‎08-15-2022

How is that data being collected? You could possibly use report templates in Survey123, or use webhooks to pull that information into a spreadsheet? (Integromat or PowerAutomate)

Best,
Katie

“The goal is not simply to ‘work hard, play hard.’ The goal is to make our work and our play indistinguishable.”
- Simon Sinek

GISPro1 · ‎08-15-2022

The information already exists in a hosted table in AGOL. I thought we could only create a Word Document template as a Survey123 report. How would I use webhooks to get that information into a spreadsheet? I'm looking for a no-code/low-code option. Thanks!