Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Multiple choice answers to same "cell"

  • flamma
  • flamma's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
6 years 4 months ago #160543 by flamma
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
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
6 years 4 months ago #160547 by Joffm
Replied by Joffm on 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: manual.limesurvey.org/Expression_Manager


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

Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose