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 - 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.

[image] Filter to display DISTINCT (or Unique) rows based on specified columns Feature Requests 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.

Welcome to Glide :wave: In the Data Editor: Add a RowID to the Opportunity table. Relate the Opportunity column to itself. Make sure the relation is not match multiple. 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. 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.

Thanks so much - I’ve never seen such quick responses! This works a treat. Brilliant.

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!

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.

Unique Values only?

Ask for Help

Jeff_Hager May 13, 2024, 9:02pm 2

Topic		Replies	Views
Filter to display DISTINCT (or Unique) rows based on specified columns Feature Requests	5	4000	June 18, 2024
Copying columns unique values to new column Ask for Help	3	414	June 22, 2023
Removing duplicates Ask for Help	10	150	November 24, 2024
Showing one row of many Ask for Help	14	468	December 29, 2021
Select colA from Glide Table Ask for Help	2	245	June 22, 2023

Unique Values only?

Related topics