❄️ Easily Create Lists of Unique Items — No Computed Columns Required!

Community Resources
1

:waving_hand: Hey Fellow Gliders!

I just discovered a workaround to easily create a collection of unique items from a larger list of items without using a single computed column — achievable in 3 steps:

:one: Create a List
:two: Set Limit Items to 1
:three: Group by the Unique Value

Check out the video tutorial below. Enjoy! :popcorn:

2

Ha good one Bob! For purely display purposes if we accept to show an item in each group, it seems it’ll do the trick. Nice find, how creative.

3

You made the remark that generating the unique list in a Glide Big Table isn’t practical:

  • Using a Query column. Unpractical because of the 100-row limit?
  • Using a relation single match. Wouldn’t that work fine?