# Unique Values only? **URL:** \ **Category:** Ask for Help\ **Created:** [May 13, 2024, 8:55pm UTC](https://community.glideapps.com/t/unique-values-only/73329 "2024-05-13T20:55:24Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![robbielobster](https://avatars.discourse-cdn.com/v4/letter/r/eada6e/32.png) [@robbielobster](https://community.glideapps.com/u/robbielobster)\ **Post date:** [May 13, 2024, 8:55pm UTC](https://community.glideapps.com/t/unique-values-only/73329/1 "2024-05-13T20:55:24Z")
Hello! I am very new to Glide. From Salesforce, I have a table of work orders. Work orders belong to an Opportunity. An opportunity may have one, or many, work orders. For example WO 1234. Opp: Bob WO 1235. Opp: Bob WO 1236. Opp: Mary WO 1256. Opp: Pendry WO 1292. Opp: Pendry WO 1367. Opp: Pendry I want to display only the Opportunity names (Bob, Mary, Pendry) - not Bob, Bob, Mary, Pendry, Pendry) I’ve tried converting the names to an array column then using the unique elements plugin: [Unique Elements column | Glide](https://www.glideapps.com/plugins/uniq) - but this doesn’t have any effect. Just making the collection show unique Opportunities only would work - the closest I can get is by grouping, but then we have headlines then identical subheadings. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [May 13, 2024, 9:02pm UTC](https://community.glideapps.com/t/unique-values-only/73329/2 "2024-05-13T21:02:26Z")
> [@Filter to display DISTINCT (or Unique) rows based on specified columns](https://community.glideapps.com/t/filter-to-display-distinct-or-unique-rows-based-on-specified-columns/70080/3): > > I typically use or recommend the following method: Make sure there is a Row ID column. Create a single Relation or Query to link similar rows to themselves based on similar values. Create a Lookup or Single Value column to retrieve the first matching Row ID from the Relation/Query. Finally create an IF column comparing the row’s Row ID to the Lookup/Single Value column and return true if there is a match. Only the first occurrence will be a match. ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [May 13, 2024, 9:03pm UTC](https://community.glideapps.com/t/unique-values-only/73329/3 "2024-05-13T21:03:26Z")
Welcome to Glide 👋 In the Data Editor: 1. Add a RowID to the Opportunity table. 2. Relate the Opportunity column to itself. Make sure the relation is **not** match multiple. 3. Create a Look Up column and look up the Row ID through the Relation. You will now have a RowID appear for the first item of repeating items. 4. Create an If-Then-Else column: if RowIDLookUp is RowID then true else ‘null’ In the Layout Editor On collection displaying Opportunities, filter by “If-Then-Else column is true”. The result is that the user is downloading the entire “Work Oders - Opportunities” table and it is being filtered on the users device to only show the 1st item of repeating items. ---
**Author:** ![robbielobster](https://avatars.discourse-cdn.com/v4/letter/r/eada6e/32.png) [@robbielobster](https://community.glideapps.com/u/robbielobster)\ **Post date:** [May 14, 2024, 7:26am UTC](https://community.glideapps.com/t/unique-values-only/73329/4 "2024-05-14T07:26:07Z")
Thanks so much - I’ve never seen such quick responses! This works a treat. Brilliant. ---
**Author:** ![robbielobster](https://avatars.discourse-cdn.com/v4/letter/r/eada6e/32.png) [@robbielobster](https://community.glideapps.com/u/robbielobster)\ **Post date:** [May 14, 2024, 7:27am UTC](https://community.glideapps.com/t/unique-values-only/73329/5 "2024-05-14T07:27:24Z")
Thanks Jeff. I think this is the same method that Nathan suggested, the numbered list made it a little bit easy for a newbie like me to follow! ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [May 14, 2024, 11:46am UTC](https://community.glideapps.com/t/unique-values-only/73329/6 "2024-05-14T11:46:06Z")
Just so you know, you can click into shared posts in the forum. Mine isn’t numbered, but it has bullet points when you click into it.