- ckshowtimeAsked on March 17, 2017 at 03:26 PM
I have a similar issue with the bowling league registration form I am creating.
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.
- JotForm SupportdavidAnswered on March 17, 2017 at 03: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"
- ckshowtimeAnswered on March 17, 2017 at 04: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".
- JotForm SupportdavidAnswered on March 17, 2017 at 05:34 PM
I see what you mean now. Set up a condition to hide all those fields if Manufacturer is Empty:
Or, if you wanted to streamline things quite a bit more, you could use a single show condition for each option:
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.
- ckshowtimeAnswered on March 17, 2017 at 07:34 PM
Thanks. Switching to the "Show" condition worked perfectly
- ckshowtimeAnswered 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.
- JotForm SupportEltonCrisAnswered 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.