Indexed repeat

Hi community?
I have a set of grouped question which starts by listing all household
members their gender and age.

I now want to pull all children below 8 years from household list. There
are several questions that will be asked for children below 8. All the
questions in that group will be asked for each child that falls in age
category.

Any assistance is highly appreciated.

Thank you in advance.

Regards,
Louis...

This is difficult to program.

The "Biggest N of Set" form ( https://opendatakit.appspot.com ) may be
useful (the XLS file is provided as a media attachment).

And you'll want to see

https://opendatakit.org/help/form-design/#xpath_expressions

Also search the group for earlier answers to questions using these features.

ยทยทยท On Thu, Jun 2, 2016 at 8:00 AM, Louis Omoya wrote:

Hi community?
I have a set of grouped question which starts by listing all household
members their gender and age.

I now want to pull all children below 8 years from household list. There
are several questions that will be asked for children below 8. All the
questions in that group will be asked for each child that falls in age
category.

Any assistance is highly appreciated.

Thank you in advance.

Regards,
Louis...

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

Thanks. I will check this out

ยทยทยท On Mon, Jun 6, 2016 at 11:19 PM, Mitch Sundt wrote:

This is difficult to program.

The "Biggest N of Set" form ( https://opendatakit.appspot.com ) may be
useful (the XLS file is provided as a media attachment).

And you'll want to see

https://opendatakit.org/help/form-design/#xpath_expressions

Also search the group for earlier answers to questions using these
features.

On Thu, Jun 2, 2016 at 8:00 AM, Louis Omoya louisomoya@gmail.com wrote:

Hi community?
I have a set of grouped question which starts by listing all household
members their gender and age.

I now want to pull all children below 8 years from household list. There
are several questions that will be asked for children below 8. All the
questions in that group will be asked for each child that falls in age
category.

Any assistance is highly appreciated.

Thank you in advance.

Regards,
Louis...

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

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.

1 Like

Hi Louis,
I got an idea. You need to 3 things to add in xlsform:

  1. In the first repeat (first group of questions adking all members), lets name it ${repeat1}, create a calculation to mark all member under 8 using if condition. Ex, type = calculate, name = marker, calculation = if(${age} < 8, 1, 0)
  2. In the 2nd repeat (2nd group of questions asking members under 8), pull the mark value from the 1st repeat using indexed-repeat. Ex, type = calculate, name = marker2, calculation = indexed-repeat(${marker},${repeat1},position(..)-1)
  3. Put relevance for the questions asking members under 8. Ex, in relevant column, type ${marker2} = 1. So, only members under 8 will answer them.
    If you still got issue or want to know more, I can be reached at Skype live:dhbangtroi
    Thien Dao

I like the creativity. I will try this and let you know the outcome.

Thanks.

ยทยทยท On 12 Jun 2016 00:24, wrote:

Hi Louis,
I got an idea. You need to 3 things to add in xlsform:

  1. In the first repeat (first group of questions adking all members), lets
    name it ${repeat1}, create a calculation to mark all member under 8 using
    if condition. Ex, type = calculate, name = marker, calculation = if(${age}
    < 8, 1, 0)
  2. In the 2nd repeat (2nd group of questions asking members under 8), pull
    the mark value from the 1st repeat using indexed-repeat. Ex, type =
    calculate, name = marker2, calculation =
    indexed-repeat(${marker},${repeat1},position(..)-1)
  3. Put relevance for the questions asking members under 8. Ex, in relevant
    column, type ${marker2} = 1. So, only members under 8 will answer them.
    If you still got issue or want to know more, I can be reached at Skype
    live:dhbangtroi
    Thien Dao

--

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.