How to Add Custom Unique IDs to your Form Submissions?

Last Update: September 7, 2016

If you need an ID like "ISBN-0015" on your records, now you can accomplish this with our new "Unique ID" field. It's located under 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.

JotForm automatically increases this number by an increment for every submission received, so you won't have to do anything.

To add a Unique ID , click on More Fields button and then type "Unique ID" or part of it, then click on it or drag and drop it to your form. Screenshot below:



You can also customize this number. Normally, it will work its way up from the default value, but if you need to customize this id,  we have added three properties for this tool to make it easier for you. When you select this field you'll see these properties on the toolbar.


Current Index:

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 same IDs on different submissions.


Prefix:

Prefix can be 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 an hypen on your prefixes but it's better for readability. For instance:  "UID-15"  >  "UID15" 


Number Padding:

This feature will fix your IDs to the same length by putting "0"s before the ID value. For example, lets 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.

A useful application of Unique ID is explained on this guide: http://www.jotform.com/help/255-How-to-setup-folders-using-UniqueID-in-Dropbox


37 Comments...


   
convenus (March 30, 2011 at 01:48 PM)

Brilliant addition - thanks Simon


   
mov2nite (March 30, 2011 at 05:41 PM)

adding barcode based on it and it will be perfect ;-)

Pat


   
mov2nite (March 30, 2011 at 05:42 PM)

Barcode: can be easily add if we can change the family font for example


   
Heeschen (April 01, 2011 at 10:53 AM)

great feature!!!! many thanks. Marc


   
tecladigital (April 01, 2011 at 11:43 AM)

Very nice. I try it yesterday.


   
camtoshow1 (April 06, 2011 at 01:20 PM)

You're almost out of space! ???


   
tamoonoy (April 11, 2011 at 02:19 PM)

ขอบคุณสำหรับสิ่งดีๆที่ใช้ง่ายและสะดวกขึ้น


   
prince786 (April 21, 2011 at 12:17 PM)

I can't get the unique id to display in the subject field of the email alert?? just comes up blank - any ideas?

View Answer


   
mmarlowe (April 24, 2011 at 09:34 AM)

Unique ID changes during an EDIT, which means it is not truly Unique... At least not for most needs......

View Answer


   
otabo (April 24, 2011 at 12:04 PM)

Wahoo!


   
tourkick (May 03, 2011 at 01:46 PM)

Can you just make a Unique Submission ID for me?

For example:
-Allow me to start with a letter or number
-Able to pick how many letters then how many numbers then how many letters then how many ....
-Ability to limit ID's entire length (e.g. 6 characters max)
-Ability to be unique to just that form or to all of my JotForm forms for each user account or unique to ALL users' accounts


I'd REALLY appreciate it. Thanks. :)

View Answer


   
PoppiesBlooming (May 10, 2011 at 05:25 PM)

LOVE this feature! We are so thankful for your service. You have obviously put in a LOT of hard work and it shows and has definitely paid off! Thank you!


   
cl58tools (June 13, 2011 at 04:47 PM)

Great feature! Could you possibly add a feature to allow each ID to be randomly generated (of a length determined by the user) instead of always being consecutive numbers increasing by one?

View Answer


   
GMScott (June 19, 2011 at 03:48 PM)

Question concerning the Unique ID?

1. I have created a review form with a Unique ID.
2. I have created a Response form for the "Reviewee" to respond to the inital review.
3. I would like to "link" or somehow attach the Response Form to the initial Review so that the Responder can see what they are responding to while completing their Response form. Hopefully you can follow that!

Please be gentle, I did search the forum for a similar question/answer but did not find one or did NOT understand if I did find it!

Thx for your help!

View Answer


   
GMScott (June 21, 2011 at 09:30 PM)

Hey Wayne,

Thanks for getting back to me. Nice homework in researching my e-mail domain, unfortunately I am creating these forms for a different domain and am not sure that your solution will work and I'm still trying to figure out the workflow.

I think I can describe hopefully a more "doable" situation for what I need and would love your guidance and help.

1. Restaurant selects their Restaurant Name and/or Review Event Date from a drop down and then enters their e-mail to receive the password for the Response Form. (I guess a separate Submit form needs to be created)

2. An e-mail is then sent to them from the Submit form with info on how to open the Restaurant Response form.

3. On my website I would like them to enter the password received AND/or the Unique ID which would then bring up BOTH the completed Review Form and the Restaurant Response Form. (ultimate wish is to present both the completed Review Form & Restaurant Response Form side-by-side) This would allow them to respond to what was actually reviewed without having to flip back & forth between either two web pages or their e-mail & the Response Form.

Any help would be greatly appreciated, along with simple (very simple please) step-by-step instructions!

THX Again!
Jerry

View Answer


   
concepts360im (December 16, 2011 at 12:17 AM)

Hi, I have a question, I placed a unique ID on my form and I understand that it is sequential. However, when I checked the submissions, I found out that the Unique ID skipped No. 7, so now I have 1-6, then 8. How do I go about this? Thanks!

View Answer


   
speairs (January 25, 2012 at 11:22 AM)

is it possible to have multiples of one ID. Example: if the Primary registree has a guest or many guests (family members) whoes info I need to tie together.
I would think i might look like this: 10000-1, 10000-2, 10000-3
Thanks for your help

View Answer


   
welsweb (March 09, 2012 at 12:08 PM)

Is there a way to make this Unique ID get pushed to Authorize.net as the Transaction ID? Auth.net is expecting a value there. Tanks for your help! Oh so close!

View Answer


   
gharris (June 20, 2012 at 01:44 PM)

Is it possible to display this field on the form?

View Answer


   
Antonio (June 26, 2012 at 06:11 PM)

I am using the last 4 digits of the provided phone field as the Unique ID. So far, the user needs to imput the last 4 digits in a separate field. Would it be possible to have an hidden field with a code to collect the last 4 digits of the provided phone number? Thanks in advance.

View Answer


   
nlazarre (September 07, 2012 at 02:09 PM)

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

View Answer


   
motonation (January 17, 2013 at 07:10 PM)

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.

View Answer


   
vicheca (June 12, 2013 at 11:25 AM)

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?

View Answer


   
cooplenew (July 11, 2013 at 08:16 PM)

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


   
cairorunners (October 19, 2013 at 12:54 PM)

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

View Answer


   
NejcF (December 03, 2013 at 09:58 AM)

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

View Answer


   
snwinfo (January 06, 2014 at 06:36 PM)

love it, perfect thanks !


   
marisolfun (June 24, 2014 at 04:40 AM)

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

View Answer


   
dorsetholidaylets (November 01, 2014 at 03:44 PM)

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

View Answer


   
hvi (December 29, 2014 at 12:51 PM)

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?

View Answer


   
Waddys1 (January 08, 2015 at 12:57 AM)

Brilliant that you


   
mwlim (May 07, 2015 at 04:03 AM)

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}

View Answer


   
grade4pagasa (November 04, 2015 at 03:12 PM)

is there a way to reset the Current Index back to zero (0) if a certain condition is met?

if none, can i ask for a Feature Request?

View Answer


   
TCS_AJAY (December 03, 2015 at 11:26 AM)

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

Thank you
ajaypal

View Answer


   
ElisaSan (March 03, 2016 at 04:37 AM)

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)

View Answer


   
tinyfootprints (April 03, 2016 at 09:49 PM)

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.

View Answer


   
iancurtis (July 20, 2016 at 04:25 PM)

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

View Answer


Send Comment