nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Summarizing values of a repeat does not work in the web form

KimberlyMcCallum

Hi All,

I have a survey where the user may enter many records in a repeat. At the very end of the survey, prior to submission, I would like to include a summary note for the user to be able to quickly review some of their data without clicking back through the repeat. Do do this, I simply added a hidden field in the repeat where I concatenated the field I want to put in the summary with a comma and space for readability (concat(${uselocation_name}, ', ')). At the end, outside of the repeat, I added a summary calculation field (sum(${locationNameCalc})), where all the values are added together. This looks fine in Connect but when I publish the survey and test it, the summary note simply shows NaN. I have set the bind::esri:fieldType to null as I don't want to save this in my feature service.

Anyone have any insight into this?

Find more posts tagged with

Accepted answers

dougbrowning

Oh to join strings you want join(). sum is just for numbers that threw me off. (The apps let you cheat with + but not the web.)

This page is your new bible https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm

Hope that helps

All comments

dougbrowning

Oh to join strings you want join(). sum is just for numbers that threw me off. (The apps let you cheat with + but not the web.)

This page is your new bible https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm

Hope that helps

KimberlyMcCallum

Hi @DougBrowning ! Thank you for your speedy reply! The field that I want to include is a string and I was hoping to use the sum() function to concatenate across the repeat to create a nice text list. I tried setting the bind::type to string but that didn't work either. Any other thoughts? Thank you!

dougbrowning

You need to also set the bind::type field to a number (int or decimal depending on data). A calculation field does not know the type so you have to set it.

Hope that helps

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.