Showing a List from Data Collected in Survey123 Field App

dgagne

Hello,

I am creating a survey to collect data on trees in the Survey123 field app (data such as tree ID #, heights, species, diameters, etc.). This can be hundreds of trees, and after collecting all of this data, I want to figure out what are the largest diameter trees within the plot. Currently, we are having to look tree-by-tree and take notes on which trees have the largest diameters; I want to be able to look at a list of all of the trees at once rather than going through them one at a time- having them ranked by largest to smallest diameter would be even better!

 

Any ideas on how this can be done? I tried to calculate a field called TREE_SUMMARY with the formula being: concat('Tree',${TREE_NUMBER},'-',${TREE_SPECIES},'-',${TREE_DIAMETER},'cm-',${TREE_HEIGHT},'m'). This relates to the esri parameters I set for the group, which is: table-list;repeat-label=${TREE_SUMMARY}.

 

I'm still pretty new to Survey123, so if you have any suggestions on what I could do in the field to get a list of all the tree data after I'm done collecting it, I'd appreciate the advice. Going through trees one by one for hundreds of trees is not fun.

 

Thanks in advance

 

 

 

Neal_t_k

Thinking out loud here.  First how is the service where your field sites are? Are you wanting to look at just the sites you are collecting or are you thinking data from multiple people?  You mentioned a repeat, are you wanting to see the list based from the repeat section in one survey or across multiple repeats.

If you want a summary section within one survey, you are on the right track.  Make a field inside the repeat with your concat() with all the info you want to see.  Then outside the repeat in the main form use a join() to to aggregate all the concats from within the repeat. You can include <br> in the the join as your separator to have each entry on a separate line.  Make sure you null out the concat and join fields using bind::esri:fieldType: null so you don't over run the character limit.

Survey123 Tricks of the Trade: Repeats - Esri Community

If you wanted to look across multiple surveys you might be able to configure an instance name  and using the max() function be able to configure the instance name to be the largest tree from that survey.

Understanding the Instance_Name setting - Esri Community

If you do have service where you are at, you have more options, consider a Dashboard or Experience builder to look at the submitted data. Both have options to configure for mobile views on a browser.