Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Rollup based on max date in source table

Jump to Solution
218 2
Showing results for 
Search instead for 
Did you mean: 

I have 2 tables…

CompanyID, CompanyName, ContractIDs

ContractID, ContractTitle, EffectiveDate, ExpirationDate, CompanyID

They’re linked together via the final field in each table where 1 Company can have multiple Contracts.

I want to create a field in the Companies table to display the ContractTitle of the most recent contract but am struggling to find a solution using Rollups. Of course, I can add a field to Companies using a Rollup that takes the MAX(ExpirationDate) to at least give the latest contract expiry, but I can’t find a way to use that expiry to bring back the single ContractTitle field with that expiry per Company.

Appreciate any thoughts at all on whether this is possible!

1 Solution

Accepted Solutions

I cover this process step-by-step in this video podcast:

See Solution in Thread

2 Replies 2

I cover this process step-by-step in this video podcast:

Thank you that worked perfectly - also learnt about View sections by accident which sound very useful!