Check out the LimeSurvey source code on GitHub!

Dynamic array with external data?

More
5 years 11 months ago #58193 by medicnick
I would like to create an array question that has numerous rows that are determined at survey run time. The number of columns would remain the same, only the number of rows changes depending on the number of data available in (an external SQL table or csv or xls - really this is like a secondary token table).

The variables depending on the person taking the survey so the token would return a matching value that would be used to query the external db to return the values that should be used to dynamically fill the rows.

Is this question clear? I am willing to pay a dev to do this if can be done soon. I will reply or edit this post if the dev has been taken care of.

Thank you - Nick

Please Log in to join the conversation.

More
5 years 11 months ago #58416 by medicnick
Anyone, please?

Please Log in to join the conversation.

More
5 years 11 months ago #58457 by Mazi
This isn't possible because when acitvating a survey the table to store the answer data is created so this table has a fixed number of columns and it can't be changed dynamically.


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

More
5 years 10 months ago #58620 by medicnick
Thank you Mazi - after reviewing the workarounds it seems there may be two alternatives?

One is to create a table with a known maximum number of columns and then use javascript to hide the NULL fields? or to call an external db query that can load the fields through on on_load type function?

Thanks,
Nick

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form