Filtering choices in a checkbox lookup table

I’m trying to create a set of filtered location lists (sector, cell,
village) but with multiple options selectable. This doesn’t seem to work if
multiple answers are selected in the parent lists. I want to be able to
select two separate cells, and then proceed to select the appropriate
villages within each cell. However, the lookup table will not display any
choices if multiple answers are selected in the sector or cell lists. Is
there any way around this, aside from creating separate lookup tables?

Hey Eric,

I think you can modify your filtering logic for the second list.

So for example, you may have filtering logic that looks like:
state = /data/state (where state is a column in your district lookup table)

You would want to change that to be:
selected(/data/state, state)

(This essentially says that I want to show my district IF the district’s
state is one of the states chosen).

Thanks,
Sheel

··· On Wed, Jul 27, 2016 at 4:50 AM, Eric Jospe wrote:

I’m trying to create a set of filtered location lists (sector, cell,
village) but with multiple options selectable. This doesn’t seem to work if
multiple answers are selected in the parent lists. I want to be able to
select two separate cells, and then proceed to select the appropriate
villages within each cell. However, the lookup table will not display any
choices if multiple answers are selected in the sector or cell lists. Is
there any way around this, aside from creating separate lookup tables?


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


Sheel Shah
Project Manager | Dimagi
m: +1.781.428.5419 | skype: sheel_shah

That works! Thanks, Sheel!

-Eric

··· On Wed, Jul 27, 2016 at 3:24 PM, Sheel Shah wrote:

Hey Eric,

I think you can modify your filtering logic for the second list.

So for example, you may have filtering logic that looks like:
state = /data/state (where state is a column in your district lookup
table)

You would want to change that to be:
selected(/data/state, state)

(This essentially says that I want to show my district IF the district’s
state is one of the states chosen).

Thanks,
Sheel

On Wed, Jul 27, 2016 at 4:50 AM, Eric Jospe eric.jospe@gmail.com wrote:

I’m trying to create a set of filtered location lists (sector, cell,
village) but with multiple options selectable. This doesn’t seem to work if
multiple answers are selected in the parent lists. I want to be able to
select two separate cells, and then proceed to select the appropriate
villages within each cell. However, the lookup table will not display any
choices if multiple answers are selected in the sector or cell lists. Is
there any way around this, aside from creating separate lookup tables?


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


Sheel Shah
Project Manager | Dimagi
m: +1.781.428.5419 | skype: sheel_shah


You received this message because you are subscribed to a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/commcare-users/b0oLSxj7jwc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Thanks, Sheel
You have made my working simple since I was having a challenge.