Google Sheets Integration problem

  • Profile Image
    sanpedro
    Asked on August 23, 2017 at 12:17 PM

    I have a form with integration with google sheets a google drive. Google Drive is working fine but the form stopped recording the submissons on the sheet. I cannot find the reason.

    Appreciate any help

  • Profile Image
    aubreybourke
    Answered on August 23, 2017 at 12:55 PM

    Please try removing the google sheet integration. And then add it again.

    How to Integrate Form with Google Spreadsheet

    It should solve your problem.

  • Profile Image
    sanpedro
    Answered on August 23, 2017 at 01:39 PM

    Hi, thank you for your swift reply.

    I've read all the threads about it and learned about not making changes to integrated Google sheets, so decided to use importRange formula to process submissions on an anoter SS. I am at the moment working around a Google sheet issue dealing with "circular dependency detected" in which I find No logic, and I am reading all Google forums to solve it.

    Thank you Again.

    Claudio

     

  • Profile Image
    sanpedro
    Answered on August 23, 2017 at 01:49 PM

    Sorry, new question:

    Is it Possible to add a new sheet to the integrated SpreadSheet so I can work with data there not modifying the destination sheet, also can I load all my processing code to the app script editor in the same SS? Can this affect the reception of JotForm submissions???

     

    Thank you in advance

    Claudio

  • Profile Image
    jonathan
    Answered on August 23, 2017 at 02:20 PM

    Hi Claudio,

    We will resolve the new question on another thread here https://www.jotform.com/answers/1230887

    Thanks.