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

  • Profile Image
    alohaofilt
    Asked on December 28, 2020 at 04: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.


  • Profile Image
    Kris
    Answered on December 28, 2020 at 07:15 PM

    Hello,

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

    1609200685_5fea742dccb8a_Screenshot_1229

    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.