I am struggling to connect multiple tables

I collect data from different forms, but always relating to the same member of our martial arts school. How do I connect them in ONE table?

For every member I have at least:

• yearly license
• local school membership
• Grading data

These are collected in three different forms, and on different websites.

Now I want to have ONE table, where all the data from the different forms is collected in ONE table. So I would like to use the name as a common denominator, and from all the three different forms I would then like the data to be drawn into ONE table.
In this one table, if I look for the name, there should be the data from all the three other forms combined.

Is that even possible? If I connect two tables, there is never a question for the connecting column that should drag the data together.

Thanks for contacting us.

It's possible to connect multiple forms or tables to one form using the Add button on JotForm Tables.

Once connected, you are able to access the submissions data from those other forms or tables via the new tab created, or access the selected column from the other tables from the new connection column.

Unfortunately, we don't have a feature that will merge all the data from multiple forms submissions page. 

Thank you!

I made it that far, but I struggle to make sure that the right data ends up in the right row.

How do I make it that if I have data from three forms, I can connect them in a way that I get the column data for ONE name correctly?

Let's say, I have one table that has:

Name - date of payment - home country

and another table that has

Name - date of birth - address

and a third table that has

name - email address - membership type

Now I would like a table that takes name as common denominator and takes the email address, membership type, date of birth, address and home country into one line, so we end up with an overview of all the information connected to ONE name? Is that possible? I don't seem to get that rolling.


PS: Pressing "add" and choosing from all the data available in the columns I understood. But that means to scroll through hundreds of entries.... :O

Now I would like a table that takes name as common denominator and takes the email address, membership type, date of birth, address and home country into one line, so we end up with an overview of all the information connected to ONE name? Is that possible? I don't seem to get that rolling.

PS: Pressing "add" and choosing from all the data available in the columns I understood. But that means to scroll through hundreds of entries.... :O

Unfortunately, there is no automatic way to achieve this. It can only be achieved manually. 

Ah, darn. :/
Of course that is a database functionality that probably can't be expected from a table app like this.
It would have made all the difference for us.

Can a table be filled by more than form?
That doesn't really work, does it?

Please note that each form is a different entity and the Tables is a view to display the submission data received to the specific form. Once you have connected the table to another as mentioned by our colleague, the data received to the form shall be automatically displayed in the connected table view.

Let us know if you are referring something different. We will be happy to help.