I would like to have multiple choices but only want the final selection to appear in the submission

  • Profile Image
    PEvaluations
    Asked on October 05, 2017 at 04:16 PM

    I have a form with multiple choices e.g.

    Property Type: Commercial, Residential, Industrial

    Depending on the Type selected, the next list of choices is unhidden by a conditional

    Property Sub-Type Commercial : Office, Mall, Tower

    Property Sub-Type Industrial: Factory, Warehouse

    So if the user selects Industrial->Warehouse, the two fields I want in the submission are:

    Property Type = Industrial

    Property Sub-Type = Warehouse

    I have 8 sub-types, so I don't want to have extraneous fields in the submission. I know I can remove them from the submission mapping for export but I still need a single field regardless of the sub-type chosen. I know I can put all subtypes in one list but that is not the desired user experience.

    Any suggestions? I have not found any Widgets that do this either.


  • Profile Image
    Welvin
    Answered on October 05, 2017 at 05:19 PM

    You have the Dynamic Dropdown widget in your test form. Isn't that the function that you are looking? If not, then I'm afraid you would need to use multiple fields for the sub-type then show each depending on the Type selection. Let us know if the widget won't work. 

  • Profile Image
    PEvaluations
    Answered on October 05, 2017 at 06:03 PM

    Yes, I have discovered the Dynamic Dropdown. But it only produces a single field that has the concatenation of the Type + Subtype. I need the fields to be separate to match the import into another database after export from JF.

  • Profile Image
    John_Benson
    Answered on October 05, 2017 at 11:40 PM

    As my colleague suggested, the best way to do this is using the checkbox/multiple fields and show/hide condition to achieve what you're referring to. 

    Related guide: https://www.jotform.com/help/316-How-to-Show-or-Hide-Fields-Base-on-User-s-Answer

    If you need assistance, please let us know. Thank you.


  • Profile Image
    PEvaluations
    Answered on October 06, 2017 at 11:47 AM

    So if I have 10 sub-type fields that are hidden via conditional logic such that only 1 is visible at any given time, when the form is submitted, will I get 10 fields but only one will have the actual choice? What I want is only ONE field in the submission.

  • Profile Image
    John_Benson
    Answered on October 06, 2017 at 12:18 PM

    You can disable the hidden fields in the submission page. It is by default that hidden fields will not be displayed in the submissions.

    Here's my demo form and the notification email I have received after submitting:

    Here's the demo form link: https://form.jotform.com/72785164128967

    I hope this information helps.