Welcome, Guest
Username: Password: Remember me

TOPIC: Dynamic Dropdown List based on Responded Survey

Dynamic Dropdown List based on Responded Survey 3 years 9 months ago #55746

  • tatyeong
  • tatyeong's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
Hi there,

I am new to Lime survey. I have a requirement to design a survey for people to register their table seating preference for a dinner function.

Assuming that there are 20 tables with 10 seats per table, I envision a survey with a drop-down list containing 20x10 = 200 options. So the dropdown list looks something like this:

Seat 01-01
Seat 01-02
...
Seat 01-10
Seat 02-01
...
Seat 20-10

Once someone has chosen a seat (let's say seat 02-01), this answer option is removed from the dropdown list for the people who respond to the survey subsequently.

Is it possible to populate dropdown list dynamically from a label set, with some condition such that it only populates those label that is not marked as taken. This will then require at the completion of the survey, that it updates the label set the seat option that has been taken.
The administrator has disabled public write access.

Re: Dynamic Dropdown List based on Responded Survey 3 years 9 months ago #55757

  • tpartner
  • tpartner's Avatar
  • NOW ONLINE
  • LimeSurvey Team
  • Posts: 4293
  • Thank you received: 810
  • Karma: 373
There is no "out-of-the-box" solution for this.

The only thing I can think of is fairly complicated: Use JavaScript/AJAX to call a PHP script that queries the database and returns the options already selected. The JS then removes those options from the dropdown.

This wouldn't really help though if 2 users accessed the DB at the same time - they could see and select the same options.
Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

LimeSurvey is open-source and run entirely by volunteers so please consider donating to support the project.
The administrator has disabled public write access.

Re: Dynamic Dropdown List based on Responded Survey 3 years 9 months ago #55790

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5348
  • Thank you received: 298
  • Karma: 250
Limesurvey was not designed for such complex tasks and it is not possible to disable an answer once it was chosen.
You can have a look at manual -> quotas but still that's not a perfect solution.
Better watch out for other tools, what about a simple spreadsheet at google docs for example?

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.

Re: Dynamic Dropdown List based on Responded Survey 3 years 9 months ago #55796

  • holch
  • holch's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 2853
  • Thank you received: 360
  • Karma: 125
I think this is less a task for a survey tool and more for a reservation tool (like for hotel rooms, etc.).
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.

Re: Dynamic Dropdown List based on Responded Survey 3 years 9 months ago #55798

  • tatyeong
  • tatyeong's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
Thanks for everyone's feedback.

I have a spreadsheet that provides this functionality. It is uploaded to Sharepoint, and the participants will checkout the document and make their seating plan choice. The problem with this is that I can't prevent people from modifying other's choice as there is no control on the spreadsheet.

Of course this is not too difficult to build using php / java, I just want to explore if there is any oob solution to this before exploring the custom-build otion.
The administrator has disabled public write access.

Re: Dynamic Dropdown List based on Responded Survey 3 years 9 months ago #55838

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5348
  • Thank you received: 298
  • Karma: 250
Problem is that this is a rather complex issue. You can look at for booking or room reservation software and maybe adapt those.
Also have a look at Doodle (doodle.com/), maybe when giving some instructions like "you are NOT allowed to mark a column that was already marked by someone else" this might work.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.121 seconds
Donation Image