- farmcreditILAsked 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.
- ShadaeAnswered on August 17, 2015 at 02:14 PM
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.
- farmcreditILAnswered on August 17, 2015 at 03:48 PM
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.
- ShadaeAnswered on August 17, 2015 at 04:20 PM
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.
- farmcreditILAnswered on August 17, 2015 at 04:39 PM
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.
- ShadaeAnswered on August 17, 2015 at 08:20 PM
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.