I have a drop down menu. I want the user to first choose from that drop down menu. Once they choose from that - i want to only give them options based on that value:
For example, if the user has a choice:
Enum:
Item A
Item B
Item C
If the user chooses “Item A” - then they can choose from another drop Down:
Item aa
Item aaa
Item aaaa
If the user chooses “Item B” - they can choose from these options:
Item bb
Item bbb
Item bbbb
etc…
Item
Solved! Go to Solution.
Hi @Tiger
Would dependent dropdowns work here?
In the Valid If expression of Column 2, try:
SWITCH(
[Column 1],
"Item A", LIST("Item aa", "Item aaa", "Item aaaa"),
"Item B", LIST("Item bb", "Item bbb", "Item bbbb"),
...,
""
)
Note the last item is a default value. A default value is required, but may be a blank value (""
, as here).
See also:
Thanks Steve- let me try this - i have over 600 rows to do this with - ill get back to you…
is there a limit on how many "items i put in the LIST?
Hi @Tiger
Would dependent dropdowns work here?
Lynn,
You are right. I used Valid if - and used dependent Dropdowns. Thanks
@Tiger
Great
Lynn,
How can i make a dependent drop down menu work like a “related table” in the sense of the user ability to add multiple items?
Example:
Thanks
User | Count |
---|---|
41 | |
27 | |
26 | |
20 | |
13 |