Form connected to Google Sheet

  • Profile Image
    askwebpro
    Asked on April 04, 2018 at 08:56 PM

    I have a form which is connected to a Google sheet. 

    It works fine, however, after a few submissions, it begins to send the entries to the top of the form - above the column labels.

    This then ruins my spreadsheet automation.

    I have reset the form and sheet several times and the same thing occurs each time.

    This is a demo for a client who will sign up as a Jotform client if the form works as needed.


    Thank you for your assistance.


  • Profile Image
    Kiran
    Answered on April 04, 2018 at 10:03 PM

    We are sorry for the inconvenience this may have caused. I have cloned your JotForm to my account and tried integrating Google spreadsheet. As I send a few test submissions, they seem to be updated normally on the spreadsheet. Could you let us know if you are making any changes to integrated spreadsheet? Could you try removing the Google spreadsheet integration on the form and reintegrate it? Also, please share the spreadsheet with us so that we can take a look and investigate the issue further.

    1522893808GoogleSpreadsheetShareLink.png

    Thank you!

  • Profile Image
    askwebpro
    Answered on April 04, 2018 at 10:05 PM

    Thank you for your kind attention, Sir.

    It appears that when I hid columns, that this caused the errors.

    I have corrected with a newly integrated sheet, and will not hide columns in the future.

    Thank you for the quick response.


  • Profile Image
    BJoanna
    Answered on April 05, 2018 at 02:01 AM

    We are glad to hear that you solved your issue. 

    Please note that editing of the spreadsheet that is integrated with a form can break the integration and we do not recommend it. Also, editing of the form, such as adding a new field or editing of the field labels will break the integration. 

    Feel free to contact us if you have any other issue or questions.