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
Solved
Get latest order for a customer
Best answer by ScottWorld
Create a rollup field that points to the order date field, and use this formula:
MAX(values)
+35Create a rollup field that points to the order date field, and use this formula:
MAX(values)
+31Yeap, 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
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.