How deal a project with a lot of (different) data

Antares74

Member
Hello,
I need help to understand how to deal with this project
I have to create an app to manage surveys for commercial activities.
The surveys are made up from about 2000 questions and are dynamically generated according to some initial choices.
The answers that can give the user can be of different types (radio, check, combobox, field text).
What is the best strategy for storing questionnaires and answers?
I believe that the most logical thing would be to memorize the answers in a table like this

| ID
| FK-survey
| FK-question
| answer

But this way I can not manage the various types of fields.
 
I've only seen one person do something like this in the last ten years, and it required a huge amount of custom coding. Dynamically generating elements on forms simply isn't something that Fabrik was designed to do.

-- hugh
 
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top