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.


  • Profile Image

    Have only selected Columns in Google Spreadsheet integration

    Asked 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?

    Page URL:
    https://form.jotform.com/60394395026155

    new submission google spreadsheet spreadsheet
  • Profile Image
    JotForm Support

    Answered by jonathan 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.