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 to include submission ID in Excel Reports?

    Asked by caroberts 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?

    Reports excel submission id add submission
  • Profile Image
    JotForm Support

    Answered by NeilVicente 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

    Answered by geminienergy 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
    JotForm Support

    Answered by BDAVID 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

    Answered by geminienergy 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
    JotForm Support

    Answered by jonathan 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.