-
alohaofiltAsked 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:
- Load the form
- Enter full name
- Validate name against list in excel
- If validated, then display the first field of the form
- 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.
Page URL: https://form.jotform.com/203147981857062 -
KrisLei Jotform SupportReplied 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:
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.