JotForm User Guide / Advanced Features /

How to Add Custom Unique IDs to your Form Submissions?

How to Add Custom Unique IDs to your Form Submissions?

If you need an ID like ISBN-0015 on your records, now you can accomplish this with our Unique ID field. It's located under the Widgets section in the toolbox to the left. Just drag & drop this tool to wherever you want on your form. It will not be displayed to your customers but will show up on your reports and submissions page. 

To add a Unique ID, click on the Form Elements button, click on the Widgets tab, and then type Unique ID or part of it, then click on it or drag and drop it to your form.

The default Generation Method will be based on the Sequential Numbers. However, you can change this to Random Values through its properties:

The Prefix is available in both methods. It is very useful to categorize your IDs. You can add any string in front of your IDs, hence it will make it easier to search for specific IDs. For example, "UID-15" is a lot easier to find than plain "15". You don't need to use a hyphen on your prefixes but it's better for readability. For instance: "UID-15" > "UID15" 

When choosing Sequential Numbers, you can set the following:

Current Index

The Current Index displays the current value of your ID. You can use this feature to set a starting point for your IDs. For instance, if you were to write 1000 here, JotForm would start counting from 1000. One important thing to remember about this property happens when you start to collect submissions. If you set this property to a lower number than the original current index, JotForm will continue increasing the new value regardless of previous entries so you may end up with the same IDs on different submissions.

Number of Digits

This feature will fix your IDs to the same length by putting "0"s before the ID value. For example, let's assume that you are expecting 1,000,000 submissions for your form and you are using the "CID-" prefix for your IDs. If you don't use number padding, you'll end up with IDs like these:

CID-1

CID-12

CID-123

CID-1234

By using number padding, you can prevent this. 1,000,000 is 7 digits long number, so if you select "7" in the number padding field, JotForm will convert your IDs to these:

CID-0000001

CID-0000012

CID-0000123

CID-0001234

CID-0012345 

You'll always have the same ID lengths, hence it will be easier to organize your submissions.

When choosing Random Values, you can set the following:

Number of Characters

The Number of Characters means the number of random values that will be generated for each submission. While this option does not have any limit, we suggest not choosing to generate more than 18 characters.

Include Character(s)

The default is Numbers and Uppercase. However, you can choose to include Lowercase. To do so, just check the Lowercase option from the list. We highly recommend a combination of Numbers and Uppercase or Numbers and Lowercase.

A useful application of Unique ID is explained in this guide: How to Setup Sub-Folders in Dropbox Using the Unique ID Widget.


Contact Support:
Our customer support team is available 24/7 and our average response time is between one to two hours.
Our team can be contacted via:
Contact JotForm Support: https://www.jotform.com/contact/

Send Comment

70 Comments...

See all comments
  • Anita Massey

    Is there a way to link a person to a unique ID and the unique ID is associated and used for that person every time the person logs in?

  • sambonhamhorton

    Is there a way to have this information pulled through into the JotForm Tables?

    I've tried creating a new column and connecting it up but nothing seems to pull through.

  • daggarza

    How can I make the Unique ID appear to the user? I want them to be able to see the unique ID and copy it to use in my website.

  • farhad373804

    Am looking for a mechanism that when users visit my website and submit a form, they should receive a confirmation email with a unique QR code so that they can present that QR code to my office in order to get an Item. The user database will be saved on Spreadsheet.

  • PESJotForm

    Is there a way to enlist the sequential unique id number only if a certain field is selected? A condition to only allow the sequential number to be used if a certain condition is met?

  • subratakonardurgapur

    Is there a way for certificate verification? I have my training certificates that I issue to my students generated with an ID.

    Now, if someone types the ID, then details like Name, Course Undertaken, Grade appear.

    In other words, there is a search tab that inputs ID.

    Based on the ID, details of students appear.

    Only after entering ID, details of students can be accessed.

  • robinrenee.walton

    I want to create an online form so that each person who registers either selects or is assigned a personal identifier, and allows others to search for them by this number. I also want others to see what is on their public form, but hide their email. The email would be an embedded link where the person would receive a message like "You've received a Gift."

    Additionally, I want the identifier to stay with them through their purchases. For example, if a person clicks a link from my page to a vendor, then purchases something from that vendor, so that I get credit for that purchase. Is this possible?

  • miezayahaya

    how to create USER ID by adding the first 4 characters of firstname + last 4 digits of IC number or Phone Number

  • ofurie

    I love the number system but is there a way it can be shown after each person submits? For example, if I have 200 people filling this application. The first person to finish it will get a 0000 number and the next person 0001 and so on. I would like for JotForm to automatically generate the numbers for each person that fills out the form I'm creating.

  • SIMLAT

    Como hago el campo visible? ya que en avanzado no muestra la opcion.

  • Underbelly

    We have issued unique booking references to customers and would like them to include them on their form submission to avoid duplications. Is this possible, or is it only possible to restrict further submissions by cookie and IP address detail?

  • Kerry

    I find the unique ID widget very disappointing. I cannot put the unique ID on my PDFs. I cannot use it as a unique identifier for Save&Continue. I cannot feed it into another field and then pipe that field onto other forms.

    For us - we are trying to send JotForm documents to Docusign for legal signature. A unique ID would be very helpful for matching the docusign output to the Jotform PDF output. but we cannot do this. Is there any other way to create a completely unique ID so that forms do not get mixed up?

  • architectvaibhav

    CAN WE ARRANGE UNIQUE ID AS PER FIELD OPTION IN IT

  • sweechong

    I have converted the jotform from the pdf fillable form, however, when I creat a unique ID onto the jotform, it will not link to the original PDF form. is there a wasy to do it?

  • Ison_BJ

    Is there a way to have the unique ID go up when someone does an edit to their original submission and then submits the form again? I need a way to have the "edits" become a unique form entry. Thanks!

  • DiazDezignz

    I created the Unique ID and still get an error message that says "Order ID is missing from the form submission" via mobile submission. I do not get an error message via laptop. Help! What am I doing wrong?

  • Alias123

    My form's unique ID increments such as 3 to 5 to 7 to 9.. etc
    is there any way to change this back to incrementing from just by 1?

  • khassa02

    Unique ID doesn't appear for me either like NJEnrollment said back in Janurary. I'm not sure why it doesn't show up under Widgets

  • Bethlechem

    If i have 'n' unique fields in a form depending on the 'n' number of tickets chosen by the one who is registering can i increment the starting value for the subsequent unique fields

  • oracaopalavra

    Serial numbers are great. But what we really need is a hash code that can't easily be guessed. For instance, a unique hash based on date and time and user input details, and that the user receives as a unique code to request some information etc in the future.

    I had considered a code based on date/time and user email, for instance, but that would be pretty guessable. Even if I create an algorithm in the background that performs multiplications and substitutions that can still be decrypted.

    Random numbers don't help: there's a chance to entries get the same number.

    An MD5 hash or something in those lines would be awesome.

  • VillagesBabyBoomers

    Is there any way to have the unique ID show on the form that is emailed to the submitter?

    Thanks!

  • Outlocks

    Brilliant!
    Thanks

  • NJEnrollment

    I can no longer find this widget as an option in the form elements.

  • srachel

    Thanks - that was very helpful!

    Cheers

  • Psapca123

    Hello - is there a way to change the unique ID based on an answer to a form questions? For instance if some one chooses 6th grade I would like the number to start with a 6, etc.
    Thanks!
    Susan

  • vaastav

    Thankyou was really helpful

  • mavee89

    is there a way to put the unique id number added to the spreadsheet attached to the form.

  • WinnersRedemptionCenter

    Is there a way to show this number to he customer on screen at time of submitting ?

  • cbcadvisors

    Is there a way to only have the Unique ID increment if a certain criteria is met instead of always incrementing on every submission? Thanks!

  • RefillMyBottle

    Is there a way to install this plugin and attribute an ID even to the ancient submission or does it only starts with the submissions after the plugin is installed?
    tks

  • TIC_Municipal

    Alguien sabe porque no me aparece visible el campo de Unique ID en mi formulario.? lo agrego y veo que todo esta bien.. pero no lo logro hacer visible al momento de nuevos envios.

  • joepg

    how do i let users of the form see the unique id on the form as well as i do on the submission page

  • Mark Harmon

    Hi,

    Great info. I learned a lot of things.


    Thanks

  • Prabhu Ganeshan

    Thanks for posting useful info

  • iancurtis

    There is an option to be visible on the form or read-only ?

  • tinyfootprints

    Might it be possible for this number to show in the "Thank you" message pop-up after a form is submitted? This could be useful for clients, so that they can refer back to their form number when submitting further inquiries.

  • ElisaSan

    What is the html code that I should use (in the source code) in order to make the unique ID show up on the form? I have been able to make it show up, but then it was not unique, it was the same number every time, while the numbers that I received by email were increasing.

    I want the customer to see the unique ID and then use it as an order number in the communication with me.
    So, they need to see the unique ID and I need to receive it in my email so I can connect the details that were filled out in the form with the customer that is contacting me (or depositing me money in my account)

  • TCS_AJAY

    Please give the solution to my question. I would be greatly appreciate if you reply asap.

    Thank you
    ajaypal

  • mwlim

    can we add in the date to the unique ID? For example.

    Unique ID - DATE - {User input capture from a text box in the form}

  • Waddys1

    Brilliant that you

  • hvi

    Is there a way to change the prefix based on a required field answer? For example, our Product Category field has nine possible answers and we would like to use a 2-digit prefix based on which Product Category is selected.
    Or would it be easier to assign the 2-digit code to a new field based on the Category selection and append the Unique ID, thus creating a third field?

  • dorsetholidaylets

    Is there a way of using the Unique ID in a calculation and a way of showing the Unique ID on the form?

  • marisolfun

    i like this feature: adding barcode .
    will this feature be added into:
    http://www.keepdynamic.com/dotnet-barcode/barcode/pdf-417.shtml

  • snwinfo

    love it, perfect thanks !

  • NejcF

    I cannod add any Unique IDs to my forms. Power Tool were renamed into Quick tools.

    Why?

    On old form i can still manage Unique ID but a can not add it.

    Please send me anwser ASAP

  • cairorunners

    i want this unique number to appear to the user in the thank you page how can i do this ?

  • cooplenew

    Só pode acrescentar 1 deses IDs, gostaria muito que você desenvolvese um comparador de numeros e letrar com traços como se fosse uma chave serial de tivação do tipo:

    EDR-GDT-OPI-FGR (em letras)
    e
    123-4322-546-768 (em números)
    ou
    RT4-TE3-GH6-43J-43K (em letras e números)

    por favor crie um com esses aspectos

  • vicheca

    Hi, I wanna see the unique ID when I'm filling my form, after I use the source code I cant modify directly in the same field, I copied all the code in notepad and modified, but now how can I put in my JoitForm to see the unique ID. In another hand, can I use the Unique ID to search the form and add informtion?

  • motonation

    Is there any way that a Unique ID could have an option to not be hidden during the form submission? I can always look it up when I'm done, but this would save me time in some cases when I'm using a form for internal use within my company only.

  • nlazarre

    when I try to add a unique ID I get this message You cannot add more than one Unique ID. Please delete the existing one first. but I cannot find the existing field and it is not showing up as an option in grid reports