How to have new fields on the form appear last in Excel Reports

  • Profile Image
    afcpool
    Asked on April 06, 2016 at 11:13 PM

    I erred in the past in deleting a field from a form instead of disabling or hiding it, so that my Excel reports were out of sync for submissions after that change.

    I now need to add some fields, and am concerned that I will get a similar result. Is there any way to force new fields to become the last columns of the form, even if they aren't the last fields in the form?

  • Profile Image
    Boris
    Answered on April 07, 2016 at 03:20 AM

    I'm afraid that our Excel reports, as well as any other kind of reports, will list the fields in the same order that they are placed n the form. If newly added fields are placed at the middle of the form, the Excel report will be created with these new fields at the middle.

    If you want for the Excel report to be generated with new fields being last, you will need to add them to the end of the form.

    Alternatively, once you download the Excel, you can also reorder the columns as described in this post:

    https://www.ablebits.com/office-addins-blog/2014/01/23/swap-excel-columns/

    If the above instructions do not apply to the Excel software you use, these instructions should help:

    http://www.wikihow.com/Move-Columns-in-Excel

    If you need any further assistance, please let us know.