Have a survey with a repeat. We'd like to calculate the position of each repeat so that becomes the ID. e.g.
Gives an outcome like
We can use the position(..) calculation to calculate the ID number within the repeat.
If a user collecting data deletes a repeat, we could use the Once(position(..)) calculation to prevent the ID from changing. However, a new repeat will potentially re-use the same position value. e.g. for the above scenario, if we remove the second repeat entry and entry a new one, the table will look like:
We can't re-calculate all the IDs as they are referenced in questions later on in the survey.
We want the re-entry to take the 4th position. So looking for ways we could resolve this e.g.
We get this on the regular. If they go back a few and delete all the counting is off as you said. We also have issues where they go back and change stuff.
No way around it really we just had to train our crews to not do that.
I would also love an answer to this (for a different reason though).
I'd just love for repeats to have a "recalculate" option and force their calculates to do their thing again. Adding calculationMode=always to a repeat would be neat (but I can see that bogging things down after a while).