I am struggling to connect multiple tables

  • Profile Image
    Miketta
    Asked on February 09, 2021 at 10:05 AM

    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.

  • Profile Image
    Jimmy_D
    Answered on February 09, 2021 at 11:49 AM

    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.

    1612889361_6022bd1190097_G2Jf1mDxrF.gif

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


  • Profile Image
    Miketta
    Answered on February 09, 2021 at 12:07 PM

    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

  • Profile Image
    Jimmy_D
    Answered on February 09, 2021 at 01:33 PM

    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. 

  • Profile Image
    Miketta
    Answered on February 09, 2021 at 02:45 PM

    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?

  • Profile Image
    Kiran
    Answered on February 09, 2021 at 05:32 PM

    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.