Survey 123 many Repeats with the same field names but don't allow for calculations to work because multiple uses of the same field.

Question

Please see screenshot below, many repeats with the same fields not allowing for calculations to work. In the screenshot I used a JavaScript also tried an easier function with just the calculation but because repetitive use of the same fields the calculation it doesn't know which one to pick.

I know I can just make new fields but this is a client's so we can't just edit the dataset like that, because it would be inconsistent with their dataset from last year

DavidSolari · Accepted Answer

Survey123 will always fall apart if you have duplicate field names, even if those fields are ultimately mapped to disjoint tables. I like to add a small prefix to the fields in repeats (like "e_" for the equipment repeat) to avoid collisions I think that should work in your case as well.