How can I include submission {id} into the Excel export?

  • Profile Image
    OIMSCSMD
    Asked on December 06, 2010 at 09:36 AM

    ONe of the functions we are using Jot Form for is a intake Bug Report tool, we have a different workflow management tool, BMC Remedy, we have to be able to crosswalk the id number (JotForm) to the ticket number (Remedy).

    All we need is a seperate column with the ID number, the same that is generated in the notification emails...

  • Profile Image
    aytekin
    Answered on December 06, 2010 at 12:21 PM

    I think you can get it if you use the Excel icon on the "Submissions" page. That should include the ID field if you have enabled it on the Settings.

    It is not included on the Reports though. Only on the excel feed on the Submissions page.

  • Profile Image
    OIMSCSMD
    Answered on December 09, 2010 at 09:44 AM

    {id] is not included in niether the .csv nor the Excel spreadsheet. Can this be included.

  • Profile Image
    aytekin
    Answered on December 10, 2010 at 09:31 AM

    1. Select your form on My Forms page

    2. Click on "Submissions" button

    3. Click on "Settings" icon on the right side and enable "ID" field

    4. Scroll to the middle of the page and then click on the Excel or CSV icon.