Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 15, 2024 01:15 AM
Hi,
I have a table named "Customer" whose field is "Address"
I also have a table named "Invoice" where the associated fields are "Target Customer" where it is linked to "Customer" table and it can linked to many customers; and "Latest Address" which is a roll up field.
In my case, i only want to retrieve the last address of the last linked customer. So if i have ["Customer1","Customer2"] in "Target Customer", the "Latest Address" must be Customer2's address only.
How can i achieve this?
Note: Customer1 and Customer2 are not related to any created time or updated time or any min max value. The sequence is totally random. Thank you
Solved! Go to Solution.
Mar 15, 2024 03:50 AM
Did you face any issues when attempting to use the "Limit to the last 1" option? It should do exactly what you need
Mar 15, 2024 03:50 AM
Did you face any issues when attempting to use the "Limit to the last 1" option? It should do exactly what you need
Mar 15, 2024 03:52 AM
My bad. I didn't know this existed. Thanks!