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

    I made the Google spreadsheet integration and everything went fine even

    Asked by jaegi 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

    table site colour
  • Profile Image

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

    Answered by jaegi 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 by jefreylandicho 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

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

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