Dynamic Dropdown Selection - Seperate 2nd dropdown into other column

  • Acqbuilt
    Asked on March 21, 2019 at 4:02 PM

    1553198606Example Screenshot 10

    Hello,

    I am trying to do is essentially what is achieved through the Dynamic Dropdown widget but my problem is that when view in the submissions - both selections are placed in the same column. Ideally I am looking for a drop down selection  (employees) that is based on an initial selection (Team lead), but where the Team Lead and Employee end up in seperate columns (Attached picture of what actually occurs. I didn't put in names just used Group A, Option A1)

    I read through some other questions and it looked like the other option was to use conditional logic but this wasn't really what I was looking for - since I don't want it to preselect a value but rather allow for a dropdown of selections

    The other option I had looked at was making multiple drop downs and using conditional logic to only show the one I needed- but I ran a different problem in the submission view - where the multiple drop down of employees were now all in seperate columns.

    Is there any other alternative you can suggest?

     

    Jotform Thread 1768295 Screenshot
  • Elton Support Team Lead
    Replied on March 21, 2019 at 6:30 PM

    The dynamic dropdown widget is considered a single field that's why all answers from that field are placed in a single column. It's most probably the same for all the widgets even if it contains multiple fields in it.

    The 2nd solution you've mentioned is the only alternative solution but there's a way to consolidate the multiple employees dropdown into a single textbox field (short text entry) using form calculation widget. So instead of checking the result into multiple employee columns, you can just check them in the single textbox column.

    Here's how:

    155320695303222019 woQXCQ0TmX Screenshot 30

    Dynamic Dropdown Selection   Seperate 2nd dropdown into other column Image 1 Screenshot 41

    Demo Form: https://form.jotform.com/90786639573979

    You can clone this form if you like. Guide: http://www.jotform.com/help/28-Cloning-a-Form-from-a-Web-Page

    By the way, this is important to prevent possible duplicate values on the form calculation widget when the user uses the browser back button and submit the form again. This would reset the conditionally hidden fields. Please ensure that "Clear on Being Hidden" is set in your form settings. It's easy, here's how:

    Dynamic Dropdown Selection   Seperate 2nd dropdown into other column Image 2 Screenshot 52