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

    Changes in Google Spreadsheet are reset when new field is added to the form

    Asked by SXSWArtDepartment on June 26, 2015 at 12:22 PM

    This has happened at least 5 times now. The Google Spreadsheet that is tied to my Jotform keeps resetting. I need to add additional columns and color code each new entry that comes in. But every so often, the form resets and I have to start all over again. Why is this happening? Can you fix it?

    JotForm Google Sheets integration
  • Profile Image
    JotForm Support

    Answered by BJoanna on June 26, 2015 at 02:41 PM

    Sorry form inconvenience this may caused you. 

    I was able to reproduce mentioned problem on my sample form. I have submitted my form three times and I added color to one column. Then I added one additional field inside of my form and after new submission changes I made in Google Spreadsheet were gone.

     

    I think that this is how the integration works. It updates the Google Spreadsheet to default format to make sure that everything is linked properly.

    I will escalate this issue to our developers and we will inform you via if we have any updates.

  • Profile Image

    Answered by SXSWArtDepartment on June 30, 2015 at 02:20 PM

    I really appreciate the help. This google sheet editing is a big part of our project management process that we cannot otherwise do on jotform.com form results. 

  • Profile Image
    JotForm Support

    Answered by BJoanna on June 30, 2015 at 02:32 PM

    You are welcome. I see that one of our developers is assign to this ticked and he will inform you via this thread once this issue is resolved.

    Thank you for your patience.