How to pre-populate an email address by matching it to a name?

  • Profile Image
    IBAReferee
    Asked 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.

  • Profile Image
    EltonCris
    Answered 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.

    Example:

    If name field is equal to "John Doe"

    Update email field with "john@doe.com"

    Here's how:

    Add the fields in your form:

    Create the condition:

    settings-conditions.png

    conditions-list.png

    Example condition:


    Alternatively, you might want to use this widget too.

    https://widgets.jotform.com/widget/spreadsheet_to_form

    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