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

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

    Asked by shmuelhonig 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.

    email email notifications submission id thanks
  • Profile Image
    JotForm Support

    Answered by ardy0689 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

    Answered by shmuelhonig 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

    Answered by Cesar 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.