Help

Re: Filter by most recent record

Solved
Jump to Solution
2043 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Joseph_Desilets
4 - Data Explorer
4 - Data Explorer

I have a Base with the following tables: People, Contact History. In Contact History I am logging all conversations with the people from the first table and many times there are multiple records in Contact History for every person in the People table.

I am trying to show in the People table just the notes from the most recent contact with that person.

As I understand it, I can’t use a rollup field to do this because it’s a string.

Any advice pointing me in the right direction would be greatly appreciated!

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

Welcome to the community, @ Joseph_Desilets! :grinning_face_with_big_eyes:

No, but you could use a collection of rollup fields to get what you need. Here’s where I’m starting, with three contact records tied to one person:

10%20PM

I’m using a simple date-name formula for the primary field in the [Contact History] table:

30%20PM

The first thing to add in the [People] table is a rollup that finds the latest note date:

50%20PM

44%20PM

In the [Contact History] table, add a rollup that pulls this value back in. It doesn’t need to be formatted, so I just use values by itself for the aggregation function.

37%20PM

10%20PM

Now add a formula field to [Contact History] that only shows the text from the record matching this date:

20%20PM

15%20PM

Finally, go back to the [People] table and add one more rollup to pull in this text:

27%20PM

49%20PM

Hide all the helper fields and you’re done.

See Solution in Thread

1 Reply 1
Justin_Barrett
18 - Pluto
18 - Pluto

Welcome to the community, @ Joseph_Desilets! :grinning_face_with_big_eyes:

No, but you could use a collection of rollup fields to get what you need. Here’s where I’m starting, with three contact records tied to one person:

10%20PM

I’m using a simple date-name formula for the primary field in the [Contact History] table:

30%20PM

The first thing to add in the [People] table is a rollup that finds the latest note date:

50%20PM

44%20PM

In the [Contact History] table, add a rollup that pulls this value back in. It doesn’t need to be formatted, so I just use values by itself for the aggregation function.

37%20PM

10%20PM

Now add a formula field to [Contact History] that only shows the text from the record matching this date:

20%20PM

15%20PM

Finally, go back to the [People] table and add one more rollup to pull in this text:

27%20PM

49%20PM

Hide all the helper fields and you’re done.