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 can I include the submission ID in an excel report?Asked by Ryan Cantor on January 19, 2015 at 07:04 PM
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?
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:
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?
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.
Submission ID option is now included in reports.
Thank you very much for your suggestion