What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Can we use a Unique Question with a Quick Tools Number Field?Asked by farmcreditIL on August 17, 2015 at 11:49 AM
We would like to use a Quick Tools number field to assign a minimum and maximum value, but we also want this field to be our Unique Question (it's a form ID). What we're finding is the Quick Tools number field doesn't show up as an option for the Unique Question in the Preferences section. We are forced to make it a text field and then assign it to be numeric. However, then we lose the flexibility of assigning a minimum and maximum value.
I tried deleting the field and search for a widget that might offer more capability. Found a Unique ID widget, but it said I had to delete what was there already. I did. But it kept giving me the same message.
Can you help us. We are sending out a mailer to each of our customers with a Unique ID that they must enter to order their free anniversary gift.
Unfortunately, it is not possible to use the number field in our quick tool to have a unique submission.
If your user will be entering the number, the Unique ID field would not be suitable as it is a hidden field.
However there is a work around you can try using both the number field and a text box and use conditions to get your desired result.
Please follow the steps below:
1. Create the Number Field and the Textbox field:
2. The text field should be made hidden and Read-Only:
3. Select "Conditions" on your toolbar. Select "Update a form field value" Condition:
4. Create the following Condition:
5. You would then set the Unique Submission to the Textbox:
This condition would then allow the unique submission to be based on the information that was entered in the number field.
You can view my sample form here: http://form.jotformpro.com/form/52285871579975
The number field is not hidden to show the condition working. The minimum number is 15 and the maximum is 30.
I hope this helps, please inform us if you need further assistance.
I tried what you said, but it's not working. I think you may have it turned around. We want the Order ID# field to be the unique question so they cannot submit a form with the same Order ID# more than one time. We have there also to be a minimum value (10000) and a maximum value (55500) for the Order ID#. So the Order ID# field must be a text field to allow me to choose in Preference the option to make it a Unique Question. Then the hidden text field with conditions that you mentioned, I tried that with the min and max number, but it's not working. Can you look at what I've done.
I took a look at your form and there are three aspects that would need to be changed.
You would change your Order ID number field to a number field and set the minimum and maximum values.
For the condition, you would select "All Fields" and Click on the "Order ID" field.
You would then set the Unique Check as your Unique Question:
I created a cloned version of your form and made the changes: http://form.jotformpro.com/form/52286655862971
Please feel free to clone this form to your account.
I tested your clone of our form, and it's allowing me to enter the same Order ID# more than one time. I filled out the form once with an Order ID# of 12345 and submitted. Then I filled out another form and entered 12345 and it allow me to continue filling it out. Your first example didn't do this.
That is correct, all form limits are not shown/tested until the user attempts to submit the form, it would be at that time, that the user receives that error message.
An alternative option, would be to create two forms, the first would ask the user for their Oder ID#, using the same setup and conditions as the current form. The user would then submit that form and be redirected to another form that contains the remaining fields.
This way if they submit the Order ID# before completing the remainder of the form.
To achieve this, you would need to create a Custom URL Thank you page that would lead your users to the next form. Please view the following guide: https://www.jotform.com/help/38-Redirecting-Users-to-a-Different-Page
You can also change the submit button text on the first form to "Next"
Please inform us if you need further assistance.