Email recipient based on dropdown

  • Profile Image
    pattonb
    Asked on January 25, 2018 at 10:33 AM

    I am evaluating several similar products and JotForm is very close to the perfect fit for us. I have one issue I need to try and resolve though.

    We use several forms that have a dropdown box (ex Supervisors). I need to be able to send an email notification to the email address of the person chosen in the dropdown. In my test form I have created the dropdown of names, then used the Calculation Values to store their email address. I then created a Change Email Recipient Condition but I cannot figure out how to get the email address of the calculation value into the setting. I tried the form variable {yourSupervisor} but that doesn't pull the calculated value email address. Is this possible to do? If so, we may be very close to purchasing this product.

  • Profile Image
    ashwin_d
    Answered on January 25, 2018 at 12:01 PM

    Yes it is possible to achieve your requirement by adding the field name tag of the dropdown field and add it as "Recipient Email" in a separate field of your form. Please note that "Calculation Value" can only be read in condition or form calculation widget.

    I did check your form and it seems you have not added any calculation values in the dropdown field. Here are the steps you need to follow:

    #1. Add a hidden form field in form.

    #2. Add condition in form to read the value of dropdown value and insert it in the hidden field.  

    #3. Grab the field name tag of the hidden form field of form and add it as the "Recipient Email" in the notification email alert or condition to send email. Please check the screenshot below:

    1516899590calcValEmail.gif


    Please take a look at the following cloned form and see if it works as expected:   https://form.jotform.com/80244808643963 

    Feel free to clone this form for a closer look. The following guide should help you in form cloning:  https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    Hope this helps.

    Do get back to us if you have any questions.