How can I sync responses from multiple forms into one Table?

  • adminocrda
    Asked on February 14, 2021 at 3:27 PM

    Under features I found this "Sync responses from connected forms" but I am not able to find how to do this.

    I am hoping it will allow me to pull certain fields from multiple forms automatically into one single Table. This would allow me to have a "Master Table" containing an "at a glance view" of submissions in various forms for each person instead of having to view each form separately for each person - for example, we have membership, licence, log book, Covid Health questionnaire and more. I would LOVE to be able to sync them so against one name you can see all relevant form submissions, but not every field from every form as this would be very repetitive in the "master Table".


    No URL included as I would like some fields from each of our forms to be able to be pulled into one Master Table.


  • Vick_W Jotform Support
    Replied on February 14, 2021 at 9:39 PM

    Hi there,

    There are two ways of connecting multiple forms in one table. You can create a new tab and add all the fields of a form to it.

    1613356447 6029dd9f63f38 1test Screenshot 10

    Or you can add a new column in a table and connect it to a different form.:

    1613356626 6029de52e1a43 1test Screenshot 21

    You can implement this in any existing table.

    Please try it and let us know if this will fulfil your requirement.

    Thanks

  • adminocrda
    Replied on February 21, 2021 at 1:20 PM

    I tried this, but when I sent a new submission to test it, it did not populate the new tab fields or the new column with what I had sent in

  • VincentJay
    Replied on February 21, 2021 at 7:49 PM

    Hi,

    Could you please do it again and follow this guide: https://www.jotform.com/help/1002-how-to-get-data-from-other-forms-in-jotform-tables

    After that, if the issue still persists, let us know what form field is not passing to your other JotForm table. Please try one field for testing purposes only.