Spreadsheet integration broken

  • Profile Image
    FRDM
    Asked on April 09, 2014 at 12:51 AM

    Google Spreadsheets integration appears to be broken - submissions are received successfully, but they never appear in the spreadsheet. Google recently switched to the 'new' Google Spreadsheets as the default - could this be the cause?

    Thanks.

  • Profile Image
    jonathan
    Answered on April 09, 2014 at 01:28 AM

    Hi,

    What you can also try is redo the integration to your form. Remove first the integration and then save your form. Then re-integrate it back to Google spreadsheet.

    When you redo the integration, it will refresh and will apply necessary updates on the form and the google spreadsheet.

    Hope this help. Please inform us if you continue to have issue even after doing this procedures.

    Thanks!

  • Profile Image
    FRDM
    Answered on April 09, 2014 at 01:36 AM

    Hi,

     

    When I did this, all my previous submissions appeared, but no new ones appeared after they were submitted. I don't want to have to redo the integration each time I want new submissions to appear.

     

    Thanks.

  • Profile Image
    FRDM
    Answered on April 09, 2014 at 02:07 AM

    Further info which may assist: Google's new spreadsheet is altering the spreadsheet URL, post-integration. E.g., the spreadsheet URL that appears the end of the integration wizard is https://docs.google.com/spreadsheet/ccc?key=10bI2IKyq6g0vszVv5ndNrkHIK0OH7c0rZLzwhVj6jls, but the actual spreadsheet URL is https://docs.google.com/spreadsheets/d/10bI2IKyq6g0vszVv5ndNrkHIK0OH7c0rZLzwhVj6jls/edit#gid=719495318

  • Profile Image
    ashwin_d
    Answered on April 09, 2014 at 03:28 AM

    Hello FRDM,

    Please be noted that every time you integrate your form with google spreadsheet, it will create a new spreadsheet in your google drive.

    Did you make any changes in the column headings of your spreadsheet? We would like to check your integrated google spreadsheet. I would suggest you to open the spreadsheet URL which you see in the integration window and change the permission so that we can view it from here. Please check the screenshot below:

    We will wait for your response.

    Thank you!

  • Profile Image
    FRDM
    Answered on April 09, 2014 at 03:30 AM

    Hi,

    I'm aware that a new spreadsheet is created each time an integration is performed - I've been using the correct spreadsheet each time. No changes have been made to the column headers in the spreadsheet.

    Here's my spreadsheet URL: https://docs.google.com/spreadsheets/d/10bI2IKyq6g0vszVv5ndNrkHIK0OH7c0rZLzwhVj6jls/edit#gid=719495318

    Thanks.

  • Profile Image
    jonathan
    Answered on April 09, 2014 at 05:42 AM

    Hi,

    Check the shared google spreadsheet but there was no content?

    And I checked your form http://www.jotformpro.com/form/40981107930958 , it has only 1 submission so far. So, I am not sure what had been tested here yet.

    --

    I cloned your form and did the test on my end.

    Here is my shared spreadsheet

    https://docs.google.com/spreadsheet/ccc?key=0ArHMx2ARJqlrdGhEYmRrRDBGWFIyRUZzb3FJSk1PT3c&usp=sharing

    This my test form http://form.jotform.me/form/40982415515455?

    You can test submit my test form and check if my shared spreadsheet updates accordingly.

    --

    Can you please redo the integration on your form. Update us if the issue remains on your end.

    Unfortunately, I could not reproduced any issue with this, so, I am not able to elevate a report to our higher team support.

    Thanks.