How to get the Excel file without some fields in it?

  • capcar2016
    Asked on January 6, 2016 at 2:11 PM
    About the spreadcheat I guess each time I download I can delete the fields with Município and leave only the Cidade that I will have what I want. Easy enough.
  • Ben
    Replied on January 6, 2016 at 2:22 PM

    2 approaches come to mind so that you do not need to download the fields each time manually.

    1st - for Google Spreadsheet integration

    - Instead of hiding the column, you can simply delete it. Once removed (by right clicking on column header) the same data will not be passed to the spreadsheet by the integration and if you download the Excel file from it, it would not hold the same. This would mean that after that initial removal of the field, no more removals would be needed.

    2nd - using Excel Report

    Unlike getting Excel from the Submissions Panel, the Excel Report allows you to select what are the details that you want to see in it once it is downloaded. This makes it a nice option if you are interested in the same, especially since a link is created from which you can get the latest version of the submissions in the same layout as you had selected, making it easy to be grabbed by some software, etc.

    You can see more about the report here: How to create an Excel Report?

    Of course if you have any questions, do let us know Pedro and we would be happy to assist with the same :)