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

    How can I include the submission ID in an excel report?

    Asked by Ryan Cantor on January 19, 2015 at 07:04 PM

    I'm checking the status of this as it has been 4 years and I need this functionality to be implemented. I need to be able to include the submission ID in a excel report that is generated.

     

    please advise.

  • Profile Image
    JotForm Support

    Answered by Kiran on January 19, 2015 at 07:28 PM

    You can enable the submission ID from the list of fields in Form Submissions view so that the submission ID can also be included in the exported report to Excel.

    Hope this information helps. Please get back to us if you need any further assistance.

    Thank you!

  • Profile Image

    Answered by ryanjcantor on January 19, 2015 at 08:07 PM

    Hi Kiran,

     

    I understand how to add it within the submissions panel, when I am logged in via Jotform.com via a web browser, and how then if I manually export I can have it.

     

    What I have are thousands of submissions, and a built in report that publishes to a URL. I need the submission ID to be able to be included in that report that I've built within jotform. I pull that report automatically into a database, and need the ability to create the edit URL. To create the edit URL I need the submission ID.

     

    I am an extremely heavy user and promoter of JotForm. This has been a feature request for over 4 years, from reading the forum.

     

    Can you please implement either system wide, or allow me to beta test the functionality for you?

    Ryan

  • Profile Image
    JotForm Support

    Answered by ashwin_d on January 19, 2015 at 10:35 PM

    Hello Ryan,

    If I understand your question correctly, you want to get the submission ID in the report. Is that correct? 

    Unfortunately it is currently not possible to add submission ID in reports. Let me send a feature request to our back end team. We will get back to you as soon as we have any update from them.

    For now, I would suggest you to download the submissions manually in excel file. Please check the screenshot below:

    Thank you!

  • Profile Image

    Answered by Ryan on January 19, 2015 at 11:18 PM

    I am well aware of the ability to do this manually.

     

    however, at this time that is not an acceptable solution.

    4 years ago and many times since then, this has been the standard response. We will send it to the developers for discussion.

    this feature is missing and drastically increased the value of the product. What can be done to implement a solution or workaround quickly?

    ryan

  • Profile Image
    JotForm Support

    Answered by ashwin_d on January 20, 2015 at 01:03 AM

    Hello Ryan,

    I can understand but decision on any feature request is taken by our back end team. Implementation of feature request it completely depends upon the feasibility and priority of our back end team.

    Please be noted that submission ID is a unique identifier and it can be a security issue. There must be a reason on why the feature is not yet implemented. I have already sent a feature request to our back end team and lets us wait for their response.

    I cannot think of any work around as it is not possible to make any changes in the report output. The only possibility I can think of is to manually download the excel report.

    Thank you!

  • Profile Image
    JotForm Support

    Answered by alp_deniz on May 20, 2015 at 09:05 PM

    Good news!

    Submission ID option is now included in reports. 

    Thank you very much for your suggestion

    Kind regards