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.
Manipulate data using standard spreadsheetAsked by charitychallenge on January 13, 2017 at 03:42 AM
We do not recommend to manipulate the integrated google sheet as this can break the integration with the form. If you want to manipulate the data, I would like to recommend the ImportRange feature from google sheet.
You can use the ImportRange to copy the data of the Integrated Sheet into an entirely new spreadsheet. You can check out this guide on How To Import Data From Other Google Spreadsheets. By doing so, you will not need to modify the integrated sheet since you can modify the new spreadsheet instead.
I am aware of the ImportRange function, but with the Google Spreadsheets Integration problem at the moment this will not help anyway.
As far as manipulating the integrated sheet, when I have done this in the past, I leave the "Submissions" sheet intact and only reference the data to other sheets and manipulate there - I have never broken the integration when doing this.
As mentioned by my colleague, such changes on the sheet may cause the integration to fail. Perhaps the integration didn't fail for you yet as you were doing only simply edits, and not touching the sheet with submissions itself, but even changes saved to other sheets may cause the integration with a Google Spreadsheet to become broken.
The integration relies on the sheet remaining formatted the same way as the automated system created it when the integration was set up, and any deviation from that might break the data writing process. For that reason, when you want to manipulate data on an integrated spreadsheet, we recommend that you use the ImportRange function and import data to the spreadsheet where you will be making such edits.