Browse Article by Topics

unique id auto increment auto numbering id generation form builder power tools

Related Articles

Related Forum Questions

Home / Advanced Features / Add Custom Unique IDs to your Form Submi... Print

Add Custom Unique IDs to your Form Submissions

Last Update: April 10, 2012

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 Power Tools 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. 





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.

You have already voted for this item. Your vote was: 1

18 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?

See Answer for This Question...

   
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......

See Answer for This Question...

   
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. :)

See Answer for This Question...

   
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?

See Answer for This Question...

   
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!

See Answer for This Question...

   
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

See Answer for This Question...

   
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!

See Answer for This Question...

   
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

See Answer for This Question...

   
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!

See Answer for This Question...

Send Comment