Posts

Showing posts from November, 2021

Get last task or event date against multiple contacts in Salesforce (on create/update)

Image
    Quite often a question bothers  business  users as well as functional experts how to get latest event/task date for a particular contact in Salesforce and plan a communication based on contact activity report, like ones with last activity past one month etc. Last modified date or only Last activity date on Salesforce record is not a true indication of latest communication done with that contact/lead/account. Its actually the latest event or task associated with respective lead, contact or account. The document below explains setup and technical implementation of the same. This might sound easy, but it’s not easy as just go and put LastModifiedDate of that Contact on Report. It’s bit challenging.  Every time we got  Task Created Date  of a particular Task which is associated to that Contact or Account on insert/update. Getting right Last Task Created Date for Task which is associated with 2 or more Contacts becomes challenging, as by default it takes first contact associated to