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

    New Submissions re-write any formatting changes I make to Integrated Google Sheets

    Asked by sysadmin@toothworks.com on March 25, 2014 at 02:33 AM

    Hi There,


    I'm using 4 identical jotforms for a Time Off Request sheet for 4 different office locations with 4 seperate integrated Google Sheets. (I'm replicating a form previously created with Google Forms)

    What Ive done with the file, is add 3 columns to the end of the auto-generated spreadsheet for Management to write notes and initial. I also need to do some conditional formatting on some of the cells.

    It seems that once I make these changes, each new submission appears to re-write the formatting, bringing it back to the original auto-generated version.

    Any advice? I spent an entire day on this, would hate to have to go back to our old solution which was just a simple Google Form.


    Thanks for the help!


  • Profile Image
    JotForm Support

    Answered by ashwin_d on March 25, 2014 at 04:41 AM

    Hello sysadmin@toothworks.com,

    I am not sure if I understood correctly on what formatting changes you did in your integrated google spreadsheet.

    I just did a quick test by creating a simple form and integrated it with google spreadsheet. I added 3 columns and did few test submissions. The 3 columns I added is intact. We would like to get some more information on the formatting you did on cell. Is it possible for you to share the google spreadsheet with us and we will take a look?

    I am not sure but the data is sent programmatically and most likely it will clear the formatting but again I would like to take a look on your spreadsheet. 

    I would suggest you to copy the entire submission records in a new sheet and do the formatting there.

    We will wait for your response.

    Thank you!