Can one dropdown field show different lists based on what was selected in the single choice field?

  • Profile Image
    wkwan
    Asked on July 23, 2021 at 01:47 AM

    Can one dropdown field show different lists based on what was selected in the single choice field? For example, if the single choice field has these options:

    *Click this button to see roster of New York office

    *Click this button to see roster of Chicago office

    *Click this button to see roster of Los Angeles office

    After someone clicks one of the above, the dropdown field shows the corresponding office's roster. The person then chooses the desired name.

    I have a current workaround that uses multiple dropdowns that are controlled by a conditional show/hide depending on which button is clicked. This is not ideal because I want to have the name the person picked to be included in the email subject but I cannot know beforehand which office roster the person will pick. Therefore, I have to include all of the names in the subject like this:

    You are receiving an email from {NYOfficeName}{ChicagoOfficeName}{LAOfficeName}

    As long as the person picks only one name, the empty fields won't show in the subject. However, if the person picked a name from the NY office (say, Harry Smith), then decided to pick the name from the Chicago office (say, Jane Johnson), both names will shows up in the subject because the dropdown for the NY office does not reset to an empty field when you pick another office:

    You are receiving an email from Harry SmithJane Johsnon

    This obviously looks wrong and so I want to prevent it from happening.

    Note, I can only use dropdown (and not other widgets) because I also assign each name their email address in "Calculation Values". The email address is then copied to another field for use elsewhere.

  • Profile Image
    Jed_C
    Answered on July 23, 2021 at 07:59 AM

    Unfortunately, show and hide would be the best option here. What you can probably do is create a conditional email that if let say NY is selected, send an email to NY.

    Guide: https://www.jotform.com/help/167-how-to-send-email-based-on-users-answer

    As long as the person picks only one name, the empty fields won't show in the subject. However, if the person picked a name from the NY office (say, Harry Smith), then decided to pick the name from the Chicago office (say, Jane Johnson), both names will shows up in the subject because the dropdown for the NY office does not reset to an empty field when you pick another office: — For this issue, you will need to change the "Clear hidden field values" to clear on being hidden so it won't add emails when they changed their selection and field hides again.

    1627041514_60faaeea06315_The Easiest Onl

  • Profile Image
    wkwan
    Answered on July 23, 2021 at 11:20 AM

    Thank you for pointing me to that feature. It will have to do. Best regards.