Customer experience | Sales, Customer Insights,...

ms crm plugin question

(0) Share

Report

Posted on by Community Member

Entity A has whole number field called wholenumber. Entity A also have subgrid. when the new record is created in the subgrid it should fetch the count from subgrid and update it to the wholenumber field. using plugin.

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Vipin J 1,603 on at

Like (0)

Report
Copy link

Link copied!

your requirement can be fulfilled using a Rollup field.

Here are some articles which can help you understand about it.

Generic way to Refresh Rollup field in Dynamic CRM - https://vjcity.blogspot.com/2020/03/refreshing-rollup-field-using-javascript.html

Dissecting Rollup Fields in Dynamic 365 - https://vjcity.blogspot.com/2019/06/dissecting-rollup-fields-in-dynamic-365.html

How to change the frequency for rollup field in Dynamic 365 - https://vjcity.blogspot.com/2019/06/how-to-change-frequency-for-rollup.html

Here is how you can create a plugin in Dynamic CRM - Plugin in Dynamic 365 CRM - https://vjcity.blogspot.com/2021/12/plugin-in-dynamic-365-crm.html

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

without using rollup field .can u suggest me using plugin?

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,985 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Register your plugin on Post create of Subgrid entity -

First retrieve Entity A guid from Target context and then use below.

Now in you plugin logic, you will use fetchxml to find count of the records and then update the count in Entity A.

Subgrid entity will have Entity A lookup.

What if Record is getting deleted from subgrid, do you want to again update the count?

If yes then you may have to write code to do that

Please mark my answer verified if this is helpful!

Regards,

Bipin Kumar

Follow my Blog: xrmdynamicscrm.wordpress.com/

Was this reply helpful? Yes No
Mohsin Ali 3,634 on at

Like (0)

Report
Copy link

Link copied!

There are two ways you can use it.

1. Add a rollup field into 'Entity A' to replace the whole number field.

2. To achieve it through the plugin, at post-operation of CREATE message of that subgrid record register the plugin. Count all records and then update the whole number field with a total number of associated records from subgrid.

Was this reply helpful? Yes No