JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
How to have new fields on the form appear last in Excel ReportsAsked by afcpool 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?
excel additional fields additional Without
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:
If the above instructions do not apply to the Excel software you use, these instructions should help:
If you need any further assistance, please let us know.