Relevant problem and questions not showing up

User Support Form Building
,
1

What is the problem? Be very detailed.
(1) A group of questions that I have added to an XLS form will not show up unless I add a relevant statement from an earlier question. If I leave the relevant column blank, it just doesn’t show that group of questions at all.
(2)I have a problem with logic working in an XLS form. Within a group of questions the respondant must answer a question that is a ‘select_multiple’. Based on how they respond to this question I want a secondary group of questions to show up. When I add in the relevant statement for the secondary group of questions to say ${name}=‘1’ nothing will show up.

2. What app or server are you using and on what device and operating system? Include version numbers.
I am using an XLS form on Windows 10. I have been using KOBOToolbox to upload forms
3. What you have you tried to fix the problem?
checking for errors in variable names and labels. Looking at online resources

4. What steps can we take to reproduce the problem?
Assist to advise how to properly code the XLS form to have groups of questions show up when needed (with or without relevant statements)
5. Anything else we should know or have? If you have a test form or screenshots or logs, attach below.

In screen shot the ‘gmed’ group will not show up on the survey unless I put a relevant statement from an earlier answered question.

The ‘gism’ group will not show up at all, even with the relevant statement

What is the problem? Be very detailed.
(1) A group of questions that I have added to an XLS form will not show up unless I add a relevant statement from an earlier question. If I leave the relevant column blank, it just doesn’t show that group of questions at all.
(2)I have a problem with logic working in an XLS form. Within a group of questions the respondant must answer a question that is a ‘select_multiple’. Based on how they respond to this question I want a secondary group of questions to show up. When I add in the relevant statement for the secondary group of questions to say ${name}=‘1’ nothing will show up.

2. What app or server are you using and on what device and operating system? Include version numbers.
I am using an XLS form on Windows 10. I have been using KOBOToolbox to upload forms
3. What you have you tried to fix the problem?
checking for errors in variable names and labels. Looking at online resources

4. What steps can we take to reproduce the problem?
Assist to advise how to properly code the XLS form to have groups of questions show up when needed (with or without relevant statements)
5. Anything else we should know or have? If you have a test form or screenshots or logs, attach below.

In screen shot the ‘gmed’ group will not show up on the survey unless I put a relevant statement from an earlier answered question.

The ‘gism’ group will not show up at all, even with the relevant statement

image
image1385×608 37.8 KB

2

Hi @richards_8,

Welcome to the community! Would you mind sharing us your xlsform so that we could test it at our end. You could also share your xlsform in a private message if it contains confidential matters.

Have a great day!

3

Hi
On looking at your form and the specific queries, I would like to suggest the following

This question shows that the group is dependent on question med which is a multiple select. In that case, someone can select more than one response. If that is the case, your logic in gism shows that group should show if someone selects ONLY the response that has a value 1

image
image1251×546 259 KB

Another consideration
Please check the values for the response to see if they are really numbers such as 1 or they have other things. Use whatever is presented,

On the following issue

This should not be the case, share the XLS form with @Kal_Lam so that we test it, also show us a screenshot of what you are seeing.

Stephane

1 Like
4

Hi I see there is one response below indicating the issue with the multiple select - so if people select multiple options then it won’t show up. What isn’t clear is how I fix that issue so the options will show up if the user selects multiple options.

It also doesn’t help with the issue where one question never shows up unless I add a relevent statement. I would be happy to PM my excel sheet - but I can’t seem to figure out how quite yet… assistance would be appreciated.

5

Hello,
just an idea. For any select_multipe you need to use selected(${question}, ‘name’) (NOT label) of selected item.
Using S{question} = 'name’s the format for select_one only. (For a select_multiple, this will refernce the total string with all names selected, separated by blank).
Of course, you can reference several slected items, like selected(${q1} = ‘1’) or selected ($(q2) = ‘4’).

2 Likes
6

Hi @richards_8,

Kindly please follow what @stephanealoo and @wroos has advised. It should solve your issue. However, if you still have issues, please let us know. Shall send you a private message where you could share your xlsform.

Have a great day!

7

Thanks was able to figure it out with your notes.

1 Like
8

I should note - the issue resolved when I reformatted all of my relevant statements to be consistent with what you provided.

1 Like