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

    Google spreadsheet reset formatting every time

    Asked by Jasoncaouk on October 08, 2014 at 05:33 PM

    Dear, 

    one of my booking system got one problem

    every time  when we have the new submission, they should automaticly sycn to my google spreadsheet, we used different collor to differ orders, this morning, the problem come out.

     

    every new submission, the whole form in the google spreadsheet will go back to original.

    http://www.tianfu.co.uk/transport/booking.html

     

    https://docs.google.com/a/tianfu.co.uk/spreadsheets/d/1KDiFFT5n0xzOqNg2URmrgcyBPXP9ksw4qk7L5OeOJ74/edit#gid=184217733

    Page URL:
    http://www.tianfu.co.uk/transport/booking.html

    refresh problem different www new submission
  • Profile Image
    JotForm Support

    Answered by jonathan on October 08, 2014 at 11:50 PM

    Hi,

    Can you please confirm that you were modifying or customizing the integrated spreadsheet?

    If it is, then the JotForm Google Integration will only always removed any formatting or reset the integrated spreadsheet template.

    Simply put, you cannot edit/modify/customize the integrated spreadsheet.

    If want to apply customization on the spreadsheet, you should create a separate spreadsheet that is NOT integrated to JotForm.

    You can then use the import range functionality to copy existing data from the JotForm spreadsheet to your own custom spreadsheet.

     

    Hope this explains it. Please inform us if you need more assistance.

    Thanks.

     

     

     

     

  • Profile Image

    Answered by Jasoncaouk on October 09, 2014 at 12:57 AM

    I kept using spreadsheet for last 2 years, there was no problem, only from yesterday, all my customized integrated spreadsheet went wrong when every new submission

    before, when new submission come in, for the spreadsheet they only add the new submission data at the very bottom as new data, it would not affect the old data, now it will reset the whole form.

    can you help me to check it ?

  • Profile Image
    JotForm Support

    Answered by jonathan on October 09, 2014 at 02:08 AM

    Hi,

    Thank you for providing us more details.

    before, when new submission come in, for the spreadsheet they only add the new submission data..

    It still is like this till now. New submission are always appended at the last row.

     

    it would not affect the old data, now it will reset the whole form.

    Can you please describe further what was reset? This is the part I was not able to fully understand.

    What was reset on the whole form? Usually, new incoming submission data are just added at the last row of last submission in the integrated spreadsheet. The integrated spreadsheet should not affect anything on the side of the form..

    It will also help us understand more if you can share to us screenshot images so we can have visual on the problem you were trying to describe to us.

    You can follow this guide to include screenshot when you reply again.

     

    Thanks.

     

     

     

  • Profile Image

    Answered by Jasoncaouk on October 12, 2014 at 02:35 PM

     

     

    like before, we use different color to put note, and every new submission will only show in the laste row

     

    now when new data come in, the whole form will reflash.

  • Profile Image
    JotForm Support

    Answered by jonathan on October 12, 2014 at 03:50 PM

    now when new data come in, the whole form will reflash.

     

    I understand that before it was probably possible to modify and add formatting into the integrated spreadsheet and they are not refresh/remove or reflash every time there is new incoming submission.

    BUT as I also have mentioned previously -- this looks like not the case anymore. All formatting and customization on the integrated spreadsheet were usually removed every time new incoming submission data were added to the spreadsheet.

    Our development must have included an update in the Google Spreadsheet integration that removes any customization/formatting on the integrated spreadsheet.

    The option I suggest that you can do is to create a copy of the integrated spreadsheet in your Google account. You can use the copied version to have formatting/customization you want.

    Since the copy version is not connected to the form using Google integration, then it will not be affected by any new submission data.

    Hope this help. Inform us if you require further assistance.

    Thanks. 

     

     

     

  • Profile Image

    Answered by Jasoncaouk on October 13, 2014 at 05:30 AM

    HEY, 

    SO IN THE FUTURE, THERE IS NO MORE CUSTOMIZATION IN THE GOOGLE SPREADSHEET?

    WHY ??

    WHY SO INCONVENIENT?

    THAT IS THE REASON I KEPT USING JOT FORM FOR LAST 3 YEARS

    NOW I HAVE TO COPY ALL THE ORDERS INTO ANOTHER SPREADSHEET

     

     

  • Profile Image
    JotForm Support

    Answered by jonathan on October 13, 2014 at 07:16 AM

    As of the moment, the integration seems to have that limitation.

    So, yes its not recommended to modify/update/customize the integrated spreadsheet itself.

    You actually do not have to manually copy all orders into another spreadsheet. You can use some built-in functionality of the Google docs spreadsheet to import data from one spreadsheet to another.

    Check this article on how to.

    Hope this help. Inform us if you need further assistance.

    Thanks.

  • Profile Image

    Answered by Jasoncaouk on October 13, 2014 at 08:30 PM

    IF I USE IMPORTRANGE, I STILL CANT MODIFY THE SPREADSHEET
  • Profile Image

    Answered by jedcadorna on October 14, 2014 at 07:16 AM

    Your concern about spreadsheet resetting its format has been addressed so I have moved your other question about import range here http://www.jotform.com/answers/442637.