My form contains a repeat with a select_one question to identify the slope. The choice list is as follows:
| slope | <20% | Mostly Flat <20% |
| slope | 20-50% | Sloped 20-50 % |
| slope | > 20% | Steep >50% |
No matter what selection I've made, the database takes the value of the label, so I've tried making the select_one question null and created a another field that takes (using a calculation) the value selected in the select_one question. This works indeed, with the caveat that all the answers for this question is automatically changed for all the records in the repeat to the last value selected.
I don't think this makes sense, since every record withing the repeat should behave independently of the previous one.
Please advise if it might be due to some type of bug.