Upload a list of numbers to validation: Is there a widget which upload a list of numbers as a database for field data validation?

  • jaseheng
    Asked on May 22, 2018 at 2:39 AM

    Hi Support, could you please recommend a Widget which allows me to upload a list of numbers as a database for field data validation?

    For example, if I have a database of Postcodes that I want to allow, I would like to alert the user during the filling up of Jotform that the Postcode that he has entered is not a valid Postcode immediately.

    Thanks.

  • Nur Karabağ JotForm Developer
    Replied on May 22, 2018 at 8:19 AM

    Hello,

    You can use Spreadsheet to Form Widget to upload data to form.

    Please, look at this guide to use that widget:

    -How to Use the Spreadsheet to Form Widget

    If verified numbers are specific, you can use conditional logic to field validation.

    I made an example form to show you:

    -Example Form

    I set up conditional logic to check postcode with my specific numbers.

    You can see the logic here:

    1526991573Screen Shot 2018 05 22 at 3 Screenshot 10

    Let us know if you need more help.

  • jaseheng
    Replied on May 22, 2018 at 11:22 PM

    This is very helpful. Thank you Nelly.