Display data from repeat in XLS form

Support
1

Hello,

Can anyone help me trying to display a variable's value at a particular index for a repeat, in label of some question like so:

label

Household Member Name 1: indexed-repeat(${hh_mem_name}, ${b}, 1)
Household Member Name 2: indexed-repeat(${hh_mem_name}, ${b}, 2)

And so on, in XLS form.

Thank you!

Regards,
Ayub

2

Hi @Ayub

Please take a look at this example: repeat.xlsx (5.6 KB)

3

Thank you, it works!

Is there a way to display indexed-repeat values directly in Labels without the need for creating new variables / columns?

4

Do you mean without those two calculate rows?

5

Yes, would that be possible in ODK?

6

It must be in the calculation column. Why it's a problem for you?

7

Actually I would have to display name, age, gender, marital status of 30 household members, so it would be great if we could do it directly.

8

I don't think it's possible indexed-repeat must be calculated.

9

That's going to take a while to work with, but thanks for all the help!