I'm designing a form (advanced XLSForm in Survey123 Connect) where there will always be 10 repeats. A Value needs to be calcualted for each repeat. The first repeat, repeat1, uses formula1. The second, repeat2, uses formula2, etc through to repeat10 needing to use formula10.
As it stands, my mehtodology requires 10 different child tables, and I'd prefer it to be one for obvious reasons.
I am aware I could have the field guys simply manual select which repeat it is, but this seems inefficient and risks further human error.
Essentially, I want repeat1 to have a field with "1" in it, then for repeat2 to populate the same field with "2", through to 10. With my thought being I can use an external csv to ascertain and use the right formula.
