Skip to main content
Question

Store data from multiple forms on one row on tables


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 ?

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Troy Tessalone
Forum|alt.badge.img+14

  • Author
  • Beginner
  • 1 reply
  • March 25, 2024

Thank you Troy for your answer.
I’m still struggling with it.
I will try to contact the support or find another way.