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

  • Profile Image
    sysadmin@toothworks.com
    Asked 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
    ashwin_d
    Answered 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!