Google Sheets Integration: Not Working Correctly

  • Profile Image
    GCUKProductions
    Asked on January 18, 2018 at 11:37 AM

    Hi,

    I have a number of forms that I have linked to Google Sheets via the integration option. I have renamed the Jotform folder and the sheet name via the integration settings. I've also customised the workbook to automatically pull through select data from the data on 'Sheet1' to a custom sheet named 'Access Application'.

    When a form is submitted the data does not appear in the Google sheet or it appears but on the incorrect sheet. I could only populate the sheet by removing the integration and re-adding.

    I have used this set up previously and worked fine.

    Please help it's urgent!

  • Profile Image
    aubreybourke
    Answered on January 18, 2018 at 12:31 PM

    When a form is submitted the data does not appear in the Google sheet or it appears but on the incorrect sheet. I could only populate the sheet by removing the integration and re-adding.

    If you are changing the folder and sheet names you would need to reintegrate each of them. I don't see any other way of doing it.


  • Profile Image
    GCUKProductions
    Answered on January 18, 2018 at 12:43 PM

    I have reintegrated them after renaming etc however the issue still persists. I have to reintegrate them every time to populate the most recent form data.

  • Profile Image
    BDAVID
    Answered on January 18, 2018 at 01:27 PM

    I just tried to push the missing submissions to the spreadsheet, but it did not work. It seems like it is broken. Please try removing and integrating once again, please do not make any further customization to the spreadsheet after you complete the integration. If the issue persist, leave it like that, and we will forward it to our back-end team for further help. 

  • Profile Image
    GCUKProductions
    Answered on January 18, 2018 at 02:57 PM

    I need the customisation, that's the point. I only need a snapshot of the data 85% of the time. I can't create the sheet first and link the form to it via the integration so if I remove and reintegrate, Jotform will just create a new sheet. There should be no reason why I can't customise the sheet ie. add new sheets, validation etc after the integration.

  • Profile Image
    aubreybourke
    Answered on January 18, 2018 at 03:15 PM

    The spreadsheet integration is very fragile. The smallest change can corrupt it. Which is the problem we are facing now.

    I recommend you start from the beginning. Let Jotform create a new spreadsheet first. Then you can try adding additional features to it.

    How-to-Integrate-Form-with-Google-Spreadsheet 

  • Profile Image
    GCUKProductions
    Answered on January 18, 2018 at 05:15 PM

    I recommend you start from the beginning. Let Jotform create a new spreadsheet first. Then you can try adding additional features to it.

    This is what I have tried already. As soon as I make any amendment to the sheet Jotform generates, it will no longer update. I have produced these spreadsheets yearly and have done for the last 2 years with no issue. This is a determining factor in the use of Jotform if I it cannot be fixed.

  • Profile Image
    Kevin_G
    Answered on January 18, 2018 at 07:33 PM

    OK, if you need to do any change on the spreadsheet I would recommend you to use the importrange function instead, this will help you to basically copy the data from one spreadsheet to another  one that is not integrated with JotForm where you can do any changes. 

    https://support.google.com/docs/answer/3093340?hl=en 

    I hope this helps.