How can I put my old google sheets integration link in so that the updated jot form will populate in same place?

  • Jude_Forsyth
    Asked on August 9, 2020 at 5:04 PM

    Hi, I modified the jot form significantly but then went back to the original google sheet and made sure the columns now match the new form. But I am getting the modified jot form in my email but it doesn't show on the google sheet. I need to keep all the information together, not start a new google sheet because I have several sheets on the form and can't transfer all the material. I thought I could just copy the google sheet address but there is no place to put it in the integration. What do I do? 

    I can't upload the link or screen shot as it has people's contact info on it. 

  • Sonnyfer JotForm Support
    Replied on August 9, 2020 at 8:45 PM

    Hello Jude - Thanks for reaching out.

    Unfortunately, it's currently not possible to integrate forms with an existing Google Spreadsheet. The integration will create a new spreadsheet that will forward your existing submissions together with the ones to the generated Spreadsheet link.

    Moreover, kindly note that we do not recommend modifying an integrated sheet nor changing its settings as this can cause the integration to fail. I'd suggest using IMPORTRANGE function to copy the data to the different sheets and apply changes to that sheet if needed.

    Related Guide: How-to-Integrate-Forms-with-Google-Sheets 



  • Jude_Forsyth
    Replied on August 9, 2020 at 9:26 PM

    Thank you for a prompt answer. Unfortunately the importrange instructions are way too complicated for this beginner. I really have no choice now but to put in a new integration and then cut and paste all the material I have on all the sheets to make the google sheet work for me. The other option is to have two different google sheets or import the new data to my existing tracker.  This may be less work in the long run. 

  • Sonnyfer JotForm Support
    Replied on August 9, 2020 at 10:48 PM

    Sorry to hear that. Let me forward this to our developers to check if this is something that can be implemented in the future. Though we cannot give you an ETA for this feature request, rest assured you will be informed here for any updates.

    Thank you for understanding.