Automatic Looping of questions in a complex table

Support
1

Hi team,

I am developing a survey with complex tables for collecting household data
such as name, gender, age, responsibility and income for each and every
household member.

So for easy development i have broken the survey into simple questions are
one after the other. The 1st question is How many persons live in this
household?, then depending with the response, the system should loop the
number of times entered. For example if 5 is the number of people entered
to be living in a household, then the survey should automatically loop five
times each times allowing the interviewer to enter the name, age,
responsibility and income until information on all household members are
collected.

Any suggestion on how to set the automatic loop in xlsform.

Thanks.

Collins

2

Hi Collins,

Say the field name for the number of household members is "hhmembers". Add
a column to your survey worksheet with "repeat_count" in the header and
"${hhmembers}" in the cell for the appropriate "begin repeat" row. The
repeat group will repeat that number of times.

Looking quickly, I didn't see the documentation for this in either the ODK
XLSForm docs nor the formhub XLSForm docs. It is documented fully in
SurveyCTO, but it should also work in ODK and formhub. SurveyCTO also
includes a small library of sample forms, including four
carefully-described samples of household rosters.

Best,

Chris

··· On Sat, Oct 12, 2013 at 2:55 PM, Collins McAdoyo wrote:

Hi team,

I am developing a survey with complex tables for collecting household data
such as name, gender, age, responsibility and income for each and every
household member.

So for easy development i have broken the survey into simple questions are
one after the other. The 1st question is How many persons live in this
household?, then depending with the response, the system should loop the
number of times entered. For example if 5 is the number of people entered
to be living in a household, then the survey should automatically loop five
times each times allowing the interviewer to enter the name, age,
responsibility and income until information on all household members are
collected.

Any suggestion on how to set the automatic loop in xlsform.

Thanks.

Collins

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

3

thanks chris, its working

··· On Oct 13, 2013 12:14 AM, "Christopher Robert" wrote:

Hi Collins,

Say the field name for the number of household members is "hhmembers". Add
a column to your survey worksheet with "repeat_count" in the header and
"${hhmembers}" in the cell for the appropriate "begin repeat" row. The
repeat group will repeat that number of times.

Looking quickly, I didn't see the documentation for this in either the ODK
XLSForm docs nor the formhub XLSForm docs. It is documented fully in
SurveyCTO, but it should also work in ODK and formhub. SurveyCTO also
includes a small library of sample forms, including four
carefully-described samples of household rosters.

Best,

Chris

On Sat, Oct 12, 2013 at 2:55 PM, Collins McAdoyo collins.adoyo@gmail.comwrote:

Hi team,

I am developing a survey with complex tables for collecting household
data such as name, gender, age, responsibility and income for each and
every household member.

So for easy development i have broken the survey into simple questions
are one after the other. The 1st question is How many persons live in this
household?, then depending with the response, the system should loop the
number of times entered. For example if 5 is the number of people entered
to be living in a household, then the survey should automatically loop five
times each times allowing the interviewer to enter the name, age,
responsibility and income until information on all household members are
collected.

Any suggestion on how to set the automatic loop in xlsform.

Thanks.

Collins

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

4

Collins:

I am needing to do the same now for a household survey I'm building. I'm still very new to XLSForms/ODK.

Wondering if you wouldn't mind sharing the section of your spreadsheet related to the household data that would normally be in a table on a paper form.

All the best,

Adam

··· On Sunday, October 13, 2013 9:03:43 AM UTC+5:30, Collins McAdoyo wrote: > thanks chris, its working > > On Oct 13, 2013 12:14 AM, "Christopher Robert" wrote: > > > Hi Collins, > > > Say the field name for the number of household members is "hhmembers". Add a column to your survey worksheet with "repeat_count" in the header and "${hhmembers}" in the cell for the appropriate "begin repeat" row. The repeat group will repeat that number of times. > > > > > > Looking quickly, I didn't see the documentation for this in either the ODK XLSForm docs nor the formhub XLSForm docs. It is documented fully in SurveyCTO, but it should also work in ODK and formhub. SurveyCTO also includes a small library of sample forms, including four carefully-described samples of household rosters. > > > > > > Best, > > > Chris > > > > > > On Sat, Oct 12, 2013 at 2:55 PM, Collins McAdoyo wrote: > > > > > > > > > > Hi team, > > I am developing a survey > with complex tables for collecting household data such as name, gender, > age, responsibility and income for each and every household member. > > > So for easy development i have broken the survey into simple > questions are one after the other. The 1st question is How many persons > live in this household?, then depending with the response, the system > should loop the number of times entered. For example if 5 is the number > of people entered to be living in a household, then the survey should > automatically loop five times each times allowing the interviewer to > enter the name, age, responsibility and income until information on all > household members are collected. > > > Any suggestion on how to set the automatic loop in xlsform. > > Thanks. > > Collins > > > > > -- > > -- > > Post: opend...@googlegroups.com > > Unsubscribe: opendatakit...@googlegroups.com > > Options: http://groups.google.com/group/opendatakit?hl=en > > > > --- > > You received this message because you are subscribed to the Google Groups "ODK Community" group. > > To unsubscribe from this group and stop receiving emails from it, send an email to opendatakit...@googlegroups.com. > > For more options, visit https://groups.google.com/groups/opt_out. > > > > > > > > -- > > -- > > Post: opend...@googlegroups.com > > Unsubscribe: opendatakit...@googlegroups.com > > Options: http://groups.google.com/group/opendatakit?hl=en > > > > --- > > You received this message because you are subscribed to the Google Groups "ODK Community" group. > > To unsubscribe from this group and stop receiving emails from it, send an email to opendatakit...@googlegroups.com. > > For more options, visit https://groups.google.com/groups/opt_out.
5

Dear Adams,

Say the field name for the number of household members is "hh_no". Add a
column to your survey worksheet with "repeat_count" in the header and
"${hh_no}" in the cell for the appropriate "begin repeat" row. The repeat
group will repeat that number of times.

See the attached example.

Collins

example2.xls (210 KB)

··· On Tue, Jul 1, 2014 at 8:23 PM, wrote:

Collins:

I am needing to do the same now for a household survey I'm building. I'm
still very new to XLSForms/ODK.

Wondering if you wouldn't mind sharing the section of your spreadsheet
related to the household data that would normally be in a table on a paper
form.

All the best,

Adam

On Sunday, October 13, 2013 9:03:43 AM UTC+5:30, Collins McAdoyo wrote:

thanks chris, its working

On Oct 13, 2013 12:14 AM, "Christopher Robert" cro...@surveycto.com wrote:

Hi Collins,

Say the field name for the number of household members is "hhmembers".
Add a column to your survey worksheet with "repeat_count" in the header and
"${hhmembers}" in the cell for the appropriate "begin repeat" row. The
repeat group will repeat that number of times.

Looking quickly, I didn't see the documentation for this in either the
ODK XLSForm docs nor the formhub XLSForm docs. It is documented fully in
SurveyCTO, but it should also work in ODK and formhub. SurveyCTO also
includes a small library of sample forms, including four
carefully-described samples of household rosters.

Best,

Chris

On Sat, Oct 12, 2013 at 2:55 PM, Collins McAdoyo collin...@gmail.com wrote:

Hi team,

I am developing a survey
with complex tables for collecting household data such as name, gender,
age, responsibility and income for each and every household member.

So for easy development i have broken the survey into simple
questions are one after the other. The 1st question is How many persons
live in this household?, then depending with the response, the system
should loop the number of times entered. For example if 5 is the number
of people entered to be living in a household, then the survey should
automatically loop five times each times allowing the interviewer to
enter the name, age, responsibility and income until information on all
household members are collected.

Any suggestion on how to set the automatic loop in xlsform.

Thanks.

Collins

--

--

Post: opend...@googlegroups.com

Unsubscribe: opendatakit...@googlegroups.com

Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google
Groups "ODK Community" group.

To unsubscribe from this group and stop receiving emails from it, send
an email to opendatakit...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--

--

Post: opend...@googlegroups.com

Unsubscribe: opendatakit...@googlegroups.com

Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google
Groups "ODK Community" group.

To unsubscribe from this group and stop receiving emails from it, send
an email to opendatakit...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.