topic Re: Relevant syntax for Select_Multiple questions in Survey123 to generate a follow up question for only the selected answers in ArcGIS Survey123 Questions

Relevant syntax for Select_Multiple questions in Survey123 to generate a follow up question for only the selected answers

Adam_Coburn_NCC — Wed, 03 Mar 2021 13:50:42 GMT

Hello,

I am creating a Survey123 form in Connect where one of the questions asks for the reason why they are wanting to enroll in this tree planting scheme. The question is a Select_Multiple with 12 possible choices. I would like a free text box to appear when 11 out of these 12 possible answers are selected.

I have read the following similar questions asked on GeoNet but the only solution I can find that works is one I have used on a previous form but is not ideal in this scenario:

Select_Multiple Relevant in Survey123: Follow up questions for only answers selected - https://community.esri.com/t5/arcgis-survey123-questions/select-multiple-relevant-in-survey123-follow-up-questions-for/m-p/879743

"Relevant" field syntax for multiple choice questions - https://community.esri.com/t5/arcgis-survey123-questions/quot-relevant-quot-field-syntax-for-multiple-choice-questions/td-p/775051

The art of hiding - https://community.esri.com/t5/arcgis-survey123-blog/the-art-of-hiding/ba-p/898454

How Do I Apply A Rule In The Relevant Column When Using Select_Multiple? - https://community.esri.com/t5/arcgis-survey123-questions/how-do-i-apply-a-rule-in-the-relevant-column-when-using-select/m-p/734022#M1001

In the Relevant column I am using the selected() function to generate a text box if any of the 11 options are generated (screenshot attached). The issue arises when more than one of those particular answers are selected a text box is generated for each selection (understandably so). Ideally, I would like just one text box to show for the submitter to enter any relevant info irrespective of how many options are selected in the original question.

I have tried to create this in one expression listing the names of each option with 'and', 'or' etc with no luck. I have also tried using a contains() function to no avail too.

Any ideas are greatly welcomed. (Connect Version used is 3.9.120)

Thanks in advance,

Adam

Re: Relevant syntax for Select_Multiple questions in Survey123 to generate a follow up question for only the selected answers

AllisonHollier — Wed, 03 Mar 2021 15:18:28 GMT

I think maybe you need to use regex? regex(${purpose_of_planting},'detail11')

See attached, it worked for me. And if it works, I'd love to take credit for it, but a wonderful ESRI rep named Breanna showed it to me when I was having the same problem. (If other, then what?)

Re: Relevant syntax for Select_Multiple questions in Survey123 to generate a follow up question for only the selected answers

DougBrowning — Wed, 03 Mar 2021 15:31:59 GMT

I am not sure I totally get it but I think you mean just one box shows if they select any of the choices but one special one?

If so I would use not(selected(question, value)) in a relevant of a single text field.

Hope that it is

Re: Relevant syntax for Select_Multiple questions in Survey123 to generate a follow up question for only the selected answers

Adam_Coburn_NCC — Wed, 03 Mar 2021 16:51:21 GMT

Hi Allison,

Thank you for taking the time to look at this.

I've never used regex before so had a read up on it. I'm looking for a text box to appear if they select any of the options from 1 to 11 but not if the last option is selected. I couldn't see how I could get regex to solve this for me but that's probably more due to my ability level than the functions scope!!

In looking into the regex I did see how it could solve another issue I was facing (ensuring an answer was formatted a specific way as this was then used to generate an individual reference number for each form filled in (a solution which I too can not take credit for, one created and adapted from an @IsmaelChivite post on creating 'Ticket Numbers')) Using regex ensures that the information entered will always be acceptable to the following function that creates the reference number, so a huge thank you for that!

Re: Relevant syntax for Select_Multiple questions in Survey123 to generate a follow up question for only the selected answers

Adam_Coburn_NCC — Wed, 03 Mar 2021 16:54:04 GMT

Hi Doug,

Thank you also for your input works really well!

Re: Relevant syntax for Select_Multiple questions in Survey123 to generate a follow up question for only the selected answers

AllisonHollier — Wed, 03 Mar 2021 17:45:03 GMT

Thanks, I'm making a note of that one as well! Great solution!

Re: Relevant syntax for Select_Multiple questions in Survey123 to generate a follow up question for only the selected answers

AllisonHollier — Wed, 03 Mar 2021 17:47:26 GMT

Yep, sorry, I misread it. Glad regex fits in there somewhere. I'd never dealt with it either, but it's pretty hand dandy if the application is correct. 🙂