Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:
  • Page:
  • 1
  • 2

TOPIC: Single-scale array with drop-downs, or some other solution

Single-scale array with drop-downs, or some other solution 4 years 9 months ago #66660

  • Nebulous
  • Nebulous's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 17
  • Karma: 0
I'm a novice LimeSurvey user who hosts the survey on my own site. I've successfully (but slowly) created and administered one quite complex survey. That was several months ago, and now I need to create a pretty simple survey. But I can't figure out what question type to use.

I think I need an array with drop-downs. But I may be wrong on that. If so, I'm sure I don't need dual scale, but that seems to be the only type of array that has a drop-down option.

Here's what I want to accomplish:
I'm part of a group that meets monthly. We wonder if we could get better attendance if we changed our meeting time. So I want to ask everyone what their preferred meeting time is and also other meeting times that would work.

I see this laid out in three questions:
  1. What is your preferred week of the month, day of the week, and time of day to meet?

  2. What is your second preferred week/day/time?

  3. What is your third preferred week/day/time?

For each question, I want three drop-downs that will be reported as a single answer.
  • Week (1, 2, 3, 4)
  • Day (Mon, Tue, Wed, Thu, Fri)
  • Time (9:00, 10:00, 2:00, 3:00)

I want my report to show all of the first preference weeks/days/times, then all the other possibilities. Please note: I'm having difficulty making this clear, but it's important that the week/day/time remain together as a single answer ("Week 1, Monday @ 9:00" rather than "Week 1" and "Monday" and "9:00" standing by themselves, since someone may not prefer Week 1 if it's on Tuesday, etc. Hopefully that makes sense).

How can I best accomplish this?

Thanks!

~N
The administrator has disabled public write access.

Single-scale array with drop-downs, or some other solution 4 years 9 months ago #66668

  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 6114
  • Thank you received: 1356
  • Karma: 532
I think you will need to use Array (Numbers) questions and JavaScript to dynamically replace the displayed text for the options.

Hava a look at this post - www.limesurvey.org/en/forum/can-i-do-thi...dropdown-boxes#58244
Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The administrator has disabled public write access.
The following user(s) said Thank You: Nebulous

Single-scale array with drop-downs, or some other solution 4 years 9 months ago #66670

  • Nebulous
  • Nebulous's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 17
  • Karma: 0
Tony - Thank you for your reply. The link you posted at the top of that discussion is no longer valid.

It is fair to say, though, that I have the same need as Usapuka, and also the same disclaimers about being now and not knowing very much about JS. I can insert and tweak code, though.

Without the original that you pointed Usapuka to, though, I don't have enough context to go on.

Also, I have been told (in the chat room) that an array with drop-downs is available in the current version of LimeSurvey. I'm using v. 1.90, Build 9642. I see a link to upgrade to Administration -- Logged in as: jbbryant Update available: 1.91+(11026). I haven't upgraded since I started, and I'm not sure how risky it is. I'd prefer to hold off until after this survey is done.

Thanks for continued help!

~N
The administrator has disabled public write access.

Single-scale array with drop-downs, or some other solution 4 years 9 months ago #66672

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 5062
  • Thank you received: 748
  • Karma: 227
I think the problem is that you want/need to use the online reporting of Limesurvey, right? If you would analyse the results after the survey in Excel for example, there would be no problem to use separate questions, because you can always get over that during analysis.
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.
The following user(s) said Thank You: Nebulous

Single-scale array with drop-downs, or some other solution 4 years 9 months ago #66674

  • Nebulous
  • Nebulous's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 17
  • Karma: 0
@Holch - Well, maybe.

I've attached a screenshot of a (very) quick and (very) dirty mock-up of what I want in Excel.

Is this just a matter of manipulating the data in Excel afterward?

After the survey results are collected, I'm going to want to see all week/data/times that were selected, rule out the one-offs, and choose the most frequent ones listed - trying to please as many peoples' first choice as possible.

~N
Attachments:
The administrator has disabled public write access.

Single-scale array with drop-downs, or some other solution 4 years 9 months ago #66675

  • Nebulous
  • Nebulous's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 17
  • Karma: 0
(correcting my typo: ":ohmy: week/day/times"
The administrator has disabled public write access.

Single-scale array with drop-downs, or some other solution 4 years 9 months ago #66676

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 5062
  • Thank you received: 748
  • Karma: 227
I don't see how you could do this with the standard question types of Limesurvey. However, to be honest, I don't know any survey system that offers that (but I don't know the all, of course... ;-)).
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.
The following user(s) said Thank You: Nebulous

Single-scale array with drop-downs, or some other solution 4 years 9 months ago #66677

  • Nebulous
  • Nebulous's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 17
  • Karma: 0
@tpartner - Do you see a way to replicate my mock-up in LimeSurvey using your method of modifying a numerical array with JavaScript?

@holch - I appreciate your attempts!

~N
The administrator has disabled public write access.

Single-scale array with drop-downs, or some other solution 4 years 9 months ago #66678

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 5062
  • Thank you received: 748
  • Karma: 227
But even if you would modify the numerical array with Javascript, it would be like 3 subquestions and they would be shown differently. The only chace that I see is to create the dropdowns in HTML, read them via Javascript and write the joined results into a text field.

But maybe Tony has a better idea.
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.
The following user(s) said Thank You: Nebulous

Single-scale array with drop-downs, or some other solution 4 years 9 months ago #66679

  • Nebulous
  • Nebulous's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 17
  • Karma: 0
@holch:

Yes, I see what you mean by that. In other words, the survey tool can't combine three answers to a single question into one answer (so that in my screenshot the use's answer for Question 1 would be "Week 1, Tuesday, 2PM."

Do I understand correctly?

Somehow I thought they would all be associated with a single question code and thus would be combined as a single answer.

~N
The administrator has disabled public write access.

Single-scale array with drop-downs, or some other solution 4 years 9 months ago #66680

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 5062
  • Thank you received: 748
  • Karma: 227
Well, they are somehow combined, but only in the data base. For each column/line combination (each field) there should be one column in the database, if I am not totally wrong. Combining them would only be possible when analysed outside of Limesurvey, but that should be the same behaviour for most survey systems. What may be possible is to write the joined results into a field. Maybe this would even be possible to do so with INSERTANS in a text field, but I am not sure.
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.
The following user(s) said Thank You: Nebulous

Single-scale array with drop-downs, or some other solution 4 years 9 months ago #66681

  • Nebulous
  • Nebulous's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 17
  • Karma: 0
I think I'm much closer. I used "Array, Dual Answer" for my question type, chose to use drop-downs, set the header for my first scaled as "Week" and the header for my second scaled as "Day" in the advanced settings. I can now has someone select the week and the day. I just can't add the time of day. I guess I need "Array, Triple Scale" with drop-downs, but that doesn't exist :-(.

I've attached a screenshot of what that looks like.

BTW, "Concatenated" is more like what I meant.

I like the idea of using something like INSERTANS to pop them together into a field, and I conceptually understand what that would do, but figuring out how to accomplish it is beyond my technical skill.

I can analyze the data in Excel alright, as long as there will be something to tell me that Week 1, Tuesday, and 2:00pm belong together for a single response - and that it's a preferred time.

I still haven't figured out how to even add three text drop-downs to the right of a single question in an array.

I have upgraded since I mentioned it earlier, BTW. I do see that the current stable version has "drop down" as an advanced setting for Array, but only a single drop-down, not 3.

~N
Attachments:
Last Edit: 4 years 9 months ago by Nebulous.
The administrator has disabled public write access.

Single-scale array with drop-downs, or some other solution 4 years 9 months ago #66684

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 5062
  • Thank you received: 748
  • Karma: 227
Well, there would always be the option to join all 3 timings into one dropdown. If I didn't do any mistake in my calculation that would mean a total of 80 options. I guess you don't want to do that for usability reasons and I understand that (would be the easiest way - you can even style the dropdown answers via categories (eg. for week and for day). docs.limesurvey.org/Question+type+-+List...9#Category_separator

Or you just join two, e.g. Week and day or day and hour. It is only a compromise, but it would be probably one of the easiest solutions.

Now, if you want to go the full way and have all 3 date sets in a dropdown and all in one field, then there will be only one chance from my point of view: create the dropdowns and write them into one field (concatenate, as you said).

Or you create 3 single choice questions for each of your subquestions (preferred date, other date 1, 2, 3, etc.).

So for "preferred date" you would have the results in 3 columns (week, day and hour). Then in Excel you just have to go to those results and you could use the concatenate feature there to join them into an additional column.
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.
The following user(s) said Thank You: Nebulous

Single-scale array with drop-downs, or some other solution 4 years 9 months ago #66690

  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 6114
  • Thank you received: 1356
  • Karma: 532
Nebulous, given that you don't mind concatenating in Excel, I would create 9 separate single-choice-dropdown questions with question codes "week1", "day1", "time1", "week2", "day2", "time2"...

As Holch says, each of these questions would have its own column in the Excel export and you could concatenate them according the the appended numeral in the question code.

For display purposes you could use JavaScript/CSS to align each set of three questions side-by side so they look like an array. Let me know which template you are using and I'll put together a small script to align the questions (it would make it easier if these 9 question were the only dropdowns on the page).
Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The administrator has disabled public write access.
The following user(s) said Thank You: Nebulous

Single-scale array with drop-downs, or some other solution 4 years 9 months ago #66692

  • Nebulous
  • Nebulous's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 17
  • Karma: 0
Tony and Hotch - You guys are awesome. Thanks!

Tony - It makes sense (as in"why didn't I think of that?) now that you say it. Taking the long when to get to a short goal, I was!

I appreciate you being willing to do the js. The template I'm using is business_grey.

Thanks again!

~N
The administrator has disabled public write access.
  • Page:
  • 1
  • 2
Moderators: ITEd
Time to create page: 0.352 seconds
Imprint                   Data Protection Statement                  Revocation information and revocation form