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.
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?
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.
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.
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.
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?
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.
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?
how to create USER ID by adding the first 4 characters of firstname + last 4 digits of IC number or Phone Number
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.
Como hago el campo visible? ya que en avanzado no muestra la opcion.
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?
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?
CAN WE ARRANGE UNIQUE ID AS PER FIELD OPTION IN IT
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?
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!
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?
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?
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
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
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.
Is there any way to have the unique ID show on the form that is emailed to the submitter?
Thanks!
Brilliant!
Thanks
I can no longer find this widget as an option in the form elements.
Thanks - that was very helpful!
Cheers
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
Thankyou was really helpful
is there a way to put the unique id number added to the spreadsheet attached to the form.
Is there a way to show this number to he customer on screen at time of submitting ?
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!
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
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.
how do i let users of the form see the unique id on the form as well as i do on the submission page
Hi,
Great info. I learned a lot of things.
Thanks
Thanks for posting useful info
There is an option to be visible on the form or read-only ?
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.
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)
Please give the solution to my question. I would be greatly appreciate if you reply asap.
Thank you
ajaypal
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}
Brilliant that you
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?
Is there a way of using the Unique ID in a calculation and a way of showing the Unique ID on the form?
i like this feature: adding barcode .
will this feature be added into:
http://www.keepdynamic.com/dotnet-barcode/barcode/pdf-417.shtml
love it, perfect thanks !
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
i want this unique number to appear to the user in the thank you page how can i do this ?
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
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?
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.
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