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

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


    If name field is equal to "John Doe"

    Update email field with ""

    Here's how:

    Add the fields in your form:

    Create the condition:



    Example 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: