Obtaining 1st Record
I have a contacts database that is related to a contacts_actitity datebase where out sales team records all points of contact with each contact. I'm looking for a way to get only information from the very first record of activity with the contact. The activites are seen in a portal on the contacts layout based on their relationship by id. Each activity does have a creatad date but i'm not sure how to set up a calculation to tell if it's the first record or not.
I'm wanting somehow to make a list view of only the contacts that we're contacted the first time during a date range.
I have the date range but i can't figure out how to tell if it's their first contact or not.
Is there a way to pull this?