topic Re: Indexed-Repeat to pull previous pin spacing and resistence measurement in ArcGIS Survey123 Questions

Indexed-Repeat to pull previous pin spacing and resistence measurement

PrabhaVenu — Fri, 04 Mar 2022 22:30:20 GMT

I am using Survey123 desktop app version 3.13.251. For the attached survey form (excel sheet), I am unable to get indexed-repeat to work with this error:

I am using type "note" as mentioned in a previous solution for another similar question and i am following this exact code recommended but I still get this error and would like some help from this well-versed community. I am attaching my code as the excel sheet.

Re: Indexed-Repeat to pull previous pin spacing and resistence measurement

DougBrowning — Mon, 07 Mar 2022 16:06:45 GMT

You may need to bind the position field to int or just use position inside the indexed repeat and it way work.

Re: Indexed-Repeat to pull previous pin spacing and resistence measurement

PrabhaVenu — Mon, 07 Mar 2022 18:08:26 GMT

Hello Doug,

Thank you for your recommendations. I tried both the bind and directly using position inside the indexed-repeat, both didn't work. Not sure what i am missing..I am including both the survey form with the bind defined and the error message when I execute it.

Re: Indexed-Repeat to pull previous pin spacing and resistence measurement

DougBrowning — Mon, 07 Mar 2022 18:29:11 GMT

Are you outside the repeat?

The indexed-repeat() function cannot be used inside the repeat that it references, as this will cause a circular reference. For example, the following expression cannot be used for a calculation inside the repeat named defects:

indexed-repeat(${defect_type}, ${defects}, 3)

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformrepeats.htm

Re: Indexed-Repeat to pull previous pin spacing and resistence measurement

PrabhaVenu — Mon, 07 Mar 2022 18:40:36 GMT

Yes, I understand that constraint. Is there a way to get the previous value within this repeat loop? I really need to get this previous value inside this loop, since i am trying to calculate the resistivity for each sample point for a total of > 1 sample points. Basically resistivity at samples points 1, 5, 50 feet, etc respectively. And the formula references the previous sample point (feet and resistivity measured). I would like to do this without asking the person filling the form in the field to have to input the previous values.

Re: Indexed-Repeat to pull previous pin spacing and resistence measurement

DougBrowning — Mon, 07 Mar 2022 19:52:11 GMT

You may be able to out indexed outside then reference the field inside.

You can also maybe have the calc just outside the repeat so the user can still see it.

But if you just need the values at the 5s I would just have an if that does if mod 5 = 0 then store the number. Then add all of those up using sum. This may not be what you need but its an idea.

Re: Indexed-Repeat to pull previous pin spacing and resistence measurement

PrabhaVenu — Mon, 07 Mar 2022 20:01:32 GMT

Thanks for these suggestions, I will give them a try.