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

  • Profile Image
    Ryan Cantor
    Asked 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
    Kiran
    Answered 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
    ryanjcantor
    Answered 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
    ashwin_d
    Answered 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
    Ryan
    Answered 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
    ashwin_d
    Answered 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
    alp_deniz
    Answered 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