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 do u add Unique ID of the form to your reports/excel sheet?

    Asked by Nixor on January 07, 2011 at 11:58 PM

    We are trying to identify our applicants only through their unique form ID. 

    In the Excel report or any reports the Unique ID does not come. There is every option but that. How do i make it appear ? 

    Reports
  • Profile Image
    JotForm Founder

    Answered by aytekin on January 10, 2011 at 08:37 AM

    Unique ID is possible. Just enable the "Submission ID" field on the submissions.

  • Profile Image

    Answered by kiranshah3000 on February 12, 2011 at 03:23 AM
  • Profile Image

    Answered by serkan on March 12, 2011 at 07:18 AM

    This problem has been fixed now. Thanks for reporting.

  • Profile Image

    Answered by kiranshah3000 on March 12, 2011 at 07:45 AM

    Thanks for looking into this but there is still an issue as most ID numbers are greater then 15 digits which is the maximum Excel can show as "number". Is it possible for the reports to convert these to text of some sort so we can see the full number otherwise it just truncates after 15 digits which becomes unusable.

    Thanks.

  • Profile Image
    JotForm Support

    Answered by liyam on March 13, 2011 at 01:02 AM

    Hello,

    This is an MS Excel autoformatting feature.  Not sure if there can be any preformatting where the excel will set the ID row as text prior to downloading to eliminate the conversion of the contents in ID.

    What you can do for now as a work around with this is download your report as CSV, open it as a text file.  Then open a blank Excel and format the row where the ID is going to be put at as "text".  copy all inside your CSV text file and paste it to excel.

    I will also submit a ticket for this.

    Hope this helps

  • Profile Image

    Answered by serkan on April 14, 2011 at 07:48 AM

    @kiranshah3000 Have you tried our new feature? http://www.jotform.com/help/79-Adding-a-Custom-Unique-ID-To-Your-Form

  • Profile Image

    Answered by MEUStrasbourg on January 07, 2016 at 03:25 PM

    Where do I enable that? I don't see the "enable submission ID" option in the submissions field. I have IDs I just don't get the numbers on a column in the excel output. 
  • Profile Image
    JotForm Support

    Answered by jonathan on January 07, 2016 at 08:49 PM

    @ MEUStrasbourg

    We will answer your question here http://www.jotform.com/answers/739306