topic Re: remove selection from select_multiple in calculation in ArcGIS Survey123 Questions

remove selection from select_multiple in calculation

BrentKinal1 — Wed, 14 Mar 2018 15:40:48 GMT

I have a select multiple question that has an option called "Not Listed" that if selected exposes a text question to enter the not listed value. I would like to combine the responses from the select multiple field (minus "Not Listed") and the text field in to a new field. I have the calculation set to combine the two fields, however I would like to clean things up a bit and remove the "Not Listed" response from the string, is there a way to select everything but from a text string?

I have tried the not() statement but just get the response "true" in my calculation.

Thanks!

Re: remove selection from select_multiple in calculation

JamesTedrick — Wed, 14 Mar 2018 16:40:37 GMT

Hi Brent,

Right now this is somewhat difficult to do, as a select_multiple does not guarantee order. That being said, we are trialing a feature in the Early Adopter (beta) community that might meet your needs.

Re: remove selection from select_multiple in calculation

BrentKinal1 — Wed, 14 Mar 2018 17:04:51 GMT

Thanks James!

I couldn't figure out the exact feature in the early adopter program to handle this, what feature should I be looking for?

In this current case there aren't a whole lot of values in the select multiple question, so I could just link a bunch of if(selected$(select_multipleField), 'valueName', 'valueLabel ', '') + ... statements together. I am hoping down the road to find a more eloquent approach esp for longer select multiple lists.

Re: remove selection from select_multiple in calculation

JamesTedrick — Wed, 14 Mar 2018 18:11:03 GMT

Hi Brent,

I was referring to the custom JavaScript functions - one of the applications for this is custom text processing. You could easily to split the choices, remove a value and reassemble them.

Re: remove selection from select_multiple in calculation

CarolineRose — Tue, 17 Apr 2018 19:04:17 GMT

My strategy for removing underscores from a select_multiple response may also offer you some ideas for cleaning up your list:

https://community.esri.com/thread/197470-can-you-calculate-a-hidden-field-removing-the-underscore-from-a-selectmultiple

Essentially, you create a hidden question for each option that populates with your desired text string, then create a text question that concatenates all of the corrected text strings using "join". It can be that simple if you don't care about a trailing comma-space (or whatever your separator is). You can get into more logic if you care to eliminate trailing separators.

I can elaborate further if you need.