- HulleysAsked 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 ?
- CharlieAnswered on February 11, 2017 at 09:53 AM
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.