Skip to main content

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

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

MAX(values)

 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

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

Mike

Reply


Terms & Conditions