
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 23, 2024 12:40 PM
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! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 23, 2024 05:23 PM
Create a rollup field that points to the order date field, and use this formula:
MAX(values)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 23, 2024 11:14 PM
 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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 23, 2024 05:23 PM
Create a rollup field that points to the order date field, and use this formula:
MAX(values)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 23, 2024 11:14 PM
 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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 24, 2024 05:14 AM
Thank you both for taking the time to reply. Makes sense
Mike
