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

  • Profile Image
    adminocrda
    Asked on February 14, 2021 at 03: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.


  • Profile Image
    Vick_W
    Answered on February 14, 2021 at 09: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.gif

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

    1613356626_6029de52e1a43_1test.gif

    You can implement this in any existing table.

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

    Thanks

  • Profile Image
    adminocrda
    Answered on February 21, 2021 at 01: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

  • Profile Image
    VincentJay
    Answered on February 21, 2021 at 07: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.