JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Have only selected Columns in Google Spreadsheet integrationAsked by TommyHulihanBasketball on March 13, 2016 at 03:37 PM
I only need certain information from the form that they fill our to integrate with Google sheets. When I deleted the columns that I wouldn't need, and a new submission comes through it is adding in the deleted columns. This used to not happen? Is there a way to fix it?
new submission google spreadsheet spreadsheet
The form Google Spreadsheet integration will always refreshed the Submission Sheet with all the data from the form every time new submissions happen.
This was the reason for the deleted columns in the Sheets gets recreated again.
What you can do instead is jsut Hide the Column in your Spreadsheet. So the column will always be hidden.
You can also import the Submission sheet to another/different sheet in your Spreadsheet and make sure to select only the column/field you wanted to be imported. You will then have a copy of the Submission sheet but with lesser or selected column only.
Hope this help. Let us know if there is more we can assist you with.