Reducing multiple choices dependent on previous selection

Hi All,

I am having a little problem generating a new select_multiple based on the
choices from a previous one. Here is an example:

  1. choose the teams that participated in the tournament:
    a, b, c, d, e, f

Let us say we choose a, b, and c

  1. Choose the top two teams (also select_multiple):

from a, b, c

I want to reduce the list such that it includes only the answer choices
from the previous selection. Cant seem to do it. Tried cascading and choice
filters, etc.. I am out of ideas.

Any hope :slight_smile: ?

Best,
Ghassan

Hi Ghassan,

Hi All,

I am having a little problem generating a new select_multiple based on the
choices from a previous one. Here is an example:

  1. choose the teams that participated in the tournament:
    a, b, c, d, e, f

Let us say we choose a, b, and c

  1. Choose the top two teams (also select_multiple):

from a, b, c

I want to reduce the list such that it includes only the answer choices
from the previous selection. Cant seem to do it. Tried cascading and choice
filters, etc.. I am out of ideas.

Any hope :slight_smile: ?

​See this thread:
https://groups.google.com/forum/#!searchin/opendatakit/$20Multiple$20selections$20(a$20SELECT$20Answer)$20as$20possible$20answers$20(ITEMS)$20to$20the$20next$20question/opendatakit/XK1BJLYGrNg/5ifJp3DDWtoJ

Best and Regards
Ronald Munjoma

··· On 26 November 2014 at 13:50, Ghassan Baliki wrote:

Best,
Ghassan

--

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.

--
Best and Regards
Ronald Munjoma
+263 775 625 283, +263 776 444 309

Hi all
I'm nw with ODK and whem i do like Ronald explain i just see the first choice.Your help please

··· On Wednesday, November 26, 2014 at 11:50:46 AM UTC, Ghassan Baliki wrote: > Hi All, > > I am having a little problem generating a new select_multiple based on the choices from a previous one. Here is an example: > > 1. choose the teams that participated in the tournament: > a, b, c, d, e, f > > Let us say we choose a, b, and c > > 2. Choose the top two teams (also select_multiple): > > from a, b, c > > I want to reduce the list such that it includes only the answer choices from the previous selection. Cant seem to do it. Tried cascading and choice filters, etc.. I am out of ideas. > > Any hope :) ? > > Best, > Ghassan

Many Thanks Ronald.

··· On Wednesday, November 26, 2014 1:43:33 PM UTC+1, Ronald Munjoma wrote: > > Hi Ghassan, > > On 26 November 2014 at 13:50, Ghassan Baliki <baliki...@gmail.com > wrote: > >> Hi All, >> >> I am having a little problem generating a new select_multiple based on >> the choices from a previous one. Here is an example: >> >> 1. choose the teams that participated in the tournament: >> a, b, c, d, e, f >> >> Let us say we choose a, b, and c >> >> 2. Choose the top two teams (also select_multiple): >> >> from a, b, c >> >> I want to reduce the list such that it includes only the answer choices >> from the previous selection. Cant seem to do it. Tried cascading and choice >> filters, etc.. I am out of ideas. >> >> Any hope :) ? >> > > ​See this thread: > https://groups.google.com/forum/#!searchin/opendatakit/$20Multiple$20selections$20%28a$20SELECT$20Answer%29$20as$20possible$20answers$20%28ITEMS%29$20to$20the$20next$20question/opendatakit/XK1BJLYGrNg/5ifJp3DDWtoJ > > Best and Regards > Ronald Munjoma > > ​ > > >> >> Best, >> Ghassan >> >> -- >> -- >> 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. >> > > > > -- > Best and Regards > Ronald Munjoma > +263 775 625 283, +263 776 444 309 >

Hi All,

I cannot seem to get this running still. Can anyone please share some
thoughts on how to include a simplified code for xlsform?
using selected-at is returning an empty selection.
Much appreciated!
Ghassan

··· On Wednesday, November 26, 2014 2:13:49 PM UTC+1, Ghassan Baliki wrote: > > Many Thanks Ronald. > > On Wednesday, November 26, 2014 1:43:33 PM UTC+1, Ronald Munjoma wrote: >> >> Hi Ghassan, >> >> On 26 November 2014 at 13:50, Ghassan Baliki wrote: >> >>> Hi All, >>> >>> I am having a little problem generating a new select_multiple based on >>> the choices from a previous one. Here is an example: >>> >>> 1. choose the teams that participated in the tournament: >>> a, b, c, d, e, f >>> >>> Let us say we choose a, b, and c >>> >>> 2. Choose the top two teams (also select_multiple): >>> >>> from a, b, c >>> >>> I want to reduce the list such that it includes only the answer choices >>> from the previous selection. Cant seem to do it. Tried cascading and choice >>> filters, etc.. I am out of ideas. >>> >>> Any hope :) ? >>> >> >> ​See this thread: >> https://groups.google.com/forum/#!searchin/opendatakit/$20Multiple$20selections$20%28a$20SELECT$20Answer%29$20as$20possible$20answers$20%28ITEMS%29$20to$20the$20next$20question/opendatakit/XK1BJLYGrNg/5ifJp3DDWtoJ >> >> Best and Regards >> Ronald Munjoma >> >> ​ >> >> >>> >>> Best, >>> Ghassan >>> >>> -- >>> -- >>> 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. >>> >> >> >> >> -- >> Best and Regards >> Ronald Munjoma >> +263 775 625 283, +263 776 444 309 >> >

Hi Ghassan,
Find attached file the xlsform version of the previous example.
Regards,

Koassi.

Multiple_selections_Test.xlsx (15.7 KB)

··· Le mercredi 26 novembre 2014 16:13:38 UTC, Ghassan Baliki a écrit : > > Hi All, > > I cannot seem to get this running still. Can anyone please share some > thoughts on how to include a simplified code for xlsform? > using selected-at is returning an empty selection. > Much appreciated! > Ghassan > > On Wednesday, November 26, 2014 2:13:49 PM UTC+1, Ghassan Baliki wrote: >> >> Many Thanks Ronald. >> >> On Wednesday, November 26, 2014 1:43:33 PM UTC+1, Ronald Munjoma wrote: >>> >>> Hi Ghassan, >>> >>> On 26 November 2014 at 13:50, Ghassan Baliki wrote: >>> >>>> Hi All, >>>> >>>> I am having a little problem generating a new select_multiple based on >>>> the choices from a previous one. Here is an example: >>>> >>>> 1. choose the teams that participated in the tournament: >>>> a, b, c, d, e, f >>>> >>>> Let us say we choose a, b, and c >>>> >>>> 2. Choose the top two teams (also select_multiple): >>>> >>>> from a, b, c >>>> >>>> I want to reduce the list such that it includes only the answer choices >>>> from the previous selection. Cant seem to do it. Tried cascading and choice >>>> filters, etc.. I am out of ideas. >>>> >>>> Any hope :) ? >>>> >>> >>> ​See this thread: >>> https://groups.google.com/forum/#!searchin/opendatakit/$20Multiple$20selections$20%28a$20SELECT$20Answer%29$20as$20possible$20answers$20%28ITEMS%29$20to$20the$20next$20question/opendatakit/XK1BJLYGrNg/5ifJp3DDWtoJ >>> >>> Best and Regards >>> Ronald Munjoma >>> >>> ​ >>> >>> >>>> >>>> Best, >>>> Ghassan >>>> >>>> -- >>>> -- >>>> 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. >>>> >>> >>> >>> >>> -- >>> Best and Regards >>> Ronald Munjoma >>> +263 775 625 283, +263 776 444 309 >>> >>

Thanks Koassi.

Very very helpful!

Best,
G

··· On Wednesday, November 26, 2014 6:47:52 PM UTC+1, Koassi AKAKPO wrote: > > Hi Ghassan, > Find attached file the xlsform version of the previous example. > Regards, > > Koassi. > > Le mercredi 26 novembre 2014 16:13:38 UTC, Ghassan Baliki a écrit : >> >> Hi All, >> >> I cannot seem to get this running still. Can anyone please share some >> thoughts on how to include a simplified code for xlsform? >> using selected-at is returning an empty selection. >> Much appreciated! >> Ghassan >> >> On Wednesday, November 26, 2014 2:13:49 PM UTC+1, Ghassan Baliki wrote: >>> >>> Many Thanks Ronald. >>> >>> On Wednesday, November 26, 2014 1:43:33 PM UTC+1, Ronald Munjoma wrote: >>>> >>>> Hi Ghassan, >>>> >>>> On 26 November 2014 at 13:50, Ghassan Baliki wrote: >>>> >>>>> Hi All, >>>>> >>>>> I am having a little problem generating a new select_multiple based on >>>>> the choices from a previous one. Here is an example: >>>>> >>>>> 1. choose the teams that participated in the tournament: >>>>> a, b, c, d, e, f >>>>> >>>>> Let us say we choose a, b, and c >>>>> >>>>> 2. Choose the top two teams (also select_multiple): >>>>> >>>>> from a, b, c >>>>> >>>>> I want to reduce the list such that it includes only the answer >>>>> choices from the previous selection. Cant seem to do it. Tried cascading >>>>> and choice filters, etc.. I am out of ideas. >>>>> >>>>> Any hope :) ? >>>>> >>>> >>>> ​See this thread: >>>> https://groups.google.com/forum/#!searchin/opendatakit/$20Multiple$20selections$20%28a$20SELECT$20Answer%29$20as$20possible$20answers$20%28ITEMS%29$20to$20the$20next$20question/opendatakit/XK1BJLYGrNg/5ifJp3DDWtoJ >>>> >>>> Best and Regards >>>> Ronald Munjoma >>>> >>>> ​ >>>> >>>> >>>>> >>>>> Best, >>>>> Ghassan >>>>> >>>>> -- >>>>> -- >>>>> 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. >>>>> >>>> >>>> >>>> >>>> -- >>>> Best and Regards >>>> Ronald Munjoma >>>> +263 775 625 283, +263 776 444 309 >>>> >>>

I just tried it with the ODK Collect 1.4.12 and it works great. I've
attached a sample form...

Yaw

select_multiple_filter.xlsx (10.8 KB)

··· On Wed, Nov 30, 2016 at 2:00 PM, wrote: > On Wednesday, November 26, 2014 at 11:50:46 AM UTC, Ghassan Baliki wrote: >> Hi All, >> >> I am having a little problem generating a new select_multiple based on the choices from a previous one. Here is an example: >> >> 1. choose the teams that participated in the tournament: >> a, b, c, d, e, f >> >> Let us say we choose a, b, and c >> >> 2. Choose the top two teams (also select_multiple): >> >> from a, b, c >> >> I want to reduce the list such that it includes only the answer choices from the previous selection. Cant seem to do it. Tried cascading and choice filters, etc.. I am out of ideas. >> >> Any hope :) ? >> >> Best, >> Ghassan > > Hi all > I'm nw with ODK and whem i do like Ronald explain i just see the first choice.Your help please > > -- > -- > 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.

Thanks Koassi.
its great

With Regards
Vikash

··· On Thursday, 27 November 2014 21:48:11 UTC+5:30, Ghassan Baliki wrote: > > Thanks Koassi. > > Very very helpful! > > Best, > G > > On Wednesday, November 26, 2014 6:47:52 PM UTC+1, Koassi AKAKPO wrote: >> >>

Find attached file the xlsform version of the previous example.

Regards,

Koassi.

Le mercredi 26 novembre 2014 16:13:38 UTC, Ghassan Baliki a écrit :

Hi All,

I cannot seem to get this running still. Can anyone please share some
thoughts on how to include a simplified code for xlsform?
using selected-at is returning an empty selection.
Much appreciated!
Ghassan

On Wednesday, November 26, 2014 2:13:49 PM UTC+1, Ghassan Baliki wrote:

Many Thanks Ronald.

On Wednesday, November 26, 2014 1:43:33 PM UTC+1, Ronald Munjoma wrote:

Hi Ghassan,

On 26 November 2014 at 13:50, Ghassan Baliki baliki...@gmail.com wrote:

Hi All,

I am having a little problem generating a new select_multiple based
on the choices from a previous one. Here is an example:

  1. choose the teams that participated in the tournament:
    a, b, c, d, e, f

Let us say we choose a, b, and c

  1. Choose the top two teams (also select_multiple):

from a, b, c

I want to reduce the list such that it includes only the answer
choices from the previous selection. Cant seem to do it. Tried cascading
and choice filters, etc.. I am out of ideas.

Any hope :slight_smile: ?

​See this thread:
https://groups.google.com/forum/#!searchin/opendatakit/$20Multiple$20selections$20(a$20SELECT$20Answer)$20as$20possible$20answers$20(ITEMS)$20to$20the$20next$20question/opendatakit/XK1BJLYGrNg/5ifJp3DDWtoJ

Best and Regards
Ronald Munjoma

Best,
Ghassan

--

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.

--
Best and Regards
Ronald Munjoma
+263 775 625 283, +263 776 444 309

Tanks y ou for tais example It Aldo work for me too.
BEST.

··· Le 10 déc. 2016 16:38, "Yaw Anokwa" a écrit :

I just tried it with the ODK Collect 1.4.12 and it works great. I've
attached a sample form...

Yaw

On Wed, Nov 30, 2016 at 2:00 PM, dlougue@mercycorps.org wrote:

On Wednesday, November 26, 2014 at 11:50:46 AM UTC, Ghassan Baliki wrote:

Hi All,

I am having a little problem generating a new select_multiple based on
the choices from a previous one. Here is an example:

  1. choose the teams that participated in the tournament:
    a, b, c, d, e, f

Let us say we choose a, b, and c

  1. Choose the top two teams (also select_multiple):

from a, b, c

I want to reduce the list such that it includes only the answer choices
from the previous selection. Cant seem to do it. Tried cascading and choice
filters, etc.. I am out of ideas.

Any hope :slight_smile: ?

Best,
Ghassan

Hi all
I'm nw with ODK and whem i do like Ronald explain i just see the first
choice.Your help please

--

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/Y8242cBY6SE/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.

This solution works but is a bit complex. If you have a very long list of answer options in your first question (multi-select), then your choice filter syntax needs to be extremely long because you need to account for the possibility that a respondent will select a large number (or possibly all) of the answers in Q1. You end up needing something like:

selected-at(${Q1},0) OR selected-at(${Q1},1) OR .... selected-at(${Q1},N}

where N is the number of answers to the previous question - long and possibly error-prone, and a bit tedious to do if you have many such questions.

A quicker way to do it is to put the following in the choice_filter column for Q2:

selected(${Q1},name) = 'true'

Only answers checked in Q1 will appear as options in Q2.

Cheers,

Matt

1 Like

Thanks for your support very helpful

1 Like

A post was split to a new topic: Filter choice options from external CSV using previous selection