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: Pe…

[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 va…

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 repe…

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	7	3792	June 18, 2024
Copying columns unique values to new column Ask for Help	3	390	June 22, 2023
Removing duplicates Ask for Help	10	100	November 24, 2024
Showing one row of many Ask for Help	15	399	December 29, 2021
Select colA from Glide Table Ask for Help	3	225	June 23, 2023

Unique Values only?

Related topics