Table Connecting

  • lreid13
    Asked on October 28, 2020 at 6:01 PM

    Can you connect two tables together?

    I'd like to create a table and then another tab and connect some of those fields...I did what I thought was right, but nothing populated. I should also add that I do not want to use a form to gather data from, just a table.

  • Lorenz JotForm Support
    Replied on October 28, 2020 at 10:21 PM

    Thank you for contacting us.

    You may try to add another column, wherein you will populate the data from the other table there.

    Here's a guide below.

    On your table, click on the "+ ADD" column1603937658 5f9a257a26cfc test   2020 10  Screenshot 10.

    Under the "CONNECTION" tab, please choose "Connect a Table".

    1603937686 5f9a2596bb1b6 test   2020 10  Screenshot 21

    Enter the column's name and hit "NEXT".

    1603937732 5f9a25c4299d5 test   2020 10  Screenshot 32

    Choose a table where you will get the data > Select form > Select Field to be populated > Create Column

    1603937803 5f9a260b81048 test   2020 10  Screenshot 43

    Once connected, a new column will show, wherein you can populate data from the field that was configured in the connection settings. If you click the add button from the blank cell, it will show a list of submitted data on the field that was set.

    1603937977 5f9a26b9be5cc test   2020 10  Screenshot 54

    I hope this helps. Let us know if you are referring to something else.

    Thank you!