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.
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.
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.
My strategy for removing underscores from a select_multiple response may also offer you some ideas for cleaning up your list:
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.