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.
Field ID's in Excel exportAsked by Joeri on June 26, 2015 at 04:46 AM
Is it possible to export the submissions to excel, using the unique field ID's as the header of the columns?
Does the unique field ID change when I change the field label or the fields position on the form afterwards?
Not sure if I understand your concern visually. The column headers in the excel submission will be based from the Form Field name.
Here's a sample form, I added the widget Unique ID. I made a test submission. In the Submissions page, you can set what fields to be shown.
The name of the widget is "Unique ID". In the grid list, you'll see in the column name its "Unique ID".
If I misunderstood you concern, please provide us more details of what you would like to accomplish. We'll wait for your response.
It would help me a lot if the headers in the downloaded Excel are based on the Field ID as displayed here:
This way, the further processing of the Excel-file is independant of the field name or position in the online form.
Is this possible?
Unfortunately, it is not possible to automatically set the column headers of the excel submission to use the field ID.
However, there's two method that you can use to do this.
Method 1: After you download the excel submission, manually edit the columns and match it with the field IDs.
Method 2: Manually change the form field name to the field ID, but the field name to be displayed in the live form will be the field ID. However, you can bypass this by using CSS to display the actual name instead of the field ID, but the field ID will still be shown in the excel file and in your submissions page.
I would recommend using method 1, method 2 is a workaround too long and is not really convenient to go further on that.
I hope that gave you an idea on how to proceed.