How to include submission ID in Excel Reports?

  • caroberts
    Asked on November 29, 2014 at 7:51 AM

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

  • NeilVicente
    Replied 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.

    How to include submission ID in Excel Reports? Image 1 Screenshot 20

     

  • geminienergy
    Replied on May 7, 2015 at 5: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?

  • David JotForm Support Manager
    Replied on May 7, 2015 at 6:34 PM

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

    How to include submission ID in Excel Reports? Image 1 Screenshot 40

    However, you can use the Unique ID widget: 

    How to include submission ID in Excel Reports? Image 2 Screenshot 51

    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:

    How to include submission ID in Excel Reports? Image 3 Screenshot 62

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

  • geminienergy
    Replied on May 7, 2015 at 6: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?

  • jonathan
    Replied on May 7, 2015 at 7: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.