Survey123 Export Specific Fields to Excel

620
4
09-10-2021 05:59 AM
Status: Open
Labels (2)
AlainChouinard
New Contributor III

In most of the surveys that we design there are several fields that are only used for calculations or conditions in the survey form. These fields are not useful for the user who wants to export the results of his survey in Excel with the Export tool from the Survey123 website, and can even be confusing. It would be nice if the exported fields were the same as the visible fields in the attribute table, which can be selected using the drop-down menu.

Thanks

Tags (3)
4 Comments
ReneAubut

Fully support!

DavidDallaire

Indeed, it would be nice to be able to filter the fields exported in Excel!

AlfredBaldenweck

If you're just using them for steps in the workflow, rather than final data, you can set body::esri:style to null.

This will have all your of your calculations work as intended, but when the survey is submitted, all the intermediate steps marked with null in their style won't show up, leaving only the data you care about.

 

Esri custom columns—ArcGIS Survey123 | Documentation

DougBrowning

In the webmap or webapp if you hide fields then export it will respect that.

If you export from ArcPro you can hide fields as well.  In Pro you can also use the Export to Excel tool and do things like name the field with the alias and export domain values.

Hope that helps.