I made the Google spreadsheet integration and everything went fine even

  • Profile Image
    Asked on June 27, 2013 at 04:40 AM

    I made the Google spreadsheet integration and everything went fine even after modifying the table (I put some colour in the columns and made some others invisible, but didn't add or clear something or changed the order). Yesterday I recognised that new entries were not pushed anymore to the spreadsheet (what after the formatting worked fine that day). So I tried to cut and reeintegrate the sheet. This was a mistake, because the reintegration opened a new sheet, so I lost all the formattings. Today I see, that the entries of yesterdays test after all found their way to the formatted table over night. So the integration was not broken, it just took a break. My question now: ist it possible to reestablish the connection between the form and the existing formatted table, which is already embeded in other site? And do you think that my (just cosmetic) customizing caused the break?

    This is a re-post of a comment on How to Integrate Forms with Google Sheets

  • Profile Image
    Answered on June 27, 2013 at 07:14 AM


    Please let us know the form id with which you are having this issue. Also it would be great if you could give us the access to your updated google spreadsheet. This will help us investigate your issue.



  • Profile Image
    Answered on June 27, 2013 at 08:20 AM

    Hi Sidharth

    Thanks for your support.

    ID: 238127838033821278

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

    New spreadsheet (actualy connected): https://docs.google.com/spreadsheet/ccc?key=0ApVLtS42KqefdHlxNGdZYlFncnFia2hKMzR5Z19zNGc&usp=sharing

    The table in action: http://pinguinkampf.weebly.com/resultate.html

  • Profile Image
    Answered on October 31, 2014 at 05:15 PM


    I have a similar issue.  Our jot forms work great.  The information is collected in a google spreadsheet, that works great too.  But to keep track of progress of dealing with feedback to customers filling in the forms, we changed colours on the spreadsheet rows or changed font formatting on spreadsheet rows.  We did not add columns or rows or change column or row orders in the spreadsheet.

    What happens in my case is that with new form submissions, the colours disappear and the font formatting in the spreadsheet is re-set.


  • Profile Image
    Answered on October 31, 2014 at 06:29 PM


    Your issue will be addressed on a separate thread.


    Thank you.