Willkommen, Gast
Benutzername: Passwort: Angemeldet bleiben:

THEMA: Dropdownlist as a subquestion depending on first dropdown question

Re: Dropdownlist as a subquestion depending on first dropdown question 9 Monate 1 Woche her #98059

  • holch
  • holchs Avatar
  • OFFLINE
  • LimeSurvey Team
  • Beiträge: 2447
  • Dank erhalten: 254
  • Karma: 94
Overall I think the number of subquestions might be a problem, because there are certain limits on the number of columns in a MySQL database (like for most other database engines as well). And as you probably have more questions than this multiple choice question with 1240 subquestions, I think you will easily hit those limits.

First of all, the system with the two dropdowns will only work, if the person only has activities in one district of one province.

I don't know how many provinces do exist and how many districts a province has. I assume it is not an option to create different questions for each province and then for each district which will be shown by conditions. But anyway, this will still not solve the problem of many, many columns in the database table.

And by the way: Who are "they" who said this will not be a problem?
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!
Der Administrator hat öffentliche Schreibrechte deaktiviert.
Folgende Benutzer bedankten sich: DenisChenu

Re: Dropdownlist as a subquestion depending on first dropdown question 9 Monate 1 Woche her #98060

  • Mazi
  • Mazis Avatar
  • OFFLINE
  • LimeSurvey Team
  • Beiträge: 5279
  • Dank erhalten: 289
  • Karma: 246
holch schrieb:
Overall I think the number of subquestions might be a problem, because there are certain limits on the number of columns in a MySQL database (like for most other database engines as well). And as you probably have more questions than this multiple choice question with 1240 subquestions, I think you will easily hit those limits.
I agree. Before continuing, I recommend to activate the survey for testing to see if you run into the DB table limit.

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'"
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: Dropdownlist as a subquestion depending on first dropdown question 9 Monate 1 Woche her #98072

  • Gabriela
  • Gabrielas Avatar
  • OFFLINE
  • Senior Lime
  • Beiträge: 64
  • Karma: 0
HI all,
Thanks to all for answering.
I understand, "they" means the guys in charge of the IT department of the organization. (its an NGO). I activated the survey, and did nto show any error.
But reading all of your comments, I supose my solution is not an option then especially because of the number of items.
Than I should choose a Multiple text question?
I prefered multiple choice cause actually there is not a fixed number of localities they visit per period, so its difficult to guess how many fields to add to the multiple text question...
Any ideas how to solve this, I really appreciate it.
Thank you so much again
gab
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: Dropdownlist as a subquestion depending on first dropdown question 9 Monate 1 Woche her #98073

  • Gabriela
  • Gabrielas Avatar
  • OFFLINE
  • Senior Lime
  • Beiträge: 64
  • Karma: 0
Sorry,
when I tested in local it gave no error.
But in the server it did.

"[an error occurred while processing this directive]"

So definitely there would be a DB problem.

thanks..
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: Dropdownlist as a subquestion depending on first dropdown question 9 Monate 1 Woche her #98076

  • DenisChenu
  • DenisChenus Avatar
  • OFFLINE
  • Moderator Lime
  • Beiträge: 5866
  • Dank erhalten: 718
  • Karma: 222
Hello,

With selectjs : i don't tal af a multi text bur a long text.

The city is savec in DB like that:
city1,city2,city2

Denis
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: Dropdownlist as a subquestion depending on first dropdown question 5 Monate 3 Wochen her #101289

  • dweisser
  • dweissers Avatar
  • OFFLINE
  • Silver Donor
  • Beiträge: 182
  • Dank erhalten: 5
  • Karma: 5
This solution is fantastic. Cascading selection FTW!

One question, when I put the function in the template.js, the cascading between drop-downs no longer works. Both parts of the script seem to have to be in the source of the questiontext of the second, or dependent, question.

I was only wondering why this is the case. Seems to me you should be able to put the first part into the template.js.

Thank you again for a really great piece of work!
David
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: Dropdownlist as a subquestion depending on first dropdown question 5 Monate 2 Wochen her #101337

  • DenisChenu
  • DenisChenus Avatar
  • OFFLINE
  • Moderator Lime
  • Beiträge: 5866
  • Dank erhalten: 718
  • Karma: 222
Hi,

Think we can copy/paste all js file on template.js, but maybe lost something. And the scrpt was made for 1.92, not updated actually for 2.00.

Do you have a link to test ?

Denis
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: Dropdownlist as a subquestion depending on first dropdown question 5 Monate 1 Woche her #101625

  • dweisser
  • dweissers Avatar
  • OFFLINE
  • Silver Donor
  • Beiträge: 182
  • Dank erhalten: 5
  • Karma: 5
I think the template.js issue was taken care of by a recent update.

But, on a related question. I'm trying to accomplish something like one of the earlier posters:
List 3 is dependent on List 2 and List 2 is Dependent on List 1.

List 1 to List 2 works just fine. But List 2 to List 3 doesn't work at all. No answers show.
It seems to me that all it it should require is to repeat the process for each dependent question, but alas...

Here is a test link: http://www.springboltconsulting.com/survey/index.php

Any insight you can can provide would be most appreciated - as always.

Nebraska David
Der Administrator hat öffentliche Schreibrechte deaktiviert.
Moderatoren: ITEd
Ladezeit der Seite: 0.153 Sekunden
Donation Image