How do I integrate with Google sheets correctly so that information from 2 forms comes in one table in 2 sheets?

  • lorfbooking
    Asked on November 28, 2020 at 3:08 AM

    Dear Support Team,

    how do I integrate with Google sheets correctly so that information from 2 forms comes in one table in 2 sheets?

  • Jed_C
    Replied on November 28, 2020 at 5:24 AM

    Jotform integration only allows you to integrate with one Spreadsheet, but you can combine them manually by using the IMPORTRANGE feature.

    Try this guide https://support.google.com/docs/answer/3093340?hl=en and see if that helps you combine two Sheets.

    Let us know if you have any questions or if you need further assistance.

  • lorfbooking
    Replied on November 28, 2020 at 6:33 AM
    Everything worked out, now in the main table, work with imported data, when
    we change something everything disappears?
    Best regards, Lorf Team
    +48575596167, +48509333455
    www.lorf.pl, www.lorfhostels.com
    Facebook
    , Instagram
    сб, 28 нояб. 2020 г. в 11:24, JotForm :
    ...
  • Gaetan_B
    Replied on November 28, 2020 at 7:38 AM

    Hello lorfbooking,

    Thank you for your prompt reply.


    I am not sure to understand what you mean by "everything disappears".


    Could you please provide us with more details so we can provide you with an assistance of the best quality?


    Waiting to hear from you.

    Gaetan

  • lorfbooking
    Replied on November 28, 2020 at 9:22 AM

    We tried to import data from one table to another, but there is no access to the revision of the imported data. How do I solve this problem with your forms?

    1606573317 5fc25d05eea77 Screenshot 101606573351 5fc25d27abada Screenshot 21

  • Patrick_R
    Replied on November 28, 2020 at 11:00 AM

    Hi! Please allow me some time to check this. I'll get back to you soon with an update.

    Thank you!

  • Patrick_R
    Replied on November 28, 2020 at 11:51 AM

    Hello! I just tried the Google Sheet's IMPORTRANGE function and it worked for me. However, the problem I face was with the data alignment. Following is the screencast of my test:

    https://drive.google.com/file/d/1mrNrD06clfYzNhA_SXJO8_Uq-eeNXUAk/view?usp=sharing

    BTW, in our Tables view, yo should be able to view data of both forms in separate tabs. As shown in the screencast below:

    1606582276 5fc2800446143 Screencast 2020 Screenshot 10

    Let us know if this doesn't solve your purpose.

    Thank you!

  • lorfbooking
    Replied on December 3, 2020 at 1:20 PM

    Dear Patrik,

    Yes, that's right, the interchange function works, but the problem is that we have to work with data sometimes change them, if you change the column with imported data, there will be an error from the entire sheet - that's what we have a problem.

    To view two forms in the JotForm service, we saw how, thank you, we still want to add additional information to the individual cells of each client, because the Google table is acceptable and it is easier to import to other reports.

    Each form is integrated only with the first sheet of the Google table, and we have to run from the table to another table to copy. Maybe it is possible to export 2 forms to 1 Google table in 2 different sheets?

  • lorfbooking
    Replied on December 3, 2020 at 1:25 PM

    What's the difference?

    1607019896 5fc92d78534f8 Screenshot 10



  • Welvin Support Team Lead
    Replied on December 3, 2020 at 4:15 PM

    Yes, using one Google Spreadsheet for multiple forms is now possible. But you have two use the new Google Sheets integration to be able to pull up an existing sheet.

    Here's our guide for the new Google Sheet: https://www.jotform.com/help/790-how-to-integrate-jotform-with-google-sheets.

    The Legacy has been discontinued. If you removed that in the form, you can no longer get it back. The new Google Sheets will be the only item to be displayed.

    Thanks