Google Spreadsheets integration not working

  • eliendg
    Asked on February 18, 2015 at 2:22 PM

    Hello, 

    My data doesn't get through to my spreadsheet. I tried reintegrating it several times, but from the moment I start making new tabs or anything in the spreadsheet, it stops working. Should you just not change anything to the spreadsheet? But then what is the point of getting your data there? 

    Thanks for helping out!

  • jonathan
    Replied on February 18, 2015 at 4:11 PM

    Thank you for contacting us.

    May I inquire if you were trying to edit the google spreadsheet after you have done the integration?

    As a rule, you should not edit the sheet itself that was integrated to the form. Some changes on the sheet like changing column names/headers, removing/adding column, renaming the sheet name, etc.. will break the integration.

    If you want to apply customization on the data, you can just create a new sheet within the spreadsheet and use import data and formulas 

    Hope this help. Let us know if the issue persist.

    Thanks.

  • eliendg
    Replied on February 18, 2015 at 4:30 PM

    Thank you for answering!

    I figured this might have been the problem, so the last time I tried all I did was to add sheets within the spreadsheet and change the integrated sheet's place. So even moving it left to right breaks the integration? 

    I'll try again without even looking at it, hopefully that'll work. ;)

  • jonathan
    Replied on February 18, 2015 at 5:37 PM

    Thank you for the details. Please let us know of the result. 

    Contact us again anytime for any assistance you need on JotForm.

    Thanks.