I would like to know if someone can help getting started with this issue. We used to collect survey responses from a form and store the collected data for each "survey respondent session" in a single record (SQL Server row). I was asked to streamline our system by collecting the data in three tables by datatype (int, small text, long text), each response being linked to its survey by association through foreign keys. I was going to design my form to submit each response to questionnaires one at a time but then I was asked to replicate the forms as we used to have them: one submit button sending all responses (survey data) to questionnaire at once. My first issue with that (and probably not the last) is that I have no idea how to submit at once many data to create multiple records.
When, or if, I get this right, my next issue will be that I will need to find a way to automatically re-distribute the data vertically by "respondent session" for analysis/export in spreadsheets.
Don't quite know where to start here.
Any help will be much appreciated.