Welcome, Guest
Username: Password: Remember me

TOPIC: Dynamic array with external data?

Dynamic array with external data? 3 years 6 months ago #58193

  • medicnick
  • medicnick's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 20
  • Karma: 0
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
The administrator has disabled public write access.

Re: Dynamic array with external data? 3 years 6 months ago #58416

  • medicnick
  • medicnick's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 20
  • Karma: 0
Anyone, please?
The administrator has disabled public write access.

Re: Dynamic array with external data? 3 years 6 months ago #58457

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5325
  • Thank you received: 296
  • Karma: 249
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)limesurvey.org'"
The administrator has disabled public write access.

Re: Dynamic array with external data? 3 years 5 months ago #58620

  • medicnick
  • medicnick's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 20
  • Karma: 0
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
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.128 seconds
Donation Image