I have been learning a lot about ODK while trying to implement the form I am currently working on, but this problem has stumped me. I have a set of 8 questions, which are numbered v1 through v8. Following these questions, I have a question (var_ref) that asks users to select a number 1-8. Based on their response to var_ref, I want to reference the values stored in v1, v2, v3, etc.
I have attached a simple example form for the problem I am encountering. I think some form of calculation in num_ref is necessary. I tried things like calculate = ${v${var_ref}} but I suppose this kind of nesting of variable calls is not allowed. I wonder if I need to use concat or join here, but I am not sure. I am open to any ideas or suggestions you may have.
Thanks!
extract_test.xlsx (9.8 KB)