Exclude choices in select.multiple in repeated group

Support
1

1. What is the issue? Please be detailed.
Hi all, this is my first time working on ODK collect, I have several questions that repeated from select multiple question:

For example:
q1 => select color that applies:
green
purple
white
blue
red
brown
begin group
q2 => select things that has colour ${q1}
bag
pencil
pen
wallet
q3=> select food(s) that has colour ${q1}
biscuit
cake
candy
cookies
waffle

end repeat

I want q3 to exclude colour purple and blue and only repeated for other colours

2. What steps can we take to reproduce this issue?

What are the condition I should put and calculation to adressed the issue?

3. What have you tried to fix the issue?

I try to use not(selected(${colour}, '2')) or not(selected(${colour}, '4')) but it does not work.

4. Upload any test forms or screenshots below.

colouredthings.xlsx (11.1 KB)

Thank you,

2

Hello All,

Just want to check whether there is a solution for this

Thank you,

3

Hi @Aklan_Huda

  • your options sheet needs to be titled "choices" not "choice"
  • the values in your list_name column should not have periods, i replace them with underscores
  • i changed your relevance to: ${colour_1} != 'blue' and ${colour_1} != 'purple'

See a working XLSForm: colouredthings_edited.xlsx (11.2 KB)

1 Like