How can I add calculation values into dropdown?

  • Profile Image
    lakeviewrock
    Asked on April 22, 2019 at 01:23 PM

    Dear JotForm,

    I would like to make a condition that allows a selection from drop down list of 125 people to send an email to the person selected from the drop down. I have done this one-at-a-time, however is there a way to match a list of people with a list of their emails to populate an email field?

    Thanks,

    Craig

    craig@lakeviewrock.com



  • Profile Image
    Alan_D
    Answered on April 22, 2019 at 02:50 PM

    Hi,
    Using calculation values in the dropdown field may help you. You can define specific email addresses for each dropdown option. Please let me show.
    I have cloned your "DAILY TRUCK SCHEDULE" form.  As far as I see, you are updating the "DRIVER’S EMAIL" field with conditions. It should be taking much time. 
    You can define email addresses in the dropdown. Please enable "Use Calculation Values" in the dropdown and write email addresses in the related row.15559588811.pngThen remove all conditions about the email updating and create a new one.
    15559589482.pngHere is how it works.
    1555958839bandicam20190422214618822.gif