Google Doc spreadsheets reverting (problem)

  • Profile Image
    trackleaders
    Asked 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

  • Profile Image
    jonathan
    Answered 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!