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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
ScottDurow Profile Picture

ScottDurow 2

#2
GJones Profile Picture

GJones 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans