Forms and Table integrations

  • martyrob
    Asked on November 12, 2020 at 1:14 PM

    Combine tables

    I see that on a table, you can make a connection to another table through adding another tab. But is there a way to combine tables by appending the information like in Excel? Let’s say I have 5 tables, each with 10 identical tables, and I want to combine them, can they be combined so that all the fields align vertically? For example, each Table has First Name field, Last Name field, Address field, etc. When combined, all the First Names (from all tables) would show in one column, as would all Last Names, etc.


    Multiple form submissions into one table

    From your Help page: You may want to view data from completely separate forms in a single table. For example, imagine you want a holistic view of your company hiring. You can combine data from your application form, take-home challenge submission form, interview candidate evaluation form, and final offer letter all in a single table

    - How does it know which submissions belong to the same person? Is an identifying criterion set up?

    -What happens if someone submits 2 versions of the same form? Does it create a new entry?

  • Jimmy_D
    Replied on November 12, 2020 at 3:59 PM

    Hi there,

    Allow me some time to investigate this, and I will get back to you as soon as I get an accurate answer.

    best,

  • martyrob
    Replied on November 12, 2020 at 4:02 PM

    Thank you!

  • Jimmy_D
    Replied on November 15, 2020 at 7:34 AM

    Hello @martyrob, 

    I am sorry for the delay.- Unfortunately, it is not possible to connect multiple table columns and align them vertically into one.- I have investigated and could not find a workaround as well. 

    The Connect a Table Function only lets you connect a specific column from another Form table.

    Feel free to reach out to us at any time should you have more questions. 

    Best regards,