topic Counting repeat select_multiple answers in ArcGIS Survey123 Questions

Counting repeat select_multiple answers

NedMay — Tue, 02 Jun 2020 06:42:19 GMT

Hello,

I am trying to set up a species list for our botany team in Survey123 using an xlsform. I have set up a searchable species list and then a select-multiple list of lifeform types. The botanist will select a species, and then one, multiple or no lifeform. I want to be able to add how many times each lifeform was selected.

For example: botanist chooses a species - xx

Then chooses a lifeform - LS and SS

Then chooses another species - xx

And chooses a lifeform - PG

Display - LS used 1, SS used 1, PG used 1, etc.

For each of the select-multiple options, I want to be able to sum the number of times it was selected. It currently works if only selecting one lifeform per species but fails with more.

Thank you!!

Re: Counting multiple select answers across repeats

DougBrowning — Tue, 02 Jun 2020 13:57:27 GMT

Is your sum() outside of the repeat?

Re: Counting multiple select answers across repeats

NedMay — Wed, 03 Jun 2020 02:35:14 GMT

I've updated the response with the survey, the sum is outside the repeats and seems to work with only one lifeform selected. I think the if(${lifeform} = 'XX', 1, 0) does not work with select_multiple?

Re: Counting repeat select_multiple answers

DougBrowning — Wed, 03 Jun 2020 13:20:47 GMT

With select multiple you have to use jr:choice-name(choice, 'question'). If you have species1;species2 then = will not be true. See the formulas page for more info Formulas—Survey123 for ArcGIS | Documentation

For my forms when doing a species list I use a repeat. Much better database structure to have one species per record vs a ; separated list. Hard to do analysis on that. Our legacy program does this and we ended up separating them out. It also allows me to check for dups, and have unknown codes all built in. I have posted this before if you need it.

Hope that helps

Re: Counting repeat select_multiple answers

Emily1 — Mon, 10 Jan 2022 20:55:05 GMT

I have a related question. I have a survey that requires the user to list off all species present and give the cover for each. That's all in a repeat. I would like to show the user what species were selected in the set of repeats, but can I generate a list of species names outside the repeat that shows the label, not the name? My species list has a code for the name and the label spells out the Genus/species and I'd like to show the label, preferably with spaces between names so the user can check that they have entered data for every species present.