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	1521	January 17, 2024
Lookup with a multiple relation column Ask for Help	8	1725	February 10, 2020
Inline within Inline Ask for Help	2	464	May 6, 2020
Showing one row of many Ask for Help	15	371	December 29, 2021
How to show Unique Item? Ask for Help	3	173	October 11, 2023

Join Lookup and Show Unique Results Only

Related topics