I’m working on a system that has many different forms (ie. Application,
Review, Amendment, etc.) and the questions on those forms are presented
to the user and they fill it out as necessary. The questions on those
forms change quite often, by adding new questions, removing old ones,
changing the data type of a question, etc.
I was thinking that rather than making changes in the database each time
a change to the form is made I could save all form data into a
serialized field. But I have concerns about the ability to run queries
in the data stored in the field and how that will affect reporting.
I was just wondering if anyone had a similar situation and how they
tackled it. Thanks for any input!