Skipping questions based on choices selected from a select one question

User Support Form Building
,
1

Hello everyone, I’m using kobotoolbox to build a form for an incoming project and I need your assistance on cascade select. The question is as follows below:
Select an asset class from the options available:

1.Office equipment
a. Paper shredder
b. Water dispenser
2. Machinery
a.  Planter
b. Generator
  1. Kitchen equipment
    a. Microwave
    b. Gas cooker
  2. Furniture
    a. Chair
    b. Desk
    c. Table
    d. Cupboard

Kindly assist me on creating this question in xls. Thanks.

2

@collins_collo, could you further explain your issue in detail (i.e., what happens if a user selects paper shredder and moves on and son on…) so that the community would be able to help you out.

3

For example, when I select office equipment, i should either select paper shredder or water dispenser. If i select machinery, I should either planter or generator. I hope you get my point.

4

So how would you like to see the cascading select question? Could you also share your dummy question that fits the cascading select model?

5

This is the first page.

Screenshot (19)
Screenshot (19)1100×531 25.7 KB

For instance if i select office equipment, the following screenshot should appear on the other page whereby it displays only the contents of office equipment.

Screenshot (20)
Screenshot (20)1094×519 16.1 KB

6

Didn’t understand your concern clearly (please correct me if I misunderstood you wrongly):

Q1. Please select all that is applicable:

  1. Office equipment
  2. Machinery
  3. Kitchen equipment
  4. Furniture

If 1 is selected from Q1 the following question and the choice should appear:

Q1_1 Office equipment
a. Paper shredder
b. Water dispenser

If 2 is selected from Q1 the following question and the choice should appear:

Q1_2 Machinery
a. Planter
b. Generator

If 3 is selected from Q1 the following question and the choice should appear:

Q1_3 Kitchen equipment
a. Microwave
b. Gas cooker

If 4 is selected from Q1 the following question and the choice should appear:

Q1_4 Furniture
a. Chair
b. Desk
c. Table
d. Cupboard

7

ABSOLUTELY TRUE.

Q1. Please select all that is applicable: It should be select ONE not ALL. Thanks.

8

If this is the case, it’s simply a matter of skipping. You need not look for a cascading select.

9

okay, would you please mind a demonstration of skipping using the information as an example?

1 Like
10

You could do it as outlined in the image shared below:

In the survey tab of your xlsform:

Image 1

In the choices tab of your xlsform:

Image 2

In the settings tab of your xlsform:

Image 3

Data entry screen as seen in Enketo:

Image 4

Data entry screen as seen in Enketo:

Image 5

Reference xlsform:

Skipping.xlsx (23.6 KB)

Maybe our support article Adding Skip Logic should also help you better understand using the Skip within your survey project.

1 Like
11

I appreciate your support sir. Be blessed and thank you for your assistance.

1 Like
12

Good morning, i’ve tried creating an xls skip logic form just as you instructed yesterday but there is an error message

Screenshot (26)
Screenshot (26)1360×698 41.4 KB
.
Below is the xls formCascading practise.xlsx (12.8 KB)

13

Try adjusting your xlsform as follows:

Have a closer look in the survey tab of your relevant column:

Image 1

It should be as follows:

Image 2

Reference xlsform:

Cascading practise.xlsx (13.5 KB)

2 Likes
14

I’ve seen my mistake sir. It has worked perfectly fine. Thank you.

1 Like