Automatic copying of Survey/Respondent Identification on Repeat questions when downloading

Dear Forum Experts,

I am programming a form for a household survey. There are about five sections with repeat questions: Crop Production, Crop Economics under Diesel and Solar Powered Irrigation Systems, Trainings received in the past 5 years and Livestock bought with Income from irrigation farming. Normally, when the data is collected, during downloading, repeat group questions are downloaded as separate sheets and cases/respondents are only identified in such downloaded data by a variable the Kobo automatically creates as Parent Index. Most of the times, analysis of survey data requires disaggregating by some variables, which are often in the survey Identification. Manually organising the downloaded repeat group data is tedious. Is there a way to programme the form so that Survey/respondent Identification get automatically copied on repeat group questions when downloading? Further, how do I programme the form so that number of choices per survey respondent gets counted? I have had this challenge for long and would like your help. I have attached my form
Comparison of Effectiveness of Solar Powered Irrigation and Motorised Irrigation Pumps Systems.xlsx (50.0 KB)

Hi @ctmukhala,

So if you don’t want to take this extra steps, what i can suggest you to add the variables inside the groups. So you you can add a measure inside the group and refer to the identification question, and by this method you will have the identification value inside your sheet. Please see the attached file, i highlighted the some example row.

Comparison of Effectiveness of Solar Powered Irrigation and Motorised Irrigation Pumps Systems.xlsx (50.7 KB)

1 Like

Many thanks Osman. However, I can’t see what you highlighted as an example. Would you mention the specific section of the repeat group question I mentioned?

Hello @ctmukhala, how are you?

To make Survey/Respondent Identification (like respondent ID, name, location, etc.) automatically appear in repeat group data, you can reference those variables within the repeat group itself. Just add a calculate question inside the repeat, and set its calculation to the variable from outside the group, like ${respondent_id}. This way, Kobo includes that info in the repeat sheet directly during download — no manual merging needed.

For counting choices per respondent, if you mean selecting multiple options in a select_multiple question, you can use a calculate question with the count-selected() function*.

1 Like

Hi @ctmukhala,you can check the line 20. Brian already explained it in narrative.

1 Like

Many thanks. I will try it. But what will it calculate, I see the calculate column blank?

Regards,

It will not calculate anything. It will just keep the same value in the mentioned questions, Let’s say you wrote Location of the HH’s in one question and you create a measure to reference this question inside a group. So when you download the survey, you will find the location of the HH in the relevant group. It will just repeat the same answer in the mentioned question, so you don’t have to merge them after you download the data.

Many thanks Osman. This is really what I have been looking for. I am so indebted to you and everyone who has come forward to assist me on this.

Regards