How do I ensure all conditionally hidden options are available when the form loads

  • ckshowtime
    Asked on March 17, 2017 at 3:26 PM

    I have a similar issue with the bowling league registration form I am creating.  

    https://form.jotform.us/70574589906168

    I used the 'ddSlick Dropdown' widget to create my drop down.  For each ball manufacturer in my drop down there is an associated available ball list to pick from.  I have conditions that hide other manufactures once you choose from the drop down, and they work.  When you first go to the form you can see all ball choices (grayed out) before you pick from the drop down.  How do I fix all choices showing (grayed out) when the form loads?

     

    **Edit**  It also appears that the user can pick each item from the drop down and select from the list that appears.  So they could have selected one from every option in the drop down.  I need to prevent them from choosing more than 1.

  • David JotForm Support
    Replied on March 17, 2017 at 3:34 PM

    I am not quite following what you mean by the options being greyed out.  The options in the ddSlick widget in your form appear to be available when the form first loads.

    As for clearing options once they are hidden, while editing your form, click the settings tab, then on the "Show More Options" button.  From there, change clear hidden values to "Clear on being hidden"

    How do I ensure all conditionally hidden options are available when the form loads Image 1 Screenshot 20

  • ckshowtime
    Replied on March 17, 2017 at 4:16 PM

    The drop down widget is great, it does what is expected.

    When you first load the form it should only show the fields pictured below, but if you scroll you can actually see the ball choice list for each manufacturer.  The ball selection list should be hidden until they make a choice from the drop manufacturer.  Let me know if that makes sense.

    I am not completely convinced I have the ball list set-up correctly to do what I want.  Each one is individually set-up as a "single choice element".  

    How do I ensure all conditionally hidden options are available when the form loads Image 1 Screenshot 20

     

  • David JotForm Support
    Replied on March 17, 2017 at 5:34 PM

    I see what you mean now.  Set up a condition to hide all those fields if Manufacturer is Empty:

    How do I ensure all conditionally hidden options are available when the form loads Image 1 Screenshot 30

    Or, if you wanted to streamline things quite a bit more, you could use a single show condition for each option:

    How do I ensure all conditionally hidden options are available when the form loads Image 2 Screenshot 41

    If a field is conditionally shown, it will be hidden until the condition to show it is met.  Much easier to show one field than hide 15.  That way, they would all be hidden be default and it would require a separate condition for hiding all the fields when the Manufacturer field is empty.

  • ckshowtime
    Replied on March 17, 2017 at 7:34 PM

    Thanks.  Switching to the "Show" condition worked perfectly

  • ckshowtime
    Replied on March 18, 2017 at 11:13 AM

    I noticed that having it set up with individual ball choice choice fields creates a separate column for each in my google sheet.  Is there a way I can have them separated in the same selection field but still perform the hide condition when they choose manufacturer.

    I guess that would be a sectioned selection field?  That way once they have completed the form the sheet would have a column for manufacturer and the next column would show the ball name.

     

    How do I ensure all conditionally hidden options are available when the form loads Image 1 Screenshot 20

  • Elton Support Team Lead
    Replied on March 18, 2017 at 10:08 PM

    I'm not sure if I have understood your question correctly but if you want your spreadsheet to show only the columns with values, in accordance with your conditions, I'm afraid that's not possible. The spreadsheet is designed to capture all the form values, empty or not and there's no way to apply conditions in it.

    Thank you!