Welcome to the LimeSurvey Community Forum

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

Dynamic Dropdown-Boxes / dynamisch gefüllte Klappboxen

  • treick
  • treick's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 8 months ago #122346 by treick
Hello
is it possible to have the list used within a Dropdown-Control bound to a dynamic data source as in VBA?
So that the List is made up by an SQL-Statement? E.g. "SELECT pk, ParticipantName FROM MyTableSource WHERE TrainingSessionc='clusteranme';" I want to select names from a list of participants of a special training session out of several training sessions.
thx and regards
treick

Hallo
kann, wie bei z.B. VBA ein SQL-Statement als ControlSource für den Inhalt einer Klappbox verwendet werden?
Z.B. "SELECT pk, ParticipantName FROM MyTableSource WHERE TrainingSessionc='clusteranme';" Ich würde gerne die Teilnehemr einer bestimmten Trainigssession aus andeen Sessions auswählen können.

Besten Dank
treick

LimeSurvey Version + Build: 187+ 8453
PHP Version 5.3 (lokal XAMPP 1.72)
MySQL Version 5.1.37 (lokal XAMPP 1.72)
Betriebssystem: MS XPP SP3
Browser: FF 3.017
The topic has been locked.
  • gabrieljenik
  • gabrieljenik's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
8 years 8 months ago #122352 by gabrieljenik
Hi,

You could do some AJAX and fill the dropdown with those options.
Something similar like an autocomplete.

Please be aware that the ajax-loaded answer-options will not be present in the survey design, so may not be usefull in some situations as assessments.

Please find more info in the following links:
manual.limesurvey.org/Workarounds:_Manip...wers_for_text_inputs .

Cheers,

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

Checkout our Reporting Solutions and our plugin shop at www.encuesta.biz .

The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose