I'm creating a survey with ten collection points, and each collection point is a repeat.
I'm trying to collect the total bird species that are at each point AND then a total of species from all 10 points.
For the individual repeats, I am using
join(', ', ${species1}) |
For the total count, I am using:
join(', ', ${species1} + ${species2} + ${species3} + ${species4} + ${species5} + ${species6} + ${species7} + ${species8} + ${species9} + ${species10}) |
This pulls in every species, but if one species at each point, it will be listed ten times.
Is there a way to remove the duplicates and, if possible, add spaces between answers?
I've tried various attempts to play with the field string and bind options, but I am lost.
How about using sum function, you can find at following page: Formulas—ArcGIS Survey123 | Documentation
Cheers
Stefano