Google Sheets Integration problem

  • 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

    Page URL: https://www.google.com/url?q=https%3A%2F%2Fform.jotformz.com%2F72296106289665&sa=D&sntz=1&usg=AFQjCNFNZcGzbRlUVMp8GPY0WIYQxU0Lug
  • aubreybourke
    Replied 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.

  • sanpedro
    Replied on August 23, 2017 at 1: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

     

  • sanpedro
    Replied on August 23, 2017 at 1: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

  • jonathan
    Replied on August 23, 2017 at 2:20 PM

    Hi Claudio,

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

    Thanks.