Google Spreadsheet: Deleted columns recreated on next submission

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

     

    Thanks,

    John 

  • Profile Image
    EliezerN
    Answered 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.

    Thanks