How can I get the Submission ID in either XLS, CSV or any other report?

  • Profile Image
    timthornbrough
    Asked 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
    aytekin
    Answered 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
    timthornbrough
    Answered 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
    timthornbrough
    Answered 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
    aytekin
    Answered 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.