Dynamic selection of drop-down options in a form

Hello,
I am interested in finding a solution to dynamically choose what options a drop-down list displays when a certain value is selected in another drop-down. As an example:
We have Category 1 and Category 2 with the following options:
and a form with 2 drop-downs - one for category and one for option.
When the user chooses Category 1 in the first drop-down of a form I want to see in the Options drop-down only the options that are associated with Category 1. When the user chooses Category 2 in the first drop-down the second drop-down would show only the 2 options associated with Category 2.
Current solution that I have - The options are dynamically added to a drop-down with Data Shuttle. I use two different drop-down list for the 2 category options but that saves the values into 2 different columns and that adds too many columns when having more than 2 or 3 categories.
The challenge - to find a solution that will change the options into the second drop-down dynamically and save the chosen options into a single column.
Answers
-
Hi @Raluca Arba
Currently Smartsheet Forms do not have a way of dynamically adjusting what values are displayed in one dropdown list based off of values selecting in another list. You can use conditional logic to display an entirely new column/dropdown, which it sounds like you're doing.
Please feel free to add your vote and voice to this Product Idea: Cascading Forms
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
Hi @Genevieve P. - any update on this capability? Other than creating the dynamic drop down in forms via Bridge? Thank you!
-
My team has done a project similar to this using a third party app for the form, synced back into Smartsheet. You can look at products like Jotform and Google Appsheet to get the outcome you need, so I'd recommend looking at that. There's a big learning curve if you're not familiar with those products, so feel free to reach out to solutions@infospark.com.au if you'd like to have a chat about getting my team to do this for you.
Cheers,
Lindsay
Smartsheet Lead @ InfoSpark
Asia Pacific Smartsheet Partner of the Year (2023)
Platinum Smartsheet Partner | www.infospark.com.au
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives