What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Spreadsheet integration broken

    Asked by FRDM 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.

    Page URL:
    http://www.jotform.com//?formID=40981107930958

    Submissions thanks
  • Profile Image
    JotForm Support

    Answered by jonathan 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

    Answered by FRDM 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

    Answered by FRDM 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
    JotForm Support

    Answered by ashwin_d 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

    Answered by FRDM 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
    JotForm Support

    Answered by jonathan 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.