web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Roll up field based on...
Microsoft Dynamics CRM (Archived)

Roll up field based on owner of the record

(0) ShareShare
ReportReport
Posted on by z.sam 299

Hello,

I've got a custom entity named file, that based on the owner field, every file is owned by an user.

And there is another entity called basket, that I'll have to save the number of files owned by each user to a filed of it called count of user files.

I've already done this on the user entity with a roll up field, but how could this be done on the basket entity?

Thanks 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    a33ik Profile Picture
    a33ik 84,331 Most Valuable Professional on at

    Hello,

    I don't think that you can do it with OOB rollup fields.

  • z.sam Profile Picture
    z.sam 299 on at

    Thanks dear Andrew Butenko

    Ok if this can't be done on the basket entity, I can count the files owned by each user with a roll up field on the user entity. is it possible to somehow on the change of this field I update an exact field on the basket entity.

    Best regards

  • RaviKashyap Profile Picture
    RaviKashyap 55,410 Moderator on at

    Hi z.sam,

    What is the relationship between file & basket entity? Do you have a field "Basket" on "File" or field "File" on "Basket" or something else?

  • z.sam Profile Picture
    z.sam 299 on at

    Thanks dear Ravi Kashyap, 

    I have the field  "File" on "Basket" , it means that every user has a basket and some files in his/her basket.

    Thanks alot

  • Suggested answer
    RaviKashyap Profile Picture
    RaviKashyap 55,410 Moderator on at

    Hi,

    If "it means that every user has a basket and some files in his/her basket." shouldn't you have a field "Basket" on "File" entity that way you can say that the file is for this basket.

    You can then do a roll up field on the basket entity to show the count of file?

    Hope this helps.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans