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!