Google Doc spreadsheets reverting (problem)

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

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!