- IBARefereeAsked on February 03, 2018 at 04:36 AM
I would like to have a drop down list or type text box in which I enter a person's name. Then I would like for the Form to match that name within a list that includes the person's email address, and auto populate the field with the person's email address.
- JotForm SupportEltonCrisAnswered on February 03, 2018 at 06:12 AM
That's possible through update/calculation condition. However, the downside is that, if you have a long list of names/emails, you would end up a huge conditions and it isn't healthy for a form.
If name field is equal to "John Doe"
Update email field with "firstname.lastname@example.org"
Add the fields in your form:
Create the condition:
Alternatively, you might want to use this widget too.
You can have them enter a key from the spreadsheet then it would automatically populate their name and email.
Here's a guide on how to use that widget: https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget