So for a Bit of Context; I added a delivery tab in My app to show all upcoming ‘Container’ Deliveries. Each ‘Container’ Contains Multiple ‘Pallets’, Each Pallet belongs to a different “Project”. So I Created a lookup to Show the “Project” for all Related Results, and then a Join, for it to show u…

You can do it like this; Add a rowID column if you haven’t done so. Create a relation using the “Project” column, relate that to itself, let it be a multiple match. Have a single value column, let’s name it “First ID”, return the first rowID from the Project relation above. Have an If Then Else…

Join Lookup and Show Unique Results Only

Ask for Help

Robert_Petitto October 21, 2021, 10:19pm 4

Actually…maybe I misunderstood your request. Does this help:

1 Like

Topic		Replies	Views
How to only pull unique values from a list Ask for Help	8	1502	January 17, 2024
How to show Unique Item? Ask for Help	3	169	October 11, 2023
Joined List with only unique values Ask for Help	9	345	February 5, 2024
How do I remove duplicate row in leaderboard Ask for Help	20	443	February 12, 2023
Showing one row of many Ask for Help	15	357	December 29, 2021

Join Lookup and Show Unique Results Only

Related topics