Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Get latest order for a customer

Topic Labels: Base design
Solved
Jump to Solution
1099 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Mike_Ball
6 - Interface Innovator
6 - Interface Innovator

Hi

I have two tables Customers and Orders.  They are linked on CustID

I want to be able to find the latest order date (Order Date) for each customer

Any ideas
Thanks
Mike

2 Solutions

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

Create a rollup field that points to the order date field, and use this formula:

MAX(values)

See Solution in Thread

TheTimeSavingCo
18 - Pluto
18 - Pluto

 Yeap, you can use a rollup field for that!

 Screenshot 2024-02-24 at 3.12.50 PM.png

Screenshot 2024-02-24 at 3.12.55 PM.png

Link to base

And here's the documentation for rollups: https://support.airtable.com/docs/rollup-field-overview

See Solution in Thread

3 Replies 3
ScottWorld
18 - Pluto
18 - Pluto

Create a rollup field that points to the order date field, and use this formula:

MAX(values)

TheTimeSavingCo
18 - Pluto
18 - Pluto

 Yeap, you can use a rollup field for that!

 Screenshot 2024-02-24 at 3.12.50 PM.png

Screenshot 2024-02-24 at 3.12.55 PM.png

Link to base

And here's the documentation for rollups: https://support.airtable.com/docs/rollup-field-overview

Mike_Ball
6 - Interface Innovator
6 - Interface Innovator

Thank you both for taking the time to reply. Makes sense

Mike