Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Most Recent Date from another table

53582 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.