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

  • Profile Image
    Asked on August 26, 2017 at 02:36 AM
    3.  I also need to validate visitors' data submissions for uniqueness.
  • Profile Image
    Answered on August 26, 2017 at 03: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.

  • Profile Image
    Answered on August 27, 2017 at 03: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?

  • Profile Image
    Answered on August 27, 2017 at 04: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.

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

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

  • Profile Image
    Answered on August 27, 2017 at 04:56 AM

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

  • Profile Image
    Answered on August 27, 2017 at 08: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!

  • Profile Image
    Answered on August 27, 2017 at 05: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?

  • Profile Image
    Answered on August 27, 2017 at 05:33 PM

    Here is the link to JotForm Apps: https://apps.jotform.com/app

    Here is the direct link to the Submission Verifier apphttps://apps.jotform.com/app/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.