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

    Colors and Font formatting reset when new submissions received on integrated Google spreadsheet

    Asked by HandCTV on October 31, 2014 at 06:28 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

    format spreadsheet Google
  • Profile Image

    Answered by Carina on October 31, 2014 at 07:26 PM

    I could  not replicate the same situation. When I received new submissions, the spreadsheet would keep the format:

    You may try removing and adding again the Google Spreadsheet integration.

    Let us know if the problem persists.

  • Profile Image

    Answered by LHEDJ on September 28, 2016 at 11:48 AM

    Has there been a solution to the sheet resetting upon adding, updating or deleting a form field? 

  • Profile Image
    JotForm Support

    Answered by Mike on September 28, 2016 at 01:42 PM

    @LHEDJ,

    We do not have an option to stop the default Google Spreadsheet resetting upon updating the form.

    It might be possible to import the spreadsheet data to another (your custom one) spreadsheet with an IMPORTRANGE function.

    Google Docs: IMPORTRANGE

    Also, there is an alternative to our Google Spreadsheet integration - the integration via JotForm > Zapier > Google Spreadsheet.

    Zapier: Save new JotForm responses as Google Sheets rows