I also need to validate visitors' data submissions for uniqueness.

  • rwaldenjr
    Asked on August 26, 2017 at 2:36 AM

    3.  I also need to validate visitors' data submissions for uniqueness.

  • John_Benson
    Replied on August 26, 2017 at 3:21 AM

    You can enable the Unique Question feature to your form. This will prevent duplicate submissions using the same data for unique entries. Please check this guide to learn more: https://www.jotform.com/help/223-How-to-set-Form-Limits-Based-on-a-Unique-Question

    If you have any questions, please let us know. Thank you.

  • rwaldenjr
    Replied on August 27, 2017 at 3:02 AM

    That's a great tip John! I wasn't aware of that widget. And, it would do exactly what I want, except that it says it doesn't work on the two date types I'm most interested in - postal addresses, and name fields. Any idea if these are in the works, and when they might be available? Also, do you know of any possible work-arounds for unique postal address validation?

  • Kiran Support Team Lead
    Replied on August 27, 2017 at 4:31 AM

    Unfortunately, verifying for uniqueness using Name or address fields is not possible and there is no ETA for the implementation. Do you mean to check for the uniqueness based on two different fields i.e., Name and Address? Please confirm so that we can send a feature request to our backend team.

    A workaround can be adding Name and Address fields to Short text field by using a condition and check for uniqueness. However, this may not work since even a single space or character can make the rule in the condition to fail. If you want to give a try, you may add a separate Short text field entry to the form and add the condition as shown below.

    I also need to validate visitors data submissions for uniqueness Screenshot 30

    You may select the new Short text entry field as the unique question field on the form settings.

    I also need to validate visitors data submissions for uniqueness Screenshot 41

    Hope this information helps! Please get back to us if you need any further assistance. We will be happy to help. 

  • rwaldenjr
    Replied on August 27, 2017 at 4:55 AM

    Thanks for the work-around suggestion John! No, I'm not asking that the feature request include a double validation for Name and Address, at least I don't see a need for that at this point. What I'm talking about is a Name validation form limit, and one for Address validation, in addition to the current unique Phone Number validation.

    Obviously, there are duplicate personal names. That may be a bit more difficult to achieve, and require a double condition (Name and Phone Number or Address). But, Postal Addresses should be unique. All though, they'll probably need a Javascript routine to string together entries from all 4 (or 5) address fields; 5 if you use Street 1 and a possible Street 2 format.

    Hope they can come up with something soon! And, I'll let you know how the work-around turns out after I've tested it.

  • rwaldenjr
    Replied on August 27, 2017 at 4:56 AM

    Oops, sorry! Meant to say "Thanks Kiran!" (Thanks to both of you for all your help!)    :-)

  • Elton Support Team Lead
    Replied on August 27, 2017 at 8:19 AM

    On behalf of my colleague helping you this, you're welcome.

    You might want to consider the submissions verifier app too http://subverifier.jotform.io/

    This app will generate a confirmation link where you need to embed in the autoresponder message. So when the user clicks the confirmation link, their submission data will be marked as confirmed/verified. In short, this allows form users to confirm their submission and email address in a professional manner.

    Hope this helps!

  • rwaldenjr
    Replied on August 27, 2017 at 5:08 PM

    Thanks for the suggestion EltonCris! I like the idea of offering a two-step registration method. (However, I don't see "Submission Verifier" listed when I search for it in the Widgets tab!?! Are apps listed separately from widgets? If so, what's the link to the list of JotForm approved/compatible apps?) I'll probably include Submission Verifier as a measure to prevent bot submissions. I'm still not sure how that helps me automate the verification process though, and determine which pages people have access to on my site, based on the data they enter on my JotForms.

    Here's an example of what I'm trying to achieve with registration/validation. I want to run a contest that indicates and rewards the first submission for every unique postal address of a property that I ultimately purchase which my users submit. Multiple people may identify the same property. And, I'll probably give them each a sequential registration number in the Thank-you verification message after submission, so there's no question about which one was first. (I assume the Unique ID widget will suffice in this instance?)

    However, I'd ideally like them to enter the property's address on a form and quickly see whether or not that address has already been submitted in the system. That would save them a lot of wasted time entering data when they aren't going to win, and any ill will from their frustration with my contest system.

    Here's another use. Let's say a new user registers as a potential renter of one of my properties. I'd like their response to a checkbox on my form that indicates they're looking to "Rent" to integrate with Weebly and automatically enable access to the Renters group of web pages on my site, and telling Weebly to give them access to all the additional privileges I've assigned to that group. I'm sure it'll require some backend coordination between JotForm and Weebly's site builder.

    How should I proceed?

  • David JotForm Support Manager
    Replied on August 27, 2017 at 5:33 PM

    Here is the link to JotForm Apps: https://www.jotform.com/integrations/

    Here is the direct link to the Submission Verifier apphttps://www.jotform.com/integrations/submission-verifier

    What you are trying to accomplish is a bit complex, and goes beyond JotForm features at the moment.

    There is another option, but this would require you to hire a back-end developer to create the solution you are looking for, so he would most likely need to:

    1) Download your form's full source code: https://www.jotform.com/help/104-How-to-get-the-Full-Source-Code-of-your-Form 

    2) Forward submissions to your own database. Here is an example with MySQL, using PHP: https://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP 

    3) Create the proper script and database queries to connect your form to your databases, so each time someone enters the information, it will check within your database if the information is already there.