Welcome to the LimeSurvey Community Forum

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

Pre-populate dropdown based on two variables

  • bianconijo
  • bianconijo's Avatar Topic Author
  • Offline
  • Bronze Donor
  • Bronze Donor
More
6 years 10 months ago #154943 by bianconijo
Ciao,
I have another question on dropdown. I unsuccessfully searched in the forum.

I need to have a dropdown menu whose values are picked from a CSV file but filtered based on the answers provided to two previous questions by the participant: classroom and gender.

So, if my classroom is 1A and my gender is M, the dropdown menu on the next page of the survey will be populated with the right list of teachers to be evaluated. See attached file.

I would like to pre-fill/arrange a CSV file like the attached file and upload it in LimeSurvey: this would be the DB.

The result would be that each student will see and rate only his/her own teachers.

If I manage to do that, then I would like to apply also this great script to progressively remove the teachers already evaluated from the list:
www.limesurvey.org/forum/can-i-do-this-w...dropdown-menu-values

Other remarks:
-teachers overlap across classrooms;
-teachers are more than 90 (around 10 per classroom);
-classrooms are more than 50;
-it’s a public survey, no token.

I tried with conditions, but I realized I should create as many dropdown questions as the required combinations of teachers (based on classroom and gender).

I don’t know if this result can be reached with LimeSurvey and some javascripts, but there's no harm in trying.

Thanks for your patience.

BC
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose