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

  • Profile Image
    Jude_Forsyth
    Asked on August 09, 2020 at 05: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. 

  • Profile Image
    Sonnyfer
    Answered on August 09, 2020 at 08: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 



  • Profile Image
    Jude_Forsyth
    Answered on August 09, 2020 at 09: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. 

  • Profile Image
    Sonnyfer
    Answered on August 09, 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.