nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Conditional Visibility - show question if a particular choice is selected in one or more other questions

LouiseHarris1

Hello

I have created a form and I need to set up conditional visibility that will show a question if 'arable' is selected in one or more previous questions.

Question - Farm Type

Question - Main Enterprise

Question - Other Enterprises

If 'Arable' is chosen for any of the above questions I want to show the question 'Crops Gown?'

What expression do I need to use please?

Thanks

Find more posts tagged with

Accepted answers

DavidPike

Ah yes, apologies I read through too quickly. Are you able to screenshot to include the relevant column and contents and copy past the exact cell content/expression into the thread?

It really seems like missing parentheses, syntax or spelling error - e.g. I can also see farm_type instead of Farm_type in the expression you shared previously (but am unsure if it is case sensitive).

All comments

LouiseHarris1

I managed to get it working, I was missing parentheses. Correct expression below.

(selected(${Farm_type},'Arable') or selected(${Main_farm_enterprise},'Arable') or selected(${Other_enterprises},'Arable'))

Thanks for all the quick responses and suggestions. Between them all I got it sorted.

JenniferAcunto

The second syntax is not correct. Selected() takes 2 parameters - the question name and the choice you are looking for. You cannot add anything extra. You need to combine 3 selected() functions:

selected(${Farm_type}, 'Arable') or selected(${Main_farm_enterprise}, 'Arable') or selected(${Other_enterprises}, 'Arable')

The next thing to check is to ensure that you are using the name of the choices and not the Label value. Also, what column do you have your statement in, it should be in the Relevant or body::esri:visible column.

select mult.xlsx

Nicole_Ueberschär

The overall syntax seems to be right, I would suspect spelling mistakes that make it fail to work as you expect it. Make sure to use the name, not the label, for the selection and double check the spelling of the question names especially upper/lower case. Do you still get an error or is it just now showing/hiding as expected?

DavidPike

The error seems to reference crops_grown which doesn't seem to be related to this question. I'd look for that expression and fix or remove it from xls.

The first xepression should work, aside from a dash instead of underscore typo in main_farm_enterprise.

selected(${farm_type}, 'Arable') or selected(${Main_farm_enterprise}, 'Arable') or selected(${Other_enterprises}, 'Arable')

LouiseHarris1

Hi. Thanks for your response. So I am aware of using the selected expression and have used this in other questions on my form, but, want I am trying to do is to reference multiple questions in the selected expression e.g if 'arable' is selected in Farm_type, or or if 'arable' is selected in Main_farm_enterprise or if 'arable' is selected in Other_enterprises then show the question'what crops are grown?' (see screenshot below) Is that possible? I have tried various expressions like the following but always get errors

selected(${farm_type}, 'Arable') or selected(${Main_farm-enterprise}, 'Arable') or selected(${Other_enterprises}, 'Arable')

selected(${Farm_type}, 'Arable'or ${Main_farm_enterprise}, 'Arable' or ${Other_enterprises}, 'Arable')

Thanks

abureaux

You can use their the relevant or the body::esri:visible column. They have the same visual effect, but their back-end process is different.

Relevant will hide something, and in doing so make it null. Aka, if it's hidden, it doesn't exist.

body::esri:visible will just hide something (end of storey). Aka, if it's hidden, it still exists.

In either case, I highly recommend you use selected(${my_question},'Hello World'). Yes, you can use ${my_question}='Hello World', but that doesn't always work (e.g., for select_multiple), whereas the selected() approach is much more reliable.

Here is an example:

DavidPike

It's all done using the 'relevant' column in Connect.

Here's a good example of showing an 'issue comments' question with visibility dependent on either of 2 questions.

https://community.esri.com/t5/arcgis-survey123-questions/survey123-relevant-field-based-on-value-from-more/td-p/841259

If your questions have multiple answers e.g. arable and pasture - then use the 'selected()' syntax
https://community.esri.com/t5/arcgis-survey123-questions/quot-relevant-quot-field-syntax-for-multiple/td-p/775051

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.