- Posts: 30
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Dropdownlist as a subquestion depending on first dropdown question
- Gabriela
- Offline
- Banned
Less
More
10 years 9 months ago #98037
by Gabriela
Replied by Gabriela on topic Dropdownlist as a subquestion depending on first dropdown question
Sorry to insist..I really need this
1. Droplist 1
2. Droplist 2
3. Multiple option Question
Droplist 2 if filtered by Droplist2
Multiple options question (checkboxes) is filtered by Droplist2.
Its very necessary cause Multiple options question has 1240 subquestions, I cant show them all...I have to filter them with dropdown2..
Is it possible to adapt the selectFilter.js to multiple options aswell?
Thank you so much
1. Droplist 1
2. Droplist 2
3. Multiple option Question
Droplist 2 if filtered by Droplist2
Multiple options question (checkboxes) is filtered by Droplist2.
Its very necessary cause Multiple options question has 1240 subquestions, I cant show them all...I have to filter them with dropdown2..
Is it possible to adapt the selectFilter.js to multiple options aswell?
Thank you so much
The topic has been locked.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11660
- Thank you received: 2742
10 years 9 months ago #98043
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic Dropdownlist as a subquestion depending on first dropdown question
Hmmm, and with 1240 subquestions for a multiple options question (which creates one column per subquestion) you don't run into database limits?
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The topic has been locked.
- Mazi
- Offline
- Official LimeSurvey Partner
10 years 9 months ago - 10 years 9 months ago #98044
by Mazi
Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
Replied by Mazi on topic Dropdownlist as a subquestion depending on first dropdown question
How many items are there at DD list 1/2 and the multiple choice question?
Maybe using some hidden questions and a (cascading) array filter might also do the trick.
Maybe using some hidden questions and a (cascading) array filter might also do the trick.
Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
Last edit: 10 years 9 months ago by Mazi.
The topic has been locked.
- Gabriela
- Offline
- Banned
Less
More
- Posts: 30
- Thank you received: 0
10 years 9 months ago - 10 years 9 months ago #98051
by Gabriela
Replied by Gabriela on topic Dropdownlist as a subquestion depending on first dropdown question
Hi all,
thanks so much for answering. Im attaching the survey, plus the .js code.
I dont know if there is a data base limit. I guess not, cause Ive told them about this and they said no problem...
Its on monitoring some activities in the south of Africa, and they want to have statistics on localities visited. So:
dropdown1= provinces
dropdown2= districts
Multiplechoice= localities (which can be several, thats why multiple choice)
I thought this code (used to filter the 2 dropdown ) could do, but its high level java for me. Im not at all javascript expert (or anything lower than that)
Thank you very much again.
thanks so much for answering. Im attaching the survey, plus the .js code.
I dont know if there is a data base limit. I guess not, cause Ive told them about this and they said no problem...
Its on monitoring some activities in the south of Africa, and they want to have statistics on localities visited. So:
dropdown1= provinces
dropdown2= districts
Multiplechoice= localities (which can be several, thats why multiple choice)
I thought this code (used to filter the 2 dropdown ) could do, but its high level java for me. Im not at all javascript expert (or anything lower than that)
Thank you very much again.
Code:
/* Copyright 2012 Denis Chenu for <http://www.sondages.pro> Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. */ /* Function to filter a select by another select In the same page var qID : the number of question to filter var filterqID : the number of question filtering */ function selectFilterByCode(qID,filterqID){ $(document).ready(function(){ var idSelectFilter = $("#question"+qID).find("select").attr('id'); $("#"+idSelectFilter).hide(); var idSelectFiltering = $("#question"+filterqID).find("select").attr('id'); if(typeof idSelectFilter === 'undefined' || typeof idSelectFiltering === 'undefined' ) { return false; } else { var idNewSelectFilter = 'select'+qID var NewSelectElement = "<select id='"+idNewSelectFilter+"'><option value=''>"+$("#"+idSelectFilter+" option[value='']:first").text()+"</option></select>"; $("#"+idSelectFilter).after(NewSelectElement); /* $("#"+idNewSelectFilter).width($("#"+idSelectFilter).width());*/ $("#"+idSelectFiltering).change(function(){ $('#'+idSelectFilter).val(''); $('#'+idNewSelectFilter).val(''); var valuefilter=$(this).val(); $('#'+idNewSelectFilter+' option').not(':first').remove(); $('#'+idSelectFilter+' option').each(function(){ if($(this).attr('value').indexOf(valuefilter)==0){ $(this).clone().appendTo('#'+idNewSelectFilter); } }); }); $("#"+idNewSelectFilter).change(function(){ $('#'+idSelectFilter).val($(this).val()); $('#'+idSelectFilter).trigger('change'); }); if($("#"+idSelectFiltering).val()!=''){ var valuefilter=$("#"+idSelectFiltering).val(); $('#'+idSelectFilter+' option').each(function(){ if($(this).attr('value').indexOf(valuefilter)==0){ $(this).clone().appendTo('#'+idNewSelectFilter); } }); if($("#"+idSelectFilter).val()!=''){ $('#'+idNewSelectFilter).val($("#"+idSelectFilter).val()); } } } }); } function selectFilterDualScale(qID){ $(document).ready(function(){ if($("#question"+qID).hasClass('array-flexible-duel-scale')){ // Fix width of columns answertextwidth=$(this).find("col.answertext").attr('width').replace("%",""); $(this).find("col.ddarrayseparator").attr('width',"2%"); ddarrayseparatorwidth=$(this).find("col.ddarrayseparator").attr('width').replace("%",""); var newwidth=(100-answertextwidth*1-ddarrayseparatorwidth*1)/2; $(this).find("col.dsheader").attr('width',newwidth+'%'); $("#question"+qID+" table.question tbody tr").each(function(index){ $(this).find("select").each(function(){ //$(this).attr('id',$(this).attr('id').replace('#',"_")); }); var idSelectFiltering = jqSelector($(this).find("select").eq(0).attr('id')); var idSelectFilter = jqSelector($(this).find("select").eq(1).attr('id')); var idNewSelectFilter = jqSelector('select'+qID+'_'+index); var NewSelectElement = "<select id='"+idNewSelectFilter+"'><option value=''>"+$("#"+idSelectFilter+" option[value='']:first").text()+"</option></select>"; $("#"+idSelectFilter).hide(); $("#"+idSelectFilter).after(NewSelectElement); $("#"+idNewSelectFilter).width($("#"+idSelectFilter).width()); $("#"+idSelectFiltering).change(function(){ $("#"+idSelectFilter).val(''); $('#'+idNewSelectFilter).val(''); var valuefilter=$(this).val().substring(0, $(this).val().length - 2); $('#'+idNewSelectFilter+' option').not(':first').remove(); if($(this).val()==""){ $('#'+idNewSelectFilter).hide(); }else{ $('#'+idNewSelectFilter).show(); $("#"+idSelectFilter).find('option').each(function(){ if($(this).attr('value').substring(0, $(this).attr('value').length - 2)==valuefilter){ $(this).clone().appendTo('#'+idNewSelectFilter); } }); } }); $("#"+idNewSelectFilter).change(function(){ $('#'+idSelectFilter).val($(this).val()); $('#'+idSelectFilter).trigger('change'); saveval=$('#'+idSelectFiltering).val(); $('#'+idSelectFilter).trigger('change'); if($(this).val()==""){ $('#'+idSelectFiltering).val(saveval); $('#'+idSelectFiltering).trigger('change'); $('#'+idSelectFilter).val($(this).val("")); } }); if($("#"+idSelectFiltering).val()!=''){ var valuefilter=$("#"+idSelectFiltering).val().substring(0, $("#"+idSelectFiltering).val().length - 2); $('#'+idSelectFilter+' option').each(function(){ if($(this).attr('value').substring(0, $(this).attr('value').length - 2)==valuefilter){ $(this).clone().appendTo('#'+idNewSelectFilter); } }); if($("#"+idSelectFilter).val()!=''){ $('#'+idNewSelectFilter).val($("#"+idSelectFilter).val()); } }else{ $('#'+idNewSelectFilter).hide(); } }); } }); } function jqSelector(str) { return str.replace(/([;&,\.\+\*\~':"\!\^#$%@\[\]\(\)=>\|])/g, '\\$1'); }
Last edit: 10 years 9 months ago by DenisChenu. Reason: Use code balise PLEASE !
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13648
- Thank you received: 2491
10 years 9 months ago #98053
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Dropdownlist as a subquestion depending on first dropdown question
Hello,
This JS is not for multi choice question type, only for select single choice.
But here, i really think you need to review complete system : you can't have 1240 sub question, a really bad idea.
I think you need : 2 select like actually , and one text question type.
For the text question type :
Use some ajax source : ivaynberg.github.io/select2/index.html#ajax
Use tag system : ivaynberg.github.io/select2/index.html#tags
Dut need another script here.
Denis
This JS is not for multi choice question type, only for select single choice.
But here, i really think you need to review complete system : you can't have 1240 sub question, a really bad idea.
I think you need : 2 select like actually , and one text question type.
For the text question type :
Use some ajax source : ivaynberg.github.io/select2/index.html#ajax
Use tag system : ivaynberg.github.io/select2/index.html#tags
Dut need another script here.
Denis
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11660
- Thank you received: 2742
10 years 9 months ago #98059
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic Dropdownlist as a subquestion depending on first dropdown question
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?
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?
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The following user(s) said Thank You: DenisChenu
The topic has been locked.
- Mazi
- Offline
- Official LimeSurvey Partner
10 years 9 months ago #98060
by Mazi
Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
Replied by Mazi on topic Dropdownlist as a subquestion depending on first dropdown question
I agree. Before continuing, I recommend to activate the survey for testing to see if you run into the DB table limit.holch wrote: 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.
Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
The topic has been locked.
- Gabriela
- Offline
- Banned
Less
More
- Posts: 30
- Thank you received: 0
10 years 9 months ago #98072
by Gabriela
Replied by Gabriela on topic Dropdownlist as a subquestion depending on first dropdown question
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
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
The topic has been locked.
- Gabriela
- Offline
- Banned
Less
More
- Posts: 30
- Thank you received: 0
10 years 9 months ago #98073
by Gabriela
Replied by Gabriela on topic Dropdownlist as a subquestion depending on first dropdown question
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..
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..
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13648
- Thank you received: 2491
10 years 9 months ago #98076
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Dropdownlist as a subquestion depending on first dropdown question
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
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
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
- dweisser
- Offline
- Premium Member
Less
More
- Posts: 115
- Thank you received: 4
10 years 5 months ago #101289
by dweisser
Replied by dweisser on topic Dropdownlist as a subquestion depending on first dropdown question
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
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
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13648
- Thank you received: 2491
10 years 5 months ago #101337
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Dropdownlist as a subquestion depending on first dropdown question
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
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
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.