topic Re: Create summary table from AGOL table in ArcGIS Online Questions

Create summary table from AGOL table

GISPro1 — Mon, 15 Aug 2022 14:34:14 GMT

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

Re: Create summary table from AGOL table

Katie_Clark — Mon, 15 Aug 2022 14:36:51 GMT

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)

Re: Create summary table from AGOL table

GISPro1 — Mon, 15 Aug 2022 19:04:25 GMT

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!