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.
Ability to verify filled info in a JotForm with an external resource.Asked by amlien 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.
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.