How to force a refresh calcs for a Nested Repeat

103
1
04-01-2020 09:00 AM
DougBrowning
MVP Notable Contributor

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

0 Kudos
1 Reply
JamesTedrick
Esri Esteemed Contributor

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).

0 Kudos