"Relevant" field syntax for multiple choice questions

15437
2
Jump to solution
10-24-2016 03:57 PM
KatjaKrivoruchko
New Contributor III

Hello,

I have the following survey question:

Who are your main customers (check all that apply)?
-    Contractors
-    Designers
-    Manufacturer
-    Individual customers
-    Retailers
-    Other

If “Other” is checked, I want a text field to appear to provide more info. This works fine (with ${Customers} ='Other' query) if “Other” is the only field that is checked. However, if “Other” and anything else is checked, the query evaluates to false. What would be the correct syntax to get the text field to display when “Other” with or without other options is selected? I tried:

${Customers} like %'Other'%
${Customers} contains 'Other'
${Customers} like *'Other'*
${Customers} contains *Other*

Thank you!

Katja

Tags (1)
1 Solution

Accepted Solutions
IsmaelChivite
Esri Notable Contributor

Hi!  You may want to have a look at this blog post: https://community.esri.com/groups/survey123/blog/2016/05/28/the-art-of-hiding   The trick is described almost at the end when the function selected is described. You will want to use:

selected(${Customers},'Other')

For the speediest response, you may want to ask Survey123 questions in the   https://community.esri.com/groups/survey123?sr=search&searchId=597a242d-ea8d-4cec-8fe0-95150f0f0f3a&...‌ group.

View solution in original post

2 Replies
IsmaelChivite
Esri Notable Contributor

Hi!  You may want to have a look at this blog post: https://community.esri.com/groups/survey123/blog/2016/05/28/the-art-of-hiding   The trick is described almost at the end when the function selected is described. You will want to use:

selected(${Customers},'Other')

For the speediest response, you may want to ask Survey123 questions in the   https://community.esri.com/groups/survey123?sr=search&searchId=597a242d-ea8d-4cec-8fe0-95150f0f0f3a&...‌ group.

KatjaKrivoruchko
New Contributor III

This was it. Thank you!

0 Kudos