Get latest order for a customer

[Mike_Ball]

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

[ScottWorld · Accepted solution]

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

MAX(values)

[TheTimeSavingCo · Accepted solution]

 Yeap, you can use a rollup field for that!

 

Link to base

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

[Mike_Ball]

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

Mike