How to validate field value using list of values in excel?

  • alohaofilt
    Asked on December 28, 2020 at 4:47 PM

    Hi,

    I need to validate field value using list of values stored in excel. Below are the steps:

    1. Load the form
    2. Enter full name
    3. Validate name against list in excel
    4. If validated, then display the first field of the form
    5. If not validated, then do NOT display the first field of the form.

    I tried using spreadsheet to form. I can validate, however, not able to display the first field if the name is validated.

    Thanks.


  • KrisLei Jotform Support
    Replied on December 28, 2020 at 7:15 PM

    Hello,

    I have checked your form, however, there's no uploaded file or sheet on the widget:

    1609200685 5fea742dccb8a Screenshot 1229 Screenshot 10

    To prefill the form with the data on the spreadsheet and to validate it, please verify that the header column exactly matches the field labels. Please refer to this detailed guide: How-to-use-the-spreadsheet-to-form-widget

    I hope this helps. Let us know if you need further assistance.