EasyToHelp
asked on
Dynamic form builder forms and database design
Hi
I am currently tasked with creating a form builder.
Admin users will be able to create a form from a web portal GUI and once the form has been published system users will be able to access the form, fill out the form and save the data captured in the form.
I would like to know what would be the best practice to go about building this module.
I have thought about creating a new table in the database for each form that gets created
Alternatively i was thinking about creating one forms table,an elements table,forms with elements table,element types table.
Please could you give me some guidance as to what would be the best solution
I am currently tasked with creating a form builder.
Admin users will be able to create a form from a web portal GUI and once the form has been published system users will be able to access the form, fill out the form and save the data captured in the form.
I would like to know what would be the best practice to go about building this module.
I have thought about creating a new table in the database for each form that gets created
Alternatively i was thinking about creating one forms table,an elements table,forms with elements table,element types table.
Please could you give me some guidance as to what would be the best solution
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
On the otherhand use document stores, then you can create a describtive XML describing your form, create an XSLT to transform it into HTML/JavaScript which stores it results in the same object store..