topic Using relevant expression to hide group of questions in ArcGIS Survey123 Questions

Using relevant expression to hide group of questions

MargueriteDonohoe — Thu, 15 Jun 2017 15:15:50 GMT

I can't get the relevant expression to work in order to hide a group of questions.

XLSX attached

If the Playground_Location is The Mall Playground I want a group of questions to appear that relate to outdoor equipment the is only available in this playground.

the expression I am using in the Relevant column of the Outdoor_Equipment_Checklist group is: ${Playground_Location}='The Mall Playground'

Does this expression have to be applied immediately after the select_one question?

Any help much appreciated.

Thank you.

Re: Using relevant expression to hide group of questions

JamesTedrick — Thu, 15 Jun 2017 15:34:28 GMT

The relevant statement needs to use the value of the name of the choice, not the label. in your form "The Mall Playground" has the value of 57. This is also what is recored when you submit data. Note that due to text/number conversion issues, the actual value to compare against may be "57.0"; this can be avoided by explicitly making the name values text in the Excel file (placing an apostrophe (') before the number will do this).

Re: Using relevant expression to hide group of questions

MargueriteDonohoe — Thu, 15 Jun 2017 15:40:13 GMT

Thank you James this really caught me out.

Re: Using relevant expression to hide group of questions

Lake_Worth_BeachAdmin — Wed, 28 Feb 2018 18:03:30 GMT

what if I want it to not equal multiple values

if ${question_1} !='value1' OR 'value2'

can this be accomplished? it works when I have 1 value but I need to add additional values to the !=

how do I get Value2 to be used

Re: Using relevant expression to hide group of questions

Lake_Worth_BeachAdmin — Wed, 28 Feb 2018 18:07:42 GMT

I got it to working using AND

${question}!='Value1' and ${question}!='Value2'