Most Recent Date from another table

[Ben_Moore]

First—FINALLY! I have spent months looking at various online tables and database systems, and would get partway through, and felt like it just didn’t offer what we needed. I stumbled on Airtable and it is the only one that did what I was hoping with EASE and without hours and hours of figuring things out.

I have 2 tables. Table 1 is client data information. Table 2 is a dates of contact. Is there a way for table 1 to display the most recent date of contact from table 2 for each individual. I attempted Max, but it did not work. I do have a look up of all the dates taken, but it shows them all, not just the most recent. I’d appreciate any suggestions.

Thanks.

[Ami_Price]

Thank you Zoelle! Ditto to the same problem and it worked!

[Christhian_Diaz]

What if I want to call up the second to last most recent date? Is there a way to use the roll up field and MAX(values) formula to do this?

Especifically, when a new record is created, I want to be able to rollup data from the previous record.