Help

Get latest order for a customer

Topic Labels: Base design
Solved
Jump to Solution
298 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