Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum
Answered

Repeat Clients

Posted on by 25

Hello,

I am seeking the easiest solution to generate a list of repeat clients in CRM based on the projects we’ve competed with them. The reporting module does not allow me to add conditions, for instance, any client with more than one project is considered a repeat client. Does anyone have a solution to this? Your help is greatly appreciated!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Repeat Clients

    Hi CWDdkops ,

    Can you click Yes under "Did this answer your question?" to close this thread if my answer is helpful.

     pastedimage1636334205581v1.png

    Thanks in advance.

  • CWDdkops Profile Picture
    CWDdkops 25 on at
    RE: Repeat Clients

    This is great! Thank you so much! After 12 hours, I verified that the roll up field is working. I’ll look into readjusting the occurrence. Have a wonderful weekend!

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Repeat Clients

    Hi CWDdkops,

    Yes, you are right.

    Rollup fields are calculated by scheduled system jobs that run asynchronously in the background. The jobs can be viewed and managed by an administrator. There are two types of system jobs:

    (1) Mass Calculate Rollup Field job that runs once per rollup field 12 hours after you created or updated a rollup field.

    If you don't want to wait 12 hours, you can go Settings > System Jobs to find Mass Calculate Rollup Field job for the new craeted rollup field to Resume it.

    (Dynamic CRM follows specific naming convention for Rollup Jobs.EntityName.FieldName)

    pastedimage1636082273505v3.png

    (2) Calculate Rollup Field job that runs per entity and recalculates all rollup fields for that entity by processing the records that were created, updated or deleted since the last recalculation. The default maximum recurrence setting is one hour.

    If you want to modify recurrence, you need find Calculate Rollup Field job for current entity.

    Changing the recurrence is supported only at entity level and not on single field. So, opening the Calculate Rollup Field Job will give me this.

    pastedimage1636084387568v1.png

    Also, It is possible to manually recalculate individual rollup fields by choosing the Refresh icon next to the rollup field on the entity form. User must have write access to the record on which refresh is requested.

    For more details, you can refer following link:

    Create rollup fields in Dynamics 365 Customer Engagement (on-premises) | Microsoft Docs

  • CWDdkops Profile Picture
    CWDdkops 25 on at
    RE: Repeat Clients

    Thank you very much, Leah! I went ahead and created a rollup field. Looks like it'll take 12 hours for CRM to update if I'm not mistaken.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Repeat Clients

    Hi CWDdkops ,

    Firstly, you can create a rollup field to count the number of related projects:

    (+) Count the of number related child records using a Rollup field - Microsoft Dynamics CRM Community

    pastedimage1636011987687v1.png

    Test:

    pastedimage1636012753109v4.png

    Now, you can use 'greater than 1' as condition to filter records:

    pastedimage1636012776658v5.png

    Result:

    pastedimage1636012790756v6.png

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans