How to include submission ID in Excel Reports?

  • Profile Image
    caroberts
    Asked on November 29, 2014 at 07:51 AM

    Can you add Submission ID # as one of the fields captured in the Excel Report for a form?

  • Profile Image
    NeilVicente
    Answered on November 29, 2014 at 11:18 AM

    If by "Excel Report" you're referring to the file generated by the "Download as Excel" button in the submissions page, then the answer is a resounding "Yes".

    Simply click the Settings (gear) button then tick the "ID" checkbox to have the submission IDs be included in the Excel file.

     

  • Profile Image
    geminienergy
    Answered on May 07, 2015 at 05:17 PM

    Hi guys, this works, yes, but what if we want to get submission IDs from a report generated from the reports options on the main page (so a link to an excel report)?  Can we include the submission ID there?

  • Profile Image
    BDAVID
    Answered on May 07, 2015 at 06:34 PM

    The submission ID is not be included in an Excel Report:

    However, you can use the Unique ID widget: 

    Here is a guide that might be of your interest on how to custom Unique IDs: http://www.jotform.com/help/79-Add-Custom-Unique-IDs-to-your-Form-Submissions

    In this way, once added to your form, it will be shown in the Excel Report:

    If you need anything else, please open a new thread, we will be glad to assist you.

  • Profile Image
    geminienergy
    Answered on May 07, 2015 at 06:48 PM

    Hi BDavid,

    Thanks - understand that the submission ID is not included in the excel report, but the Unique ID option doesn't seem like a suitable option, as we already have a unique ID built into the form...the submission ID.

    At this time, our form is being submitted to a MySQL database and the submission ID comes through fine on that side during the PHP scripting. 

    It just seems logical to me that JF would include that as an option on the reports themselves, as it's already part of the reports from the submissions page.  Can you add this as a suggestion for future feature?

  • Profile Image
    jonathan
    Answered on May 07, 2015 at 07:50 PM

    @ geminienergy

    I created a separate thread for the request here http://www.jotform.com/answers/566181

    We will attend to it shortly.

    Thanks.