Hi all,
I’m create an interface to collect information from my users.
This interface has multiple pages and on each page I have a different form.
All data for all the forms are stored in the same table.
When a user clicks on the link and fills the information asked on the different forms, it stores each form answer in a different row.
I would like the data of each user to be stored within one row.
Below how the interface is made :
- Form 1 in Page 1 collects data from Fields 1 to 4
- Form 2 in Page 2 collects data from Fields 5 to 8
- Form 3 in Page 3 collects data from Fields 9 to 12
At the moment, the result on the table I have every time a user answers the different forms
User 1
- Row 1 : Data for Field 1 to 4
- Row 2 : Data for Fields 5 to 8
- Row 3 : Data for fields 9 to 12
User 2
- Row 4 : Data for Field 1 to 4
- Row 5 : Data for Fields 5 to 8
- Row 6 : Data for fields 9 to 12
etc
What I would like to have is for each user all the data from 1 user on 1 row :
User 1 : Data for Fields 1 to 12
User 2 : Data for Fields 1 to 12
Can you help me with that please ?