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.

  • Profile Image

    how can I validate data against a table?

    Asked by RECone on October 20, 2013 at 02:12 PM
  • Profile Image

    Answered by Cesar on October 20, 2013 at 03:20 PM

    Hello, to help you better, kindly elaborate on what you are trying to achieve. Also, if possible, do provide the FormID (URL) and the site where the form is embedded, if any.

    Thank You!

  • Profile Image

    Answered by RECone on October 20, 2013 at 03:28 PM

    I need to validate the values input in the form located here:


    against data in a spreadsheet or a simple table.  I have a list of valid license numbers and I'd like to validate that it is a known number before allowing them to move to thank you page.

    Can I use one of your templates? 


  • Profile Image
    JotForm Support

    Answered by jonathan on October 20, 2013 at 04:07 PM


    Just in case you have not noticed, the text box field do have Validation property


    The input mask property should also help further restrict the inputs to the valid required value.


    BUT I also do understand what you were referring to as 'validate' -- that is, you wanted to compare/check the input value to an external data source i.e. table list or spreadsheet.

    This is also possible -- but will require using the form's source code and then creating a comparing code/program using external program i.e. javascript or PHP.

    Here is the guide on How-to-get-your-Form-Source-Code


    Please inform us if you need further assistance.