How to change the eligible values on a drop-down list in a form?
Hi,
I want to display two drop-down list fields on a form (Model and Serial Number). The values in the serial number field should be conditioned by the one selected in the "Model" field.
Is there a way to do it?
Thank you for your cooperation.
Answers
-
Unfortunately not. How many different Models do you have?
-
Recently I developed something similar for a client, and I ended up adding columns for each option.
In your use-case, it would be something like,
If Model A is selected in the form, it would show the serial numbers in the Model A Serial number column through the Logic feature.
Would that work?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå That is along the lines of what I was thinking. Hahaha. That's why I asked how many Models there are.
-
Thanks for your answer.
Unfortunately, both the quantity on Model and Serial Number values are high and very changing, so I need an automatic process to do it. (Conditional filters on the displayed fields or something similar)
Thank you very much for your quick response.
Keep up well.
-
Andree may have other ideas, but if having different fields for each Model to display the appropriate Serial Number values is not an option then I am left with suggesting that you Submit A Product Enhancement Request when you have a chance.
-
Ok. You would need to look at other options. How many different Models could there be?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi, Andrée.
I'm working with about 70 differents models.
Thanks in advance.
Regards.
-
Happy to help!
A solution that would be perfect for this use-case is the premium add-on, Data Uploader. Is that an option?
We could use it to sync the values to the different columns and then build it with logic to show the correct dropdown list for the selected model in the form.
More info:
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives