how can I validate data against a table?

  • Profile Image
    Asked on October 20, 2013 at 02:12 PM
  • Profile Image
    Answered 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 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
    Answered 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.