Creating forms

[zero_ZX]

Hi,

So I would like my users create their own forms using my website. Other users of the website can then fill out the form.

I was thinking about how to do this, and came up with some examples, first one is probably the most easy one, simply to have a table in the db called forms, containing, who owns it, if it's active etc. Then have one called form_elements that contained and element id, what assigned form, and what type of element is (drop-down, checkbox, textarea etc.)

Then for each form created i create a <form-name>_answers that contain all the submissions for a particular form.

I dunno if this is a good idea, I don't think it's used much, but very unsure.

 

The second looks like the second, except that instead of all forms having their own answer table, i have a single answer table, and just store the entire response in an array.

 

Any advice, suggestions, or ideas are greatly appreciated.

[AyKay47]

What would be the point of having users actually create a form?

Why not have a form already there, and allow users to edit the form (add input fields etc.)?

[zero_ZX]

One user creates a form for a specific demand and other users fill it. User2 might need the users to answer different questions. So he needs another form.

[Jessica]

The way you have described makes sense to me. Why don't you try it and see how it goes?