Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

I want to roll up only the n-th of the linked record

Topic Labels: Base design
Solved
Jump to Solution
672 2
cancel
Showing results for 
Search instead for 
Did you mean: 
kennypurnomo
7 - App Architect
7 - App Architect

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

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Did you face any issues when attempting to use the "Limit to the last 1" option?  It should do exactly what you need

Screenshot 2024-03-15 at 6.49.44 PM.png

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

Did you face any issues when attempting to use the "Limit to the last 1" option?  It should do exactly what you need

Screenshot 2024-03-15 at 6.49.44 PM.png

My bad. I didn't know this existed. Thanks!