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 can I get the Submission ID in either XLS, CSV or any other report?

    Asked by timthornbrough on November 22, 2010 at 09:36 PM

    I can see this number in the Submissions area, but cannot get it included and any of the reports.  I would like to use this field to only read in new submissions to the database.  Thanks. -Tim

  • Profile Image
    JotForm Founder

    Answered by aytekin on November 23, 2010 at 10:47 AM

    It is currently not available on Reports. But you should be able to get it if you use the CSV or Excel option on the Submissions page.

  • Profile Image

    Answered by timthornbrough on November 23, 2010 at 02:43 PM

    No, just tested to be sure.  I can see the submission ID in the submission table, but doesn't appear in either the CSV ro Excel downloads.  Does show the submission date field, just not the submission ID.

  • Profile Image

    Answered by timthornbrough on November 23, 2010 at 06:17 PM

    I found the {ID} field, which is the Submission ID on the Notification email message.  It was at the bottom of the field chooser.  Would there be a {date} or {time} for the submission date time as well?

  • Profile Image
    JotForm Founder

    Answered by aytekin on November 24, 2010 at 08:04 AM

    Reports don't have it but Submissions page has it.

     

    Choose that and then click on the "CSV" button at the bottom to download it.