topic Re: Passing count value and multiple-select names from one Group to another in ArcGIS Survey123 Questions

Passing count value and multiple-select names from one Group to another

JulianHeilman — Fri, 28 May 2021 17:32:06 GMT

Is there a way to save the number of counts of two items chosen in a repeat of a select_one question in one group and pass both count values to another group?

I have a repeat to select each native species as a select_one choice (lavendary area in image).

For two of the species I would like to save the integer value (yellow rows in lavendar area), and pass those values to the yellow rows in the next group (the green area).

Eventually, I also would like to save the repeat decimal values below the yellow integer (counts) and pass them to another group similar to the action I am hoping to get help on in this post.

Thanks for any insight!

Julian Heilman

Re: Passing count value and multiple-select names from one Group to another

ZacharySutherby — Fri, 02 Jul 2021 15:38:53 GMT

Hello @JulianHeilman,

You can use an if statement with the selected() function in the repeat to check if a specific choice has been selected and return 1 if it was selected or return nothing if it wasn't selected. You can then use the count() function outside of the repeat to count the number of times 1 was returned from the choice calculation.

I've attached a sample XLSForm that demonstrates the workflow.

Here is another Esri Community thread that may also be helpful: https://community.esri.com/t5/arcgis-survey123-questions/survey123-count-filtered-by-selected-choice/m-p/862855