Two relevant options put together

1. What is the problem? Be very detailed.
I have a question with three multiple choices (A. Normal Mobile Phone, B. SmartPhone C. I don't Own any phone). If a farmer selects either A or B or both A and B, the next five questions in the field list should appear. Is there a way to do this?

2. What app or server are you using and on what device and operating system? Include version numbers.
Collect v1.23
Aggregate v1.7.
Samsung Tab A (2016)
OS v5.1.1

3. What you have you tried to fix the problem?
have tried using relevant option "selected(${Do_you_own_a_mobile_or_smartphone},'smartphone')" and selected(${Do_you_own_a_mobile_or_smartphone},'normal_mobile_phone')
in the xlxs form. But seems only one option is working.

4. What steps can we take to reproduce the problem?
Is there a way to combine these two?? I hope so.

5. Anything else we should know or have? If you have a test form or screenshots or logs, attach below.
Field_Data_1.xlsx (12.0 KB)

Hi @Frimpongeben1

As you stated in your question, it sounds like you are interested in the condition

The other condition "both A and B" is already included in the previous one.

I suggest you modify your relevant condition to selected(${Do_you_own_a_mobile_or_smartphone},'smartphone') or selected(${Do_you_own_a_mobile_or_smartphone},'normal_mobile_phone')

Depending on the logic of the form (e.g. in case the question is mandatory) you should also be able to write it in the complementary way, i.e. not(selected(${Do_you_own_a_mobile_or_smartphone},'I_do_own_any_mobile_phone'))

Other suggestions are:

  1. Depending on the length and complexity of the form, as well as on the data analytics you plan to run, it might be advisable to code your answers (i.e. assigning a short name to options and leave the long text as label). The advantage is also in terms of size of the submission (kB)
  2. you might want to include a constraint to avoid incompatible options are selected (e.g. select C and A or B). You can perform this by including a constraint that exclude selection of more than one element and selection of option C.
  3. there seem to be some typos in the form, e.g. 'what_is_your_expeerience_with_network_quality_in_your_area': the spelling of experience

I hope this helps!


1 Like