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.
Access to External Databases from JotformAsked by Hulleys on February 11, 2017 at 05:43 AM
I have been looking for a way to validate a Jotform field against a valid list held in Excel or similar. Looking at the support answers, it seems that this is not possible.
I am new to Jotform and have so far been very impressed with the functionality of the product. However, if you cannot check an external table to check validity, then this is a gaping hole in the product. Are then any plans to introduce this function in future releases ?
Unfortunately, we do not have a feature or functionality that would allow you to lookup a database or an excel file and use it for validation.
However, this is possible using the form's full source code. If you are a developer or a programmer, you can download the full source code here: https://www.jotform.com/help/104-How-to-get-the-Full-Source-Code-of-your-Form. You can then edit the source code and create your custom script wherein you can connect to a database or a file or a specific list then do validations on inputs.
If you are familiar with APIs, then you can check this guide: http://api.jotform.com/docs/. You can pull existing submission data and use it for validation or any advance customization that you may need.
We do have some simply ways where you can do validation input, although if the list of items you have as a lookup ranges to hundreds or thousands, then this simple solution would not work. The possible solution solution I mentioned is by using Conditional Logic: https://www.jotform.com/help/57-Smart-Forms-Using-Conditional-Logic.
Here's an example form: https://form.jotform.com/70413851204951.
1. Here's my sample conditional logic:
2. Condition states that if the "Input" text box contains value from the list "red,blue,green,yellow,black", then show the static text "Input color is on the list".
3. You can try my form and input some text there to see how it will behave.
I hope that helps.