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
Showing one row of many Ask for Help	15	357	December 29, 2021
How to show Unique Item? Ask for Help	3	169	October 11, 2023
Sum Based on Unique Values Ask for Help	3	191	January 15, 2024
How do I remove duplicate row in leaderboard Ask for Help	20	442	February 12, 2023
🆕 Joined List column ready in production Ask for Help	25	3121	September 11, 2021

Join Lookup and Show Unique Results Only

Related topics