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 Doc spreadsheets reverting (problem)

    Asked by trackleaders on May 17, 2014 at 05:13 PM

    Hi,

    Our company is paying for jotform service and we are finding the Google Doc spreadsheets are defaulting back to a stock view after we put hard work into customizing the spreadsheet view. I am adding additional columns, sorting by different variable than time stamp etc.

    Can you tell me what is happeneing there? It seems to happen after a ne entry is added to the spreadsheet.

    Thanks,

    Matthew

    Page URL:
    http://trackleaders.com/tourdivide-signup

    problem JotForm time stamp different thanks
  • Profile Image
    JotForm Support

    Answered by jonathan on May 17, 2014 at 10:01 PM

    Hi Matthew,

    Unfortunately, this is the default behaviour of the integrated spreadsheet when the form is integrated using Google Spreadsheet integration feature.

    The integrated spreadsheet is NOT customizable anymore. Customizing the spreadsheet can also cause broken integration which will then stop the form's submissions being transferred to the spreadsheet.

    We highly recommend not to alter/customize the integrated spreadsheet itself to avoid any lost of data or broken integration.

    IF you need to have custom spreadsheet that you will need to use the data of the integrated spreadsheet, what you can do instead is create a new separate spreadsheet using Google Docs application.

    Then, use the import range function of Google docs.

    Guide: https://support.google.com/docs/answer/3093340?rd=1

    Using this method will allow you to customize the spreadsheet without altering the actual integrated spreadsheet of the form.

     

    Hope this help. Please inform us if you need further assistance.

    Thanks!