Multiple choice answers to same "cell"

More
4 weeks 3 hours ago #160543 by flamma
flamma created the topic: Multiple choice answers to same "cell"
Hi,


I'm new to Limesurvey so this might be kind of stupid question.

Trying to set up simple order form for our company. Idea is that I can take answers out weekly as excel file and send it to our vendor.

I have been successful this far. Problem comes in here:

I need multiple choice question to list additional services. LS puts each answer to separate "columns" with "yes" or "no". Our vendor needs all these add-ons to be listed in same excel cell by name. Is this possible with Limesurvey?

Here's picture to to clarify this out.

https://imgur.com/a/sISoF

Please Log in to join the conversation.

More
4 weeks 2 hours ago #160547 by Joffm
Joffm replied the topic: Multiple choice answers to same "cell"
Of course there is.

Create a new variable of type "equation" and by EM fill it with the data you need.

like:
{join(if(Q2_SQ003=="Y","03",""),if(Q02_SQ005=="Y","05",""),if(Q02_SQ012=="Y","12",""),if(Q02_SQ015=="Y","15",""))}

You see:
If the 3rd and the 12th subquestion is answered "Y" you get a string = "0312".

Read: https://manual.limesurvey.org/Expression_Manager


Unfortunately we have no more information; please attach your picture and even better a sample of your survey.

Joffm

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!