Are there any alternatives to submission ID to be used for submission confirmations and reference?

  • Profile Image
    shmuelhonig
    Asked on January 21, 2014 at 11:45 AM

    Is there a way to generate a confirmation number to be included in email notifications, other than the Submission ID? The Submission ID is too long and cumbersome to be used as a confirmation number.  Thanks.

  • Profile Image
    ardy0689
    Answered on January 21, 2014 at 12:11 PM

    Thank you for contacting us. You could try using the Unique ID widget. This widget increments by 1 whenever there is a new submission. You can define a pattern like the illustration below:

     

    However, you still need to use the submission ID for cases like editing the form like below:

    http://submit.jotformpro.com/form.php?formID=12345678910&sid=256133380131238628&mode=edit

    If you require further assistance, please do not hesitate to ask. Thank you

  • Profile Image
    shmuelhonig
    Answered on January 21, 2014 at 03:36 PM

    Thanks!  I used the Unique ID Widget, and satrted the numbers at 1000.  The value shown in my Google spreadsheet, though, is "01/21/2014 10:01:00".  Any idea why that happened and how I can fix it?

  • Profile Image
    Cesar
    Answered on January 21, 2014 at 04:23 PM

    Hello, to understand the matter properly. The field of the Unique ID widget is giving you a date?

    At this time I have made a test on an example form with a UniqueID field. Then integrated that example form to Google Spreadsheet. This is how it currently displays the uniqueID:

    https://cms.jotform.com/uploads/image_upload/image_upload/global/23786_uniqueid.jpg

     

    I've also tested your cloned form and it appears to give the data properly. Kindly check that the unique ID has no type of formatting. 

    https://cms.jotform.com/uploads/image_upload/image_upload/global/23788_formatting.jpg

     

    Do let us know if the issue persists. Thank you.