Browse Article by Topicsunique ID id auto increment auto numbering id generation form builder widgets
- What is a Form Builder?
- Print Button on Forms
- The Importance of Form Widths
- How to Set Unique Submissions on a Form
- How to Add Custom Unique IDs to your Form Submissions?
- How to Create a Grid Listing Report?
- How to find field IDs and names
- Hide or Show Multiple Fields at Once
- How to Remove Field Labels in a Form
- How to Strip Payment Labels and Separate Payment Info on Email Alerts
Related Forum Questions
- How can I resize Autocompleted Address widget fields?
- How can I generate a grid report from user input data?
- Phone field: Fill Mask Validation is no longer available in the version 4 builder
- How can I make sure that Submission ID is the on the first column of Google Spreadsheets after integration?
- How to make Percentage widget read-only?
- Is there any way to recover some information that has been deleted?
- Is there an available tutorial for the "Save Forms and Continue Later" workaround for Version 4?
- Centering value in the Sliders with Calculated Result widget
- How to create a 2-column form with Input Fields on the left and plain text on the right?
- My customer is receiving a "Validation Error" when she tries to submit
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 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 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"
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:
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:
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