Have only selected Columns in Google Spreadsheet integration

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

  • Profile Image
    Answered on March 13, 2016 at 04:44 PM

    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.