Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Tracking last time a phone call was made to an account

Posted on by 5

Hi everyone,

I'm hoping someone here may have some inspiration to help us build a query.

We're trying to run queries like "Show me any ACCOUNT that has not gotten a phone call in X days."  (We want this field to update for any 'phone call' activity to any contact who belongs to the account.)

Some context:

  • We have accounts where there are between 2 and 20 different contacts at a given organization/account.
  • Our staff will press the 'add phone call' button on contact record (for a contact that 'belongs' to the account.)  These calls are logged on the contact record, and are visible in the timeline on the account record. 

Our goal:

  • To accomplish this, we're working to build a custom data field on the Account, which will be called "Most recent phone call."  This data field SHOULD update to the date of the most recent phone call activity done to any contact that is associated with the account.  (incoming or outgoing, doesn't matter)
  • This will open up all kinds of dashboards and views to help our team drive their activities, and make sure accounts are being contacted regularly.

Can someone help with the logic, to help us build this data field that updates as described above?   Thank you!

  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,964 Super User 2024 Season 1 on at
    RE: Tracking last time a phone call was made to an account

    HI,

    You should be able to achieve your requirement using Rollup field.

    Please see below blog for more information -

    www.encorebusiness.com/.../

    Please mark my answer verified if this is helpful!

    Regards,

    Bipin Kumar

    Follow my Blog: xrmdynamicscrm.wordpress.com/

  • Suggested answer
    Nettsales Profile Picture
    Nettsales 112 on at
    RE: Tracking last time a phone call was made to an account

    We've done this for a number of clients and the best way we've found is to run a flow or workflow every time a phone call is logged as made against a contact.

    The function updates a field in the related account of that contact with the execution time.  This field is your "Last Called on Date".

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans