Fill 2 fields when selecting 1 option

  • Profile Image
    ellisdrivingschool
    Asked on June 28, 2020 at 04:37 PM

    Is there a way to have a drop down table that displays 2 field results.

    i.e.

    I would like to select Joe Bloggs in a dropdown and it to be able to complete his name and email address automatically?


    Thanks

  • Profile Image
    Amin_N
    Answered on June 28, 2020 at 04:56 PM

    Yes, that is possible using 2 methods:

    1. Conditional Logic as shown below:

    1593377428Screenshot_2020-06-28 The Easi

    Related guide: How-to-Insert-Text-or-Calculation-into-a-Field-Using-Conditional-Logic

    2. Conditional Logic is not recommended if you have many users. Alternatively, you can use the "Spreadsheet to Form" widget, as it allows to upload a spreadsheet/Excel file to your form and use the values you have in the spreadsheet to populate form fields.

    Related guide: How-to-Use-the-Spreadsheet-to-Form-Widget

    I hope I have been of any help.