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

    Google Spreadsheet: Deleted columns recreated on next submission

    Asked by jbremner2 on May 16, 2014 at 12:38 PM

    I have a form configured to populate a google Spreadsheet but I dont need all fields so I deleted those colums. The problem is that the columns are recreated when a new submission is recieved. Is this the expected behavior or am I doing something wrong?




  • Profile Image

    Answered by EliezerN on May 16, 2014 at 03:33 PM

    Hi John,

    Yes, that is the correct functioning of the Google spreadsheet integration. There is no way to exclude certain fields/columns, it is intended to populate all your submission data.

    If what you need is to gather your submission data in an database like Excel format and exclude some fields, then what you can do is to create an Excel report. It will allow you to choose which fields you wish to include in the report.

    Here is how to create an Excel report: How to create an excel report?

    And once you create the Excel report you could integrate your form with our Excel2DropBox app: http://apps.jotform.com/app/excel2dropbox

    That will allow you to automatically upload your Excel reports to Dropbox so that it can be updated with the new submissions data automatically.

    I hope that helps. Please inform us if you need further assistance.