- mohammednadeemAsked on April 12, 2018 at 04:18 AM
i am trying to create a registration form for a user visit, which will have the below fields
Employee Email Employee ID Employee Name Employee Department Number of visitng family members Day of Visit Time Slot
when a user enter his email id, automatically relevent fields should be filled (emp id, name,dept) i have all the information stored in a excel file, how can i achieve this.
- JotForm SupportVictoria_KAnswered on April 12, 2018 at 07:59 AM
As far as I understand, you would like to update the values of emp id, name, dept based on user's input for email id field. This can be achieved with the Spreadsheet to form widget.
Related guide: How-to-Use-the-Spreadsheet-to-Form-Widget
We will gladly assist if you need more help.
- mohammednadeemAnswered on April 12, 2018 at 08:07 AM
thanks for the reply, i have the attached sheet (example) and below link i created form, can u apply it or show me what to do.
- JotForm DeveloperScottAnswered on April 12, 2018 at 09:49 AM
The widget properties, field labels and the setup of the excel should correlate to each other.
Access Code Column refers to the Column name of the unique keys. ('Unique Code' as shown in the example excel screenshot )
Labels Row refers to the row number where the labels are located (It is the first row in the example sheet)
Lastly, the names of the labels from the excel file should be the exact matches of the field labels.