I made the Google spreadsheet integration and everything went fine even

  • Profile Image
    jaegi
    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 Form with Google Spreadsheet

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

    @jaegi

    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.

    Thanks,

    Sidharth

  • Profile Image
    jaegi
    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
    jefreylandicho
    Answered on June 27, 2013 at 09:00 AM

    I believe that is not possible as each integration generates a unique spreadsheet URL. What you could do is use the google import range to add the new submission to your previous spreadsheet. Modify the speadsheet (although its cosmetic) might cause the breakage as we really do not advise modify the spreadsheet once integrated. 

    If you have any other questions, please contact us again.

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

    Hi,

    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.

    Derek

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

    @Derek,

    Your issue will be addressed on a separate thread.

    http://www.jotform.com/answers/452563

    Thank you.