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.


  • Profile Image

    Limiting submission based off a one time unique serial key from a list.

    Asked by webusermy on April 09, 2013 at 09:44 PM

    The reason I need this function/feature is because I need to run a very private and confidential survey, therefore I can not limit the submission base off something identifiable like their names, user id, emails etc. as doing so would affect the honesty of the participants in fear that they could be identified. Blocking via cookie and IP address is not an option as there is a high chance that more than one users would be using it on a shared network, with the same IP address.

    This survey also needs to be limited to only one submission per user so that it can not be abused with multiple submissions as to skew the data.

    What I would want to have is, upon submission of a form, users are required to enter a unique serial key that will be provided to them in a non identifiable manner. The form would then validate the key with a list in which if the key is valid, the form would be submitted as per normal, and the key will be made invalidated.

     

    Example:

    User submits form with the entered serial key value "SERIAL01".

    System will look in a pre-populated list for the serial key value "SERIAL01". If the value exists, the form submission will proceed, and the key value "SERIAL01" will be flagged, stopping it from being used a second time with a warning/alert that the key has already been used. (customised text would be great) If it does not exist, a warning/alert will be shown stating that the key does not exists. (customised tet would be great)

     

    unique limiting Emails Submissions survey
  • Profile Image
    JotForm Support

    Answered by Welvin on April 10, 2013 at 05:02 AM

    Hi,

    Unfortunately, we don't have such function available. I think using the Limit Form based on a Unique Question function will work. I've made a workaround.

    Check this form: http://form.jotformpro.com/form/30992334288967

    Using Show/Hide Condition, if "Serial Number" is entered correctly, the next button will show and they will be able to proceed. Although, they can repeat the process, but they will not be able to submit the form since Serial Number is limited or is for single use only based on the settings.

    You will have to add the Serial Numbers and use them in the conditional logic (Show/Hide Condition);

    Please try to submit the form (twice) using one of the Serial Numbers provided in the image. You will see the error.

     

    Thanks

  • Profile Image

    Answered by webusermy on April 11, 2013 at 12:26 AM

    Greetings,

    That works great. Unfortunately, I am expected to be using it for a potential of 3,000 responses.. and that will only continue to grow as the organisation grows. It will just mean some extra work having to repeat the serial number field 3,000 times or more, but at least it's a possible work around for now.

    Thank you very much for this workaround suggestion! :)

  • Profile Image
    JotForm Support

    Answered by Welvin on April 11, 2013 at 08:48 AM

    Hi,

    My apologize for not coming back that quick!

    Yes, that's one of the factor to consider. Having them (serials) to enter into the Conditional Logic one by one will require extra effort or additional hours. The advantage of copy-pasting them into a single area is always a good option.

    Anyway, I see that this is a good additional function aside from the given workaround. Let me forward this thread to our developers as a feature request. I can't say anything about the possibility of this function but if updates will be made, we'll surely let you know through this thread.

    Thanks

  • Profile Image

    Answered by webusermy on August 13, 2013 at 10:36 PM

    Greetings,

    It has been 4 months since this was last asked.


    Has there been any progress with regards to this function? Or the workaround will still need to be used?

    Many thanks!

    Kind Regards

  • Profile Image
    JotForm Support

    Answered by jonathan on August 14, 2013 at 01:29 AM

    Hi,

    I would like to inform you that the request for this function was already submitted to our dev team. This is still an Open feature request. 

    However, we will not be able to provide you any ETA or time table as to when this will be done. As of now, this is also not on the high priority list.

    You will need to use the suggested workaround for now.

    Thanks.

  • Profile Image

    Answered by webusermy on August 14, 2013 at 05:30 AM

    Many thanks for the respons.

    Good to hear that it's submitted to the dev team. The workaround is being used currently. It just saves us one week of man power work that's all. :)

    Cheers!

  • Profile Image

    Answered by webusermy on November 26, 2014 at 05:53 AM

    Greetings, it has been over a year since I last visit this issue.

    Has there been a fix for this? Or maybe even a faster way to input the serial number. I'm talking about 3000-5000 over submissions and unique serial ID. Keying them in manually one at a time is silly when in the world of IT there should be a function to be able to import via text document or something.

    Hoping to hear some good news so that I may actually use your product.

    Thank you and kind regards.

  • Profile Image
    JotForm Support

    Answered by Welvin on November 26, 2014 at 08:43 AM

    Our sincere apologies for not updating this thread. Unfortunately, we haven't heard any from our developers after your last reply. The request is still open, but let's be honest that the priority of this thread isn't that high. We have been updating our features and I think we have new ones, but the number is based on the priority and volume of request from the other users. But rest assured that this request won't be cancelled and if there are updates, you should know it via this thread. The only thing is that we can't give anyone a timeframe.

    Thank you for your patience and understanding on this matter.

    Regards

  • Profile Image

    Answered by webusermy on December 02, 2014 at 09:20 PM

    Greetings,

    Thank you for your response.

    As I have unfortunately not been keeping track with all the added features since I last looked into your product over a year ago, could I get an update from you or someone who can answer my inquiry?

    The the requirement I need here is to:

    1) Limit Submission to 1 per Serial Key

    2) Ability to import or add multiple Serial Keys at once

     

    As of a year back, requirement 1 has a work around that worked great from a functionality point of view. Requirement 2 on the other hand was the roadblock as the rules had to be set manually. Have there been any update on requirement 2? Maybe a way to quickly clone/duplicate rules? Even that would speed up the process greatly as I would then only need to key in the serial numbers manually, as opposed to having to actually create the rules individually.

     

    Thanks for the assistance.

    Kind Regards

  • Profile Image
    JotForm Support

    Answered by ashwin_d on December 02, 2014 at 11:46 PM

    Hello webusermy,

    Unfortunately, we have not received any update form our back end team yet on this feature request. 

    Have there been any update on requirement 2? Maybe a way to quickly clone/duplicate rules?

    Well it is now possible to duplicate conditions. Please check the screenshot below on how to duplicate conditions:

    You may also like to take a look at our new addition in condition where you can add comma separated values with "Contains" condition to match the text. Please check the screenshot below:

    Hope this helps.

    Do get back to us if you have any questions.

    Thank you!