Hi,
Have a survey with a repeat. We'd like to calculate the position of each repeat so that becomes the ID. e.g.
repeat
ID
ID name
End repeat
Gives an outcome like
1 | Name 1 |
2 | Name 2 |
3 | Name 3 |
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:
1 | Name 1 |
3 | Name 3 |
3 | Name 4 |
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.
@DougBrowning @IsmaelChivite would really appreciate your eyes on this one 🙂
Cheers
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).