Hi,
I have a catalog of over 1000 items all with an alpha name.
I would like to show a button for each first letter of the name (A, B, C, …) so the user can select the button and get a list of items starting with that letter.
What would be the best approach?
Many thanks
Is it a list of records in a dropdown, or are you looking at a list of records in a table view?
For the dropdown list, you could add a new column where the user selects a letter from, and then put a valid_if constraint on the dropdown list such as
SELECT(table[column] , CONTAINS([column] , [letter selection column]))
If you’re looking at a table view, you could sort it by item name. Or you could add a virtual column on each row that has LEFT([item name] , 1), then group the view by that VC.
I’m sure there are more options, maybe someone else has a better one.
Should the formula be like… SELECT(Table[Column], LEFT([Column],1)=[_THISROW].[LetterSelectionColumn])?
Yes, it definitely should be
User | Count |
---|---|
43 | |
29 | |
24 | |
21 | |
13 |