My survey includes a repeat group to capture information about each
household member one by one. E.g. We start with household member #1 (Suzy),
and ask them a series of questions. Then we add a group member on the PDA,
pick household member #2 (Andy) and ask them the same series of questions.
Continue for all household members.
Later in the same survey (not part of the above repeat group), we ask about
household chores and who is in charge.
Question:
Is it possible in XLSform (and if so, how) to include in this chores
section a question that allows the respondent to choose the name of a
household member from a list composed of the names given in answers in the
original household member repeat group?
E.g. Who is in charge of gardening (Select all that apply)
Following the thread, would love to have a solution for it.
···
On Saturday, October 24, 2015 at 1:02:30 AM UTC+6, pamj...@gmail.com wrote:
> Dear all,
>
>
>
>
> Backgroung:
>
> My survey includes a repeat group to capture information about each household member one by one. E.g. We start with household member #1 (Suzy), and ask them a series of questions. Then we add a group member on the PDA, pick household member #2 (Andy) and ask them the same series of questions. Continue for all household members.
>
>
>
>
> Later in the same survey (not part of the above repeat group), we ask about household chores and who is in charge.
>
>
>
>
> Question:
>
> Is it possible in XLSform (and if so, how) to include in this chores section a question that allows the respondent to choose the name of a household member from a list composed of the names given in answers in the original household member repeat group?
>
> E.g. Who is in charge of gardening (Select all that apply)
> Suzy
> Andy
> Lisa
> Chuck
> Thanks,
>
>
> Pamela.
This is kinda tricky, and I'm not sure it would work, but the idea
is to pull out the individual names from the
indexed_repeat and use them in individual yes/no questions.
So there'd be a field-list group with a note question that says "who
is in charge of gardening?". Then I'd have a series of select on
yes/no questions (1-n) that are relevant if indexed_repeat(n) is not
blank. These questions would use the value of the indexed_repeat
(e.g., the name) as the question text.
Haven't done this myself, but that's the idea. Maybe someone can build
a test form and see if it works?
Yaw
···
--
Need ODK consultants? https://nafundi.com provides form design, server
setup, in-field training, and software development for ODK.
Following the thread, would love to have a solution for it.
On Saturday, October 24, 2015 at 1:02:30 AM UTC+6, pamj...@gmail.com wrote:
Dear all,
Backgroung:
My survey includes a repeat group to capture information about each household member one by one. E.g. We start with household member #1 (Suzy), and ask them a series of questions. Then we add a group member on the PDA, pick household member #2 (Andy) and ask them the same series of questions. Continue for all household members.
Later in the same survey (not part of the above repeat group), we ask about household chores and who is in charge.
Question:
Is it possible in XLSform (and if so, how) to include in this chores section a question that allows the respondent to choose the name of a household member from a list composed of the names given in answers in the original household member repeat group?
E.g. Who is in charge of gardening (Select all that apply)
Suzy
Andy
Lisa
Chuck
Thanks,
See attached, I created a example form based on Yaw's input and I believe
this accomplishes what you are looking to do. You would most likely want to
increase the number of household members allowable to more than 12 though
(depending on where you are conducting the survey).
···
On Monday, October 26, 2015 at 12:42:44 AM UTC-4, Yaw Anokwa wrote:
>
> Pamela,
>
> This is kinda tricky, and I'm not sure it would work, but the idea
> is to pull out the individual names from the
> indexed_repeat and use them in individual yes/no questions.
>
> So there'd be a field-list group with a note question that says "who
> is in charge of gardening?". Then I'd have a series of select on
> yes/no questions (1-n) that are relevant if indexed_repeat(n) is not
> blank. These questions would use the value of the indexed_repeat
> (e.g., the name) as the question text.
>
> Haven't done this myself, but that's the idea. Maybe someone can build
> a test form and see if it works?
>
> Yaw
> --
> Need ODK consultants? https://nafundi.com provides form design, server
> setup, in-field training, and software development for ODK.
>
> On Sun, Oct 25, 2015 at 12:58 PM, <rush...@gmail.com > wrote:
> > Following the thread, would love to have a solution for it.
> >
> > On Saturday, October 24, 2015 at 1:02:30 AM UTC+6, pamj...@gmail.com wrote:
> >> Dear all,
> >>
> >>
> >>
> >>
> >> Backgroung:
> >>
> >> My survey includes a repeat group to capture information about each
> household member one by one. E.g. We start with household member #1 (Suzy),
> and ask them a series of questions. Then we add a group member on the PDA,
> pick household member #2 (Andy) and ask them the same series of questions.
> Continue for all household members.
> >>
> >>
> >>
> >>
> >> Later in the same survey (not part of the above repeat group), we ask
> about household chores and who is in charge.
> >>
> >>
> >>
> >>
> >> Question:
> >>
> >> Is it possible in XLSform (and if so, how) to include in this chores
> section a question that allows the respondent to choose the name of a
> household member from a list composed of the names given in answers in the
> original household member repeat group?
> >>
> >> E.g. Who is in charge of gardening (Select all that apply)
> >> Suzy
> >> Andy
> >> Lisa
> >> Chuck
> >> Thanks,
> >>
> >>
> >> Pamela.
> >
> > --
> > --
> > 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/d/optout.
>
See attached, I created a example form based on Yaw's input and I believe
this accomplishes what you are looking to do. You would most likely want to
increase the number of household members allowable to more than 12 though
(depending on where you are conducting the survey).
~lb
On Monday, October 26, 2015 at 12:42:44 AM UTC-4, Yaw Anokwa wrote:
Pamela,
This is kinda tricky, and I'm not sure it would work, but the idea
is to pull out the individual names from the
indexed_repeat and use them in individual yes/no questions.
So there'd be a field-list group with a note question that says "who
is in charge of gardening?". Then I'd have a series of select on
yes/no questions (1-n) that are relevant if indexed_repeat(n) is not
blank. These questions would use the value of the indexed_repeat
(e.g., the name) as the question text.
Haven't done this myself, but that's the idea. Maybe someone can build
a test form and see if it works?
Yaw
Need ODK consultants? https://nafundi.com provides form design, server
setup, in-field training, and software development for ODK.
Following the thread, would love to have a solution for it.
On Saturday, October 24, 2015 at 1:02:30 AM UTC+6, pamj...@gmail.com wrote:
Dear all,
Backgroung:
My survey includes a repeat group to capture information about each
household member one by one. E.g. We start with household member #1 (Suzy),
and ask them a series of questions. Then we add a group member on the PDA,
pick household member #2 (Andy) and ask them the same series of questions.
Continue for all household members.
Later in the same survey (not part of the above repeat group), we ask
about household chores and who is in charge.
Question:
Is it possible in XLSform (and if so, how) to include in this chores
section a question that allows the respondent to choose the name of a
household member from a list composed of the names given in answers in the
original household member repeat group?
E.g. Who is in charge of gardening (Select all that apply)
Suzy
Andy
Lisa
Chuck
Thanks,
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/d/optout.
A final question, if possible, how can I restrict that only one member is
the one in charge of gardening? Now all of them could take the value 'yes',
or 'no'. I would like to program, that only one member can be 'yes', and
all the rest 'no'
Thanks so much,
Pam
···
On Monday, October 26, 2015 at 2:52:51 PM UTC, Yaw Anokwa wrote:
>
> Awesome! Thanks for doing this Lloyd!
>
> Yaw
> --
> Need ODK consultants? https://nafundi.com provides form design, server
> setup, in-field training, and software development for ODK.
>
> On Mon, Oct 26, 2015 at 9:46 PM, Lloyd Owen Banwart <lloyd....@gmail.com > wrote:
> > Hi Pam,
> >
> > See attached, I created a example form based on Yaw's input and I
> believe
> > this accomplishes what you are looking to do. You would most likely want
> to
> > increase the number of household members allowable to more than 12
> though
> > (depending on where you are conducting the survey).
> >
> > ~lb
> >
> > On Monday, October 26, 2015 at 12:42:44 AM UTC-4, Yaw Anokwa wrote:
> >>
> >> Pamela,
> >>
> >> This is kinda tricky, and I'm not sure it would work, but the idea
> >> is to pull out the individual names from the
> >> indexed_repeat and use them in individual yes/no questions.
> >>
> >> So there'd be a field-list group with a note question that says "who
> >> is in charge of gardening?". Then I'd have a series of select on
> >> yes/no questions (1-n) that are relevant if indexed_repeat(n) is not
> >> blank. These questions would use the value of the indexed_repeat
> >> (e.g., the name) as the question text.
> >>
> >> Haven't done this myself, but that's the idea. Maybe someone can build
> >> a test form and see if it works?
> >>
> >> Yaw
> >> --
> >> Need ODK consultants? https://nafundi.com provides form design, server
> >> setup, in-field training, and software development for ODK.
> >>
> >> On Sun, Oct 25, 2015 at 12:58 PM, wrote:
> >> > Following the thread, would love to have a solution for it.
> >> >
> >> > On Saturday, October 24, 2015 at 1:02:30 AM UTC+6, pamj...@gmail.com wrote:
> >> >> Dear all,
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> Backgroung:
> >> >>
> >> >> My survey includes a repeat group to capture information about each
> >> >> household member one by one. E.g. We start with household member #1
> (Suzy),
> >> >> and ask them a series of questions. Then we add a group member on
> the PDA,
> >> >> pick household member #2 (Andy) and ask them the same series of
> questions.
> >> >> Continue for all household members.
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> Later in the same survey (not part of the above repeat group), we
> ask
> >> >> about household chores and who is in charge.
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> Question:
> >> >>
> >> >> Is it possible in XLSform (and if so, how) to include in this chores
> >> >> section a question that allows the respondent to choose the name of
> a
> >> >> household member from a list composed of the names given in answers
> in the
> >> >> original household member repeat group?
> >> >>
> >> >> E.g. Who is in charge of gardening (Select all that apply)
> >> >> Suzy
> >> >> Andy
> >> >> Lisa
> >> >> Chuck
> >> >> Thanks,
> >> >>
> >> >>
> >> >> Pamela.
> >> >
> >> > --
> >> > --
> >> > 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/d/optout.
> >
> > --
> > --
> > 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/d/optout.
>
There is probably a more direct way of doing this with constraints on the
name questions using "if" statements -- but I couldn't think of it off the
top of my head. The path of least resistance that popped into my head is to
set up a calculate and note field in a following prompt. The calculate
function is long because you have to take into account null values
(variables with no value associated with them). See attached.
···
On Tuesday, October 27, 2015 at 11:29:24 AM UTC-4, pamj...@gmail.com wrote:
>
> Dear Yaw and Lloyd,
>
> Thanks a lot for this! It works perfectly.
>
> A final question, if possible, how can I restrict that only one member is
> the one in charge of gardening? Now all of them could take the value 'yes',
> or 'no'. I would like to program, that only one member can be 'yes', and
> all the rest 'no'
>
> Thanks so much,
>
> Pam
>
> On Monday, October 26, 2015 at 2:52:51 PM UTC, Yaw Anokwa wrote:
>>
>> Awesome! Thanks for doing this Lloyd!
>>
>> Yaw
>> --
>> Need ODK consultants? https://nafundi.com provides form design, server
>> setup, in-field training, and software development for ODK.
>>
>> On Mon, Oct 26, 2015 at 9:46 PM, Lloyd Owen Banwart wrote:
>> > Hi Pam,
>> >
>> > See attached, I created a example form based on Yaw's input and I
>> believe
>> > this accomplishes what you are looking to do. You would most likely
>> want to
>> > increase the number of household members allowable to more than 12
>> though
>> > (depending on where you are conducting the survey).
>> >
>> > ~lb
>> >
>> > On Monday, October 26, 2015 at 12:42:44 AM UTC-4, Yaw Anokwa wrote:
>> >>
>> >> Pamela,
>> >>
>> >> This is kinda tricky, and I'm not sure it would work, but the idea
>> >> is to pull out the individual names from the
>> >> indexed_repeat and use them in individual yes/no questions.
>> >>
>> >> So there'd be a field-list group with a note question that says "who
>> >> is in charge of gardening?". Then I'd have a series of select on
>> >> yes/no questions (1-n) that are relevant if indexed_repeat(n) is not
>> >> blank. These questions would use the value of the indexed_repeat
>> >> (e.g., the name) as the question text.
>> >>
>> >> Haven't done this myself, but that's the idea. Maybe someone can build
>> >> a test form and see if it works?
>> >>
>> >> Yaw
>> >> --
>> >> Need ODK consultants? https://nafundi.com provides form design,
>> server
>> >> setup, in-field training, and software development for ODK.
>> >>
>> >> On Sun, Oct 25, 2015 at 12:58 PM, wrote:
>> >> > Following the thread, would love to have a solution for it.
>> >> >
>> >> > On Saturday, October 24, 2015 at 1:02:30 AM UTC+6, pamj...@gmail.com wrote:
>> >> >> Dear all,
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >> Backgroung:
>> >> >>
>> >> >> My survey includes a repeat group to capture information about each
>> >> >> household member one by one. E.g. We start with household member #1
>> (Suzy),
>> >> >> and ask them a series of questions. Then we add a group member on
>> the PDA,
>> >> >> pick household member #2 (Andy) and ask them the same series of
>> questions.
>> >> >> Continue for all household members.
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >> Later in the same survey (not part of the above repeat group), we
>> ask
>> >> >> about household chores and who is in charge.
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >> Question:
>> >> >>
>> >> >> Is it possible in XLSform (and if so, how) to include in this
>> chores
>> >> >> section a question that allows the respondent to choose the name of
>> a
>> >> >> household member from a list composed of the names given in answers
>> in the
>> >> >> original household member repeat group?
>> >> >>
>> >> >> E.g. Who is in charge of gardening (Select all that apply)
>> >> >> Suzy
>> >> >> Andy
>> >> >> Lisa
>> >> >> Chuck
>> >> >> Thanks,
>> >> >>
>> >> >>
>> >> >> Pamela.
>> >> >
>> >> > --
>> >> > --
>> >> > 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/d/optout.
>> >
>> > --
>> > --
>> > 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/d/optout.
>>
>
Hello @Derick_Deo, @Lloyd_Banwart,
Thanks for the examples.
I think, based on them, it is even possible to create a dynamic select list (using ${variable} placeholders as labels). Does someone already have an example. (It's a bit tricky, as we need to filter non-used (up to maximum) choices.
I have another question, please. If we have chosen a person, how can we use this to filter out into a following repeat_group, for ex. education date per HH member. We did not find a solution, except flattening all data, which will cause many disadvantages (for repeat functions like sum, count, and for export.) I am afraid, a relevant filter (based on index/position) doesn't help, and would cause a risk, if the user would validate without selecting all before.
Any hints for solution would be great.
Kind regards