Hi!
I am working on a survey wherein the form will automatically tick a value in the select multiple question if he/she has an answer in a certain question.
For specifics, if the user has an input in the Shopping Amount, that will automatically select Shopping as other activity in a select_multiple question.
Client also wants that the Shopping Amount be required if user has selected Shopping in either one of the two questions above - that one I figured that out, but the other requirement is still unsolved.
Is there any way to do this? Any help would be appreciated. Thank you in advance.
The problem is that your select_multiple isn't read only. As soon as a user makes a selection, the calculates will either stop working, or override the user selection (depends on you calculateMode). Neither of these scenarios are good though.
But, to do what you want:
But, as I mention above, here is the issue. As soon as the user makes a selection, you get a "refresh" icon:
This indicates that the calculates are no longer going to work... or, you can set calculationMode=always and the user's selection will be over-ridden.
The only real way to do this is to have the select_multiple be Read Only.
Hi, abureaux! The select_multiple question cannot be a set to read only because the users need to select all other activities done in the area.
I am trying to formulate a workaround for this process by using concatenate to get the values from the select_multiple above to add with the Shopping concat only, but those that are not selected are returning a value of 0. Do you know how to remove the other zeroes?
I'm not sure where those '0' would be coming from off-hand. I'd have to see the XLSX.
Regarding the list, you have two options now: