How to force a refresh calcs for a Nested Repeat

DougBrowning — Wed, 01 Apr 2020 16:00:48 GMT

I have a form with a repeat inside of a repeat. When I advance the outer repeat the inner repeat will not fire any calculations. Everything goes to blank.

I have tried using once and such but no.

First outer repeat

StationCount is calc of 1

StationNum is calc of once(count(${StationCount}))

Second outer repeat all the 1s are blank.

I then added a if to try and force it to calc. That works but then adds this Add 4 records box. But it only does that on every other outer repeat.

StationCount now if(${ThalwegTransect}='A',1,1)

On 2

On 3 the 4 thing goes away

On the 4th the box comes back again.

Ideas to fix this so it fires correctly all the time without the Add records thing?

Thanks

Re: How to force a refresh calcs for a Nested Repeat

JamesTedrick — Tue, 21 Apr 2020 23:23:02 GMT

Hi Doug,

Apologies for the delay. It looks like there may be something particular to your calculation set - can you provide the XLSForm for those rows? I've created a test calculation sheet and the calculations appear to perform as I would expect (attached).

topic Re: How to force a refresh calcs for a Nested Repeat in ArcGIS Survey123 Questions

How to force a refresh calcs for a Nested Repeat

Re: How to force a refresh calcs for a Nested Repeat