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

[AudraPayne1]

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 solution]

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.