- JoeriAsked 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?
- CharlieAnswered on June 26, 2015 at 10:22 AM
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.
- JoeriVanderVaetAnswered on June 26, 2015 at 10:30 AM
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?
- CharlieAnswered on June 26, 2015 at 11:42 AM
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.