Help

Most Recent Date from another table

36360 21
cancel
Showing results for 
Search instead for 
Did you mean: 
Ben_Moore
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

21 Replies 21
Ami_Price
4 - Data Explorer
4 - Data Explorer

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

Christhian_Diaz
4 - Data Explorer
4 - Data Explorer

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.