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; } } }

Hidden Fields in Repeats being reset when new repeat record added

KevinPiraino2

I am having an issue where hidden fields in a repeat are reset/recalculated when a new repeat record is added. The workflow I have consists of an end user submitting an initial record and then using a dashboard with an embedded survey to submit subsequent repeat records. The embedded survey is the same survey as the initial submission survey. The issue I am running into is that when an end user needs to add additional repeat records using the dashboard, the previously submitted repeat records values get overwritten with the "Calculate" field expression output. This issue does not occur though when the field type is set to "Integer" instead of "Hidden". When the field type is set to "Integer", the form respects the previously submitted repeat values and retains them when new repeat records are added. This issue also persists when the field type is set to "Calculate".

The issue I believe stems from needing to use the "coalesce" function to force a repeat record to calculate a "0" value instead of a blank string so as to properly sum all the repeat fields in the main record.

Attached you will find the XLSX spreadsheet containing my working survey.

Sheriff MERIT V3.xlsx

JamieConley_0-1720717819271.png

Find more posts tagged with

Accepted answers

dougbrowning

Not an answer but a workaround. You can set it to integer then use the hidden appearance or use the body::esri:visible column.

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-hidden-relevant-and/ba-p/1165842

Hope that helps

All comments

dougbrowning

Not an answer but a workaround. You can set it to integer then use the hidden appearance or use the body::esri:visible column.

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-hidden-relevant-and/ba-p/1165842

Hope that helps

KevinPiraino2

Doug,

Thank you for your assistance with this issue, it seems that the "body::esri:visible" column workaround works, but the appearance "hidden" workaround did not. The appearance "hidden" workaround functioned no differently than the field type "hidden" solution.

dougbrowning

Interesting. My only other idea is set the bind::type column to int. This binds inside the form vs bind::esri:fieldType is for submission. It could be 123 web is flipping it to string then back again quick.

KevinPiraino2

I tried this as well in my futile attempt to resolve the issue. Thankfully it seems that your workaround regarding the "body::esri:visible" column worked. As for the 123 web doing something funky, that was my first assumption since it seems that "editing" or adding additional repeats to an existing record is really only mentioned/suggested in the mobile app and not the desktop app.

KevinPiraino2

Since I believe my original issue stems from needing to use the coalesce function to force a zero value instead of an empty string. Is there a way to force this same procedure without using the coalesce function? To use the coalesce function I am having to use additional field to store the initial numeric value to compare against in the coalesce function or can I use the coalesce function in the calculate field of the the same question? (see attached spreadsheet for more clarity of the survey set-up/workflow).

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.