Dynamic dropdowns - customizing submitted data format

  • Profile Image
    kelseymccutcheon
    Asked on November 17, 2014 at 01:55 PM

    Hi,

    Thank you for the great forms!  I have a question about the dynamic dropdowns widget. 

    I am using the 'dynamic dropdowns' widget to help people select a species of wildlife from a list of 100 species.

    I have set it up so that they first choose a category (plant or animal), then a subcategory (bird, fish, mammal, etc), then a species (Bald eagle, osprey, ...).  This is so that they don't have to scroll through a list of 100 names.

    I am only interested in their answer to the last part of the question (the species name), but when I export their responses to my spreadsheet, all three are lumped together in one column.  For example, I get the response  "Animal bird osprey", when all I really want to know is "osprey".   

    Is there a way to discard the first two responses (the category and subcategory) and only export their final response (species name)?  Or, to separate the responses to these questions so that they would each export to a separate column in a spreadsheet?  I am going to be dealing with a large number of forms and hoping to not have to do this manually!

    My form is here:  http://www.jotform.com//?formID=42735884551160, and the field I am talking about is "species observed".

    Thank you!

  • Profile Image
    Mike_T
    Answered on November 17, 2014 at 02:44 PM

    Thank you for contacting us.

    Unfortunately, there is no way to omit some data one the Dynamic Dropdowns widget output.

    You might consider using a separator symbol to split the values:

    And then, use the following option in Microsoft Excel to split the data based on the delimiter symbol.

    Split text into different cells

    Alternatively, it is possible to use multiple standard Drop Down fields in combination with conditional logic on form instead of the widget. You will not have any issues with the data format in this way, but this solution is not as compact as one Dynamic Dropdown field.

    Please feel free to contact us if you need any further assistance.

  • Profile Image
    kelseymccutcheon
    Answered on November 19, 2014 at 10:52 AM

    Thank you very much! I tried those ideas and a few others, and have settled on using the Auto-complete widget instead.   I think that will be even easier for people.  

    Many thanks for the quick response! 

     

  • Profile Image
    Charlie
    Answered on November 19, 2014 at 10:58 AM

    In behalf of my colleague Mike_T, you're most welcome.

    I'm glad the suggested solutions works. If you needed an assistance again or have any concerns, please feel free to open up a new thread here in the forum, we'll be more than happy to help you.

    Thanks.

  • Profile Image
    snaplash
    Answered on December 16, 2015 at 10:02 PM

    Kelsey, I dont know if this helps but after a few gruelling days of the same problem, I solved it by adding a number of spaces to the hierarchy...and then adding a hyphen to the last on ie, make every input 10 characters long.

    plant    -

    animal   -

    then use the substring copywidget  to omit the same amount of characters from the begining

  • Profile Image
    damoau
    Answered on June 19, 2016 at 02:48 AM

    Hi, Great widget!

    Just getting stuck on on thing. How do i make the drop down box 600PX wide x 34PX high?

  • Profile Image
    Chriistian
    Answered on June 19, 2016 at 03:39 AM

    Hi,

    I moved your concern to a separate thread to assist you better. Please see it here.