Merge duplicate repeats and sum values

Question

I am making a survey that has a repeat with a field to select a species from a select one and then enter the number observed.  Sometimes users may see and enter the same species multiple times on a survey. Is there a way to merge the individual repeat entries and sum up the number observed? Thanks

AJM · Answer

Thanks. I actually want to allow for duplicates, just combined them into one result that is reported somewhere.

dougbrowning · Answer

No but you can check for dups.  This gets asked a lot.

I do this for species list also.

See here  https://community.esri.com/t5/arcgis-survey123-questions/how-to-not-use-a-list-item-more-than-once/td-p/847735

and

https://community.esri.com/t5/arcgis-survey123-questions/counting-quot-unique-quot-selections-across-repeats/td-p/850887

Can also use javascript but it has important restrictions.

https://community.esri.com/t5/arcgis-survey123-questions/can-i-prevent-a-value-from-being-submitted-multiple-times-in-a/m-p/833949?commentID=932144&et=watches.email.thread#comment-932144

Hope that helps.