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

  • Profile Image
    lorfbooking
    Asked on November 28, 2020 at 03: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?

  • Profile Image
    Jed_C
    Answered on November 28, 2020 at 05: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.

  • Profile Image
    lorfbooking
    Answered on November 28, 2020 at 06: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 :
    ...
  • Profile Image
    Gaetan_B
    Answered on November 28, 2020 at 07: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

  • Profile Image
    lorfbooking
    Answered on November 28, 2020 at 09: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_1606573351_5fc25d27abada_

  • Profile Image
    Patrick_R
    Answered 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!

  • Profile Image
    Patrick_R
    Answered 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

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

    Thank you!

  • Profile Image
    lorfbooking
    Answered on December 03, 2020 at 01: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?

  • Profile Image
    lorfbooking
    Answered on December 03, 2020 at 01:25 PM

    What's the difference?

    1607019896_5fc92d78534f8_



  • Profile Image
    Welvin
    Answered on December 03, 2020 at 04: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