What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

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.


  • Profile Image

    Field ID's in Excel export

    Asked by Joeri on June 26, 2015 at 04:46 AM

    Hi,

     

    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?

     

     

    Greetings,

    Joeri

    excel field ID in Submissions label unique
  • Profile Image
    JotForm Support

    Answered by Charlie on June 26, 2015 at 10:22 AM

    Hi Joeri,

    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.

    Thanks.

  • Profile Image

    Answered by JoeriVanderVaet on June 26, 2015 at 10:30 AM

    Hi Charlie,

    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?

  • Profile Image
    JotForm Support

    Answered by Charlie 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.

    Thanks.