Is there any way to group a drop-down in a reference column like it is done in case of table views?
When the number of drop-down options is large it would immensely help to ‘group’ them based on a characteristic.
Any help would be appreciated.
I’m afraid we don’t have that feature at this moment.
Okay.
No problem for now, but I would really like to see it in the future.
If you can group the options the I assume you can filter the options.
I would just add a parent option
TestTable
ID | Parent | Child |
---|---|---|
001 | a | 1 |
002 | a | 2 |
003 | a | 3 |
004 | b | 10 |
005 | b | 20 |
006 | b | 30 |
First Dropdown Enum Based on Parent
Second Drop down Enum with a
Valid If "select(TestTable [ID],[Parent] = [_thisrow].[Parent])
Then if you select “B” in the fist Drop down you will only get the options
10
20
30
For you second
User | Count |
---|---|
44 | |
29 | |
23 | |
20 | |
15 |