ODK xls form repeat problem

Support
1

I have created an ODK questionnaire using xlsform (i.e. creating it within
excel).

Within a repeat group I have an multiple select question 'QX'.

QX: what are your income sources:

  • crops
  • business
  • wage income
  • forest product

Each option from 'QX' enables a different 'repeat group' of questions about
that income source. i.e. the family might own several different businesses,
harvest several different crop types and have a couple of wage income jobs.

After selecting one option from QX and going through the repeat group x
number of times (e.g. selecting forest products and entering information
about each forest product) I can then add another income source (e.g. crops
...and go through that repeat group multiple times).

I have the following problem:

  1. I select an option e.g. forest products. I enter information about
    multiple forest prodducts.
  2. I select 'add another income option'
  3. I select a different income option e.g. crops

PROBLEM = the form produces another blank entry for 'forest products' as
well as for 'crops'

The xls form is set up such that in the 'relevant' column the relevant
repeat group only appears if that option is selected.

But i only want it to appear if it was selected in that specific repeat of
'add income product'.

Does this make sense? I have attached the relevant section of the survey to
this message.

I would really appreciate any help on this.

Thank you in advance

Becky

income_section.xls (178 KB)

2

Hi Becky,

There's probably a bug in your form (as opposed to a bug in ODK
Collect). I took a quick look but couldn't see anything obviously
wrong.

Best way for you to get help is for you to create a much smaller test
form with the one repeat and the four embedded repeats (each with one
or two questions). Remove all the constraints, hints, etc. Then see if
you can reproduce the problem in that smaller test form.

Yaw

··· -- Need ODK services? http://nafundi.com provides form design, server setup, professional support, and software development for ODK.

On Sun, Aug 10, 2014 at 1:32 AM, rlstedham@gmail.com wrote:

I have created an ODK questionnaire using xlsform (i.e. creating it within
excel).

Within a repeat group I have an multiple select question 'QX'.

QX: what are your income sources:

  • crops
  • business
  • wage income
  • forest product

Each option from 'QX' enables a different 'repeat group' of questions about
that income source. i.e. the family might own several different businesses,
harvest several different crop types and have a couple of wage income jobs.

After selecting one option from QX and going through the repeat group x
number of times (e.g. selecting forest products and entering information
about each forest product) I can then add another income source (e.g. crops
...and go through that repeat group multiple times).

I have the following problem:

  1. I select an option e.g. forest products. I enter information about
    multiple forest prodducts.
  2. I select 'add another income option'
  3. I select a different income option e.g. crops

PROBLEM = the form produces another blank entry for 'forest products' as
well as for 'crops'

The xls form is set up such that in the 'relevant' column the relevant
repeat group only appears if that option is selected.

But i only want it to appear if it was selected in that specific repeat of
'add income product'.

Does this make sense? I have attached the relevant section of the survey to
this message.

I would really appreciate any help on this.

Thank you in advance

Becky

--

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.

3

Yaw, thank you so much for your response and apologies for replying so late

  • I posted the problem the day or so before flying to mozambique and am
    camping in rural mozambique with limited internet. I did manage to solve
    the problem...and I will intend to write the solution on my own post when I
    have sufficient internet to do so!

Thank you again so much for your response - it is greatly apprecaiated!

Becky

··· On Sun, Aug 10, 2014 at 9:32 AM, wrote:

I have created an ODK questionnaire using xlsform (i.e. creating it within
excel).

Within a repeat group I have an multiple select question 'QX'.

QX: what are your income sources:

  • crops
  • business
  • wage income
  • forest product

Each option from 'QX' enables a different 'repeat group' of questions
about that income source. i.e. the family might own several different
businesses, harvest several different crop types and have a couple of wage
income jobs.

After selecting one option from QX and going through the repeat group x
number of times (e.g. selecting forest products and entering information
about each forest product) I can then add another income source (e.g. crops
...and go through that repeat group multiple times).

I have the following problem:

  1. I select an option e.g. forest products. I enter information about
    multiple forest prodducts.
  2. I select 'add another income option'
  3. I select a different income option e.g. crops

PROBLEM = the form produces another blank entry for 'forest products' as
well as for 'crops'

The xls form is set up such that in the 'relevant' column the relevant
repeat group only appears if that option is selected.

But i only want it to appear if it was selected in that specific repeat of
'add income product'.

Does this make sense? I have attached the relevant section of the survey
to this message.

I would really appreciate any help on this.

Thank you in advance

Becky

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/DcvvG36_0Hk/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

4

Yaw, thank you for your advice. I have created a sample test form to try
and debug the problem. I have attached it here.

If you try it you should have the same problem.

  • select option B in q1,
  • enter at least 2 repeats of repeat_B
  • press the '+' to repeat the option question 'repeat_A'
  • you will note that even if you select option 'C' or 'D' ...option 'B'
    also comes up - even though we dont want to repeat any more option Bs.

does this make sense? Some how I want to either:

  • reset the 'select_one_A' such that nothing is selected OR
  • specify that the optional repeat questions for B,C,D should only come up
    if their letter is selected in the current repeat cycle of repeat_A.

Again, any help would be greatly appreciated

Becky

debug.xls (25 KB)

··· On Sun, Aug 10, 2014 at 3:02 PM, Yaw Anokwa wrote:

Hi Becky,

There's probably a bug in your form (as opposed to a bug in ODK
Collect). I took a quick look but couldn't see anything obviously
wrong.

Best way for you to get help is for you to create a much smaller test
form with the one repeat and the four embedded repeats (each with one
or two questions). Remove all the constraints, hints, etc. Then see if
you can reproduce the problem in that smaller test form.

Yaw

Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.

On Sun, Aug 10, 2014 at 1:32 AM, rlstedham@gmail.com wrote:

I have created an ODK questionnaire using xlsform (i.e. creating it
within
excel).

Within a repeat group I have an multiple select question 'QX'.

QX: what are your income sources:

  • crops
  • business
  • wage income
  • forest product

Each option from 'QX' enables a different 'repeat group' of questions
about
that income source. i.e. the family might own several different
businesses,
harvest several different crop types and have a couple of wage income
jobs.

After selecting one option from QX and going through the repeat group x
number of times (e.g. selecting forest products and entering information
about each forest product) I can then add another income source (e.g.
crops
...and go through that repeat group multiple times).

I have the following problem:

  1. I select an option e.g. forest products. I enter information about
    multiple forest prodducts.
  2. I select 'add another income option'
  3. I select a different income option e.g. crops

PROBLEM = the form produces another blank entry for 'forest products' as
well as for 'crops'

The xls form is set up such that in the 'relevant' column the relevant
repeat group only appears if that option is selected.

But i only want it to appear if it was selected in that specific repeat
of
'add income product'.

Does this make sense? I have attached the relevant section of the survey
to
this message.

I would really appreciate any help on this.

Thank you in advance

Becky

--

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.

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/DcvvG36_0Hk/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

5

Hi Becky,
Could you share what was the problem and how it was corrected ? I am also
interested in Repeats since I intend to use ODK for household surveys and
would like to be aware of any potential problematic situations.

Vivek

··· On Wednesday, 20 August 2014 15:12:48 UTC+5:30, Rebecca Stedham wrote: > > Yaw, thank you so much for your response and apologies for replying so > late - I posted the problem the day or so before flying to mozambique and > am camping in rural mozambique with limited internet. I did manage to solve > the problem...and I will intend to write the solution on my own post when I > have sufficient internet to do so! > > Thank you again so much for your response - it is greatly apprecaiated! > > Becky > > > On Sun, Aug 10, 2014 at 9:32 AM, <rlst...@gmail.com > wrote: > >> I have created an ODK questionnaire using xlsform (i.e. creating it >> within excel). >> >> Within a repeat group I have an multiple select question 'QX'. >> >> QX: what are your income sources: >> - crops >> - business >> - wage income >> - forest product >> >> >> Each option from 'QX' enables a different 'repeat group' of questions >> about that income source. i.e. the family might own several different >> businesses, harvest several different crop types and have a couple of wage >> income jobs. >> >> After selecting one option from QX and going through the repeat group x >> number of times (e.g. selecting forest products and entering information >> about each forest product) I can then add another income source (e.g. crops >> ...and go through that repeat group multiple times). >> >> I have the following problem: >> >> 1. I select an option e.g. forest products. I enter information about >> multiple forest prodducts. >> 2. I select 'add another income option' >> 3. I select a different income option e.g. crops >> >> PROBLEM = the form produces another blank entry for 'forest products' as >> well as for 'crops' >> >> The xls form is set up such that in the 'relevant' column the relevant >> repeat group only appears if that option is selected. >> >> But i only want it to appear if it was selected in that specific repeat >> of 'add income product'. >> >> Does this make sense? I have attached the relevant section of the survey >> to this message. >> >> I would really appreciate any help on this. >> >> Thank you in advance >> >> Becky >> >> -- >> -- >> 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 a topic in the >> Google Groups "ODK Community" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/opendatakit/DcvvG36_0Hk/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> opendatakit...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > >
6

Becky,

I'm using ODK Collect 1.4.3 (1042) and I'm not seeing this problem.
After two B repeats, I can add an A repeat, then add multiple C
repeats.

What version of ODK Collect are you using? Also, how did you convert
your XLSForm (e.g., xlsform.opendatakit.org, formhub, ona)?

Yaw

··· On Mon, Aug 11, 2014 at 12:12 AM, Rebecca Stedham wrote: > Yaw, thank you for your advice. I have created a sample test form to try and > debug the problem. I have attached it here. > > If you try it you should have the same problem. > - select option B in q1, > - enter at least 2 repeats of repeat_B > - press the '+' to repeat the option question 'repeat_A' > - you will note that even if you select option 'C' or 'D' ...option 'B' also > comes up - even though we dont want to repeat any more option Bs. > > does this make sense? Some how I want to either: > - reset the 'select_one_A' such that nothing is selected OR > - specify that the optional repeat questions for B,C,D should only come up > if their letter is selected in the current repeat cycle of repeat_A. > > Again, any help would be greatly appreciated > > Becky > > > On Sun, Aug 10, 2014 at 3:02 PM, Yaw Anokwa wrote: >> >> Hi Becky, >> >> There's probably a bug in your form (as opposed to a bug in ODK >> Collect). I took a quick look but couldn't see anything obviously >> wrong. >> >> Best way for you to get help is for you to create a much smaller test >> form with the one repeat and the four embedded repeats (each with one >> or two questions). Remove all the constraints, hints, etc. Then see if >> you can reproduce the problem in that smaller test form. >> >> Yaw >> -- >> Need ODK services? http://nafundi.com provides form design, server >> setup, professional support, and software development for ODK. >> >> On Sun, Aug 10, 2014 at 1:32 AM, wrote: >> > I have created an ODK questionnaire using xlsform (i.e. creating it >> > within >> > excel). >> > >> > Within a repeat group I have an multiple select question 'QX'. >> > >> > QX: what are your income sources: >> > - crops >> > - business >> > - wage income >> > - forest product >> > >> > >> > Each option from 'QX' enables a different 'repeat group' of questions >> > about >> > that income source. i.e. the family might own several different >> > businesses, >> > harvest several different crop types and have a couple of wage income >> > jobs. >> > >> > After selecting one option from QX and going through the repeat group x >> > number of times (e.g. selecting forest products and entering information >> > about each forest product) I can then add another income source (e.g. >> > crops >> > ...and go through that repeat group multiple times). >> > >> > I have the following problem: >> > >> > 1. I select an option e.g. forest products. I enter information about >> > multiple forest prodducts. >> > 2. I select 'add another income option' >> > 3. I select a different income option e.g. crops >> > >> > PROBLEM = the form produces another blank entry for 'forest products' as >> > well as for 'crops' >> > >> > The xls form is set up such that in the 'relevant' column the relevant >> > repeat group only appears if that option is selected. >> > >> > But i only want it to appear if it was selected in that specific repeat >> > of >> > 'add income product'. >> > >> > Does this make sense? I have attached the relevant section of the survey >> > to >> > this message. >> > >> > I would really appreciate any help on this. >> > >> > Thank you in advance >> > >> > Becky >> > >> > -- >> > -- >> > 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. >> >> -- >> -- >> 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 a topic in the >> Google Groups "ODK Community" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/opendatakit/DcvvG36_0Hk/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> opendatakit+unsubscribe@googlegroups.com. >> >> For more options, visit https://groups.google.com/d/optout. > > > -- > -- > 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.