Hi, I have a catalog of over 1000 items all ...

(Andrew Lanoe) #1


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

(Marc Dillon) #2

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.

(Aleksi Alkio) #3

Should the formula be like… SELECT(Table[Column], LEFT([Column],1)=[_THISROW].[LetterSelectionColumn])?

(Marc Dillon) #4

Yes, it definitely should be