topic Re: Summerize data within a repeat. Survey123 in ArcGIS Survey123 Questions

Summerize data within a repeat. Survey123

BrentKinal1 — Mon, 30 Jan 2017 21:07:45 GMT

Is there a way to pull all of the data from one field within a repeat to basically show a summary list. I have a form that is collecting A site name and Data outside of a repeat and the collecting a species name and some related info inside a repeat and I would like to show a running list of the species names collected I was thinking in a note field, just not sure how to call the values?

Re: Summerize data within a repeat. Survey123

JamesTedrick — Tue, 31 Jan 2017 19:09:02 GMT

Hi Brent,

We currently don't have functions that work across the values of a repeated field. When we do, what you're wanting will be available via a function called join()

Re: Summerize data within a repeat. Survey123

LynnBerni — Mon, 23 Jul 2018 23:33:18 GMT

Any chance this functionality has been added? I would like to add a note with a label that says "Transects entered thus far:", and a calculation that would simply list them separated by spaces.

E.g. Transects entered thus far: A B D E G J K

Fingers crossed.

Thanks,
Lynn

Re: Summerize data within a repeat. Survey123

IsmaelChivite — Tue, 24 Jul 2018 04:12:27 GMT

This may do the trick.

Re: Summerize data within a repeat. Survey123

LynnBerni — Wed, 25 Jul 2018 15:20:43 GMT

Hi Ismael,

That worked! This gives me a simple list (eg. ABCDE) which works just fine in this case since the transect ID's are a single letter. For future reference, is there a way to add other characters (spaces, commas, etc.) between the values to make the list more legible? If these were anything other than a single digit, this wouldn't really work.

Thanks!

Lynn

Re: Summerize data within a repeat. Survey123

FranciscoAndrade1 — Wed, 25 Jul 2018 16:42:31 GMT

Hi Ismael,

I agree with Lynn adding additional characters such as spaces, commas, text, etc. it will assist with displaying the data readable to the users viewing the data.

Is it possible to display images with the same method?

If we can display images using the same method, it will work great so we can display the images on a pop up from the primary table. The user viewing the data would not have look at the related tables to view the data.

Re: Summerize data within a repeat. Survey123

NicolasRoger — Thu, 20 Dec 2018 20:46:47 GMT

I succeeded in listing the answers of a repeat in a comma delemitated string.

Here is how to do it:

In the repeat, create a Calculate field named "repeatTxt". Set it's "bind::type" to:

string

Set it's calculation to:

${yourRepeatQuestionName} + ', '

Now create a new Calculate field outside the reapeat called "sumTxt".

Set it's "bind::type" to:

string

Set it's calculation to:

sum(${repeatTxt})

Now Create a Note field and place this in the Label property:

${sumTxt}

I hope this help.

EDIT:

You can even add conditional color formatting to the repeat calculation to highlights errors!

Re: Summerize data within a repeat. Survey123

DougBrowning — Tue, 12 Feb 2019 21:15:56 GMT

This does work for me. Thanks.

But why not use this function from the help? I tried it but it is not working. It only displays the value in the last repeat for some reason.

join(separator, question)
Concatenates all answers to a given question in a repeat, separated by the given separator.
join(',', ${question_in_repeat})

Re: Summerize data within a repeat. Survey123

NicolasRoger — Thu, 14 Feb 2019 21:09:55 GMT

As far as I know, Join is not implement in Survey123.

Re: Summerize data within a repeat. Survey123

DougBrowning — Thu, 14 Feb 2019 23:16:24 GMT

It actually is in there now I just need to go from Connect 3.0 to 3.2 and it worked great.

Re: Summerize data within a repeat. Survey123

TKSHEP — Mon, 24 Feb 2020 19:27:22 GMT

This worked great, however do you know if there is a way to get the repeat to show without the _ and use a , (comma)

example : last_first display as last,first

Thank you!

Re: Summerize data within a repeat. Survey123

JamesTedrick — Tue, 25 Feb 2020 19:43:53 GMT

Hi Trisha,

If you are asking to use another character in the join() function, that is quite possible. If you arresting to replace an underscore with a comma, that is possible through beta functionality (custom JavaScript functions); see the Early Adopter Community for more information

Re: Summerize data within a repeat. Survey123

StanislausNationalForest — Fri, 31 May 2024 17:45:14 GMT

Sorry to resurrect an old thread, but is there a way to sort the data in a join summary. Im hoping to generate a list of numerical animal ID's that is sorted for easier reference