Ability to verify filled info in a JotForm with an external resource.

  • Profile Image
    amlien
    Asked on January 23, 2017 at 06:53 PM

    We want to set up registration forms for conferences and events in such a way that we will be able to verify that individuals who register are in fact members of our organization.  We intend to have the registrants enter their membership number, and we want to be able to compare that number with a database of member numbers.  If someone IS a member, then their registration will go through, and if they ARE NOT a member, the form will ask them to include the cost of membership in their event registration.

    My question is how to set up the form to validate whether or not their membership is current from a database of member numbers.

  • Profile Image
    Kevin_G
    Answered on January 23, 2017 at 10:54 PM

    Unfortunately, this is not possible to do at the moment, you cannot compare info entered or submitted in your form with info from an external resource such as a database, you could do it with conditions, but they will need to be manually added so you would end up having a lot of conditions in your form. 

    What you could do is to get the source code of your form and implement your script to work as you need so you apply the needed actions based on the info from your database, with this you can validate the info before to be submitted as well. 

    Guide to get the source code: How-to-get-the-Full-Source-Code-of-your-Form

    We can also forward this as a feature request if you want, we cannot ensure this will be implemented or provide an ETA, but we would let us know if there're news about it. 

    Let us know.