How to track number of data entries to Survey123

[RachelS]

Hi,

I have about 50 Survey123 forms linked to Enterprise and Portal.

I have to report on the number of data entries to Survey123 a couple of times a year.

Does anyone know how I can do this without having to manually count them in each dataset?

I see Enterprise under Organisation > Status  has a Dashboard section, within which I can select the time period but I can only filter it down to the number of feature services, without it showing the number of records added within the time frame. There is also a Report option of items but again it doesn't give the number of records added.

Thanks

Rachel

[ZhifangWang]

Hi @RachelS ,

If your report is using PDF or Microsoft Word format, you can achieve this by printing a feature report. Assuming your feature layer name is layer1 and the object ID field is objectid, the syntax ${layer1 | stats:"count,objectid"} will output the record count in the input to the report from the layer. (${layer1 | where:"1=1 !important" | stats:"count,objectid"} will always output count of all records in the layer)

Some links may help:

• Understanding Survey123 Feature Reports
• Survey123 Tricks of the Trade (Live): Automate Reports
  
  • For example, send yourself a report via email every three months.
• Report template documentation

[DougBrowning]

A ArcGIS Dashboard would work well for this.  https://www.esri.com/en-us/arcgis/products/arcgis-dashboards/overview 

[Neal-Kittelson]

Why not create your own dashboard for this?

[RachelS]

Thanks for the suggestions.

I was thinking that going down the dashboard route would be the easiest, although it will be one indicator per dataset.

I'll look into the feature reports also.

[Neal-Kittelson]

You could use Arcade to aggregate fields from all your tables to one...