How Do I Create A Dynamic Form Builder And Database Design

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008R2

, +

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

Posted 11-Mar-15 3:16am

isi19

Updated 11-Mar-15 3:17am

v2

Add a Solution

Comments

ZurdoDev 11-Mar-15 9:22am

Use SharePoint or something that already exists.

Sergey Alexandrovich Kryukov 11-Mar-15 9:23am

What do you mean "how"? By doing appropriate software development work. The real question is: why? The whole idea does make certain sense though, only the idea need to be more mature. You actually want to have a database of database schema, metadata express in the form of data. You can further develop some kind of metadata-driven development approach.
What you describe is way to vague; what guidance could you expect?
—SA

isi19 11-Mar-15 9:30am

I am busy doing the database design and i need some guidance on how to structure the tables in the database for the creation of dynamic forms

Sergey Alexandrovich Kryukov 11-Mar-15 10:29am

It hard to imagine as a topic for this forum. There are a lot of considerations which can be considered as a dialog and joint work, not as a Quick Answer. You whole idea of "best practice" is wrong. This is R&D work, not following some patterns. Best practices do exist, but they are the same as best practices in general programming.
—SA

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 11497406 · Answer 1 · 2015-03-12T18:31:00

Solution 1

use Cassandra or MongoDb databases

Posted 12-Mar-15 18:31pm

Member 11497406

How Do I Create A Dynamic Form Builder And Database Design

1 solution

Solution 1

Add your solution here

Preview 0

How Do I Create A Dynamic Form Builder And Database Design

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us