Microsoft Dynamics CRM (Archived)

Get Subgrid Count when records get add to Subgrid

(0) Share

Report

Posted on by Shahbaaz Ansari

6,211

Hi All,

I want to get the total no of records in subgrid on page load and when

any record gets added to subgrid. Dynamics CRM(8.2 online)

Best Regards,

Shahbaaz

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

NODAL 860 on at

Like (0)

Report

RE: Get Subgrid Count when records get add to Subgrid

Hi shahbaz,

No it is not deprecated you can find it in version 8.2 sdk message excel.

If the relationship is n: n then use this otherwise create and delete message on sub grid entity will work.

Was this reply helpful? Yes No
Suggested answer

Shahbaaz Ansari 6,211 on at

Like (0)

Report

RE: Get Subgrid Count when records get add to Subgrid

Hi nodal,

Associate and disassociate message has been deprecated from crm 2013(please correct me if I'm wrong).

Thanks,

Shahbaaz

Was this reply helpful? Yes No
NODAL 860 on at

Like (0)

Report

RE: Get Subgrid Count when records get add to Subgrid

Hi Shahbaaz,

Can you try a single plugin on association and disassociation message to populate both count and other operation you want to do on count field change.

Regards,

Nodal

Was this reply helpful? Yes No
Rawish Kumar 13,758 on at

Like (0)

Report

RE: Get Subgrid Count when records get add to Subgrid

Yes thats correct. In this case, please use Javascript!

Was this reply helpful? Yes No
Shahbaaz Ansari 6,211 on at

Like (0)

Report

RE: Get Subgrid Count when records get add to Subgrid

Thanks for the suggestion, i want to trigger plugin as soon as the i add record in subgrid, will it work with rollup field? because rollup fields are calculated via an Async Process so this might take time.

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (1)

Report

RE: Get Subgrid Count when records get add to Subgrid

Hi Shahbaaz ,

You can call REST API , to get the subgrid data using entity id , I think this is better way to get the total record count .

Was this reply helpful? Yes No
Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report

RE: Get Subgrid Count when records get add to Subgrid

Hi Shahbaaz,

Above code is fine. However, unlike Calculated fields, you can trigger a plugin on a rollup field. So its up to you if you want to use a rollup field or the javascript :)

Was this reply helpful? Yes No
Verified answer

Shahbaaz Ansari 6,211 on at

Like (0)

Report

RE: Get Subgrid Count when records get add to Subgrid

Thanks Rawish for the response, i wanted to do it using javascript because i wanted to update a field value and trigger plugin, that wont work with rollup field(please correct if i am wrong).

I have used below code on page load to get the count of the subgrid using javascript and set timeout so when ever any record gets added to it, it will update the field.

NOTE : i tried "Xrm.Page.getControl("ZipcodeGrid").getGrid().getTotalRecordCount();" code on editable subgrid and it was not working so i posted the question, then i removed the editable subgrid and used nornal grid and it was working with this code "Xrm.Page.getControl("ZipcodeGrid").getGrid().getTotalRecordCount();"

Hope this helps someone!!!

//below is the function

function GetGridCount()

var zipcodeSubgridCount = Xrm.Page.getControl("ZipcodeGrid").getGrid().getTotalRecordCount();

Xrm.Page.getAttribute("ewt_subgridcount").setValue(zipcodeSubgridCount.toString());

setTimeout("GetGridCount()", 5000);

}

Thanks,

Shahbaaz

Was this reply helpful? Yes No
Suggested answer

Rawish Kumar 13,758 on at

Like (1)

Report

RE: Get Subgrid Count when records get add to Subgrid

Hi Shahbaaz,

How about you use a simple rollup field to count child records?

community.dynamics.com/.../count-the-number-related-child-records-using-a-rollup-field

let me know if its something you aint looking for.

Was this reply helpful? Yes No