Dynamics Community Forum Thread Details

Verified answer

Sreevalli 3,264 on at

Like (1)

Report
Copy link

Link copied!

Hi Mahesh,

I think form is loading before subgrid loads.

You can get number of rows in supported way using Xrm.Page.getControl("gridname").getGrid().getTotalRecordCount() by adding timeout before for the javascript code because subgrid takes some time to load after the form is loaded.

example:

setTimeout("RetrieveSubGridRecords();", 2500);

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

thanks, but the most recent record should populate in the other field

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

thanks, but the most recent record from subgrid it should populate in the other field

Was this reply helpful? Yes No
Verified answer

necsa 3,455 on at

Like (0)

Report
Copy link

Link copied!

Hi, Please try this code:

function getTotalGridRecordCount(executionContext){

debugger;

try{

setTimeout(function(){

var formContext=executionContext.getFormContext();

if(formContext.getControl("GridName")!=null && formContext.getControl("GridName")!=undefined){

var count=formContext.getControl("GridName").getGrid().getTotalRecordCount();

alert("total record in Grid: " + count);

}

},5000);

}

catch(e){

var alertOptions={height:120,width:260};

Xrm.Navigation.openAlertDialog(e.message,alertOptions).then(function(){});

}

}

Was this reply helpful? Yes No
Suggested answer

Mahadeo Matre 17,021 on at

Like (0)

Report
Copy link

Link copied!

In case you want to show count in some other field then why you are not using rollup field.

CRM will calculate no of records from related subgrid and count will be shown in rollup field.

User can manually refresh this field whenever they need to see count otherwise CRM will recalculate this field every hour.

Here are more details on rollup field

docs.microsoft.com/.../define-rollup-fields

Was this reply helpful? Yes No
Verified answer

gdas 50,091 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Mahesh,

Please have a look Rawish blog , its working and make sure if your environment is slow then increase timeout 500 to 1000 or 2000.

community.dynamics.com/.../count-total-subgrid-records-in-dynamics-crm-using-javascript

Hope this helps.

Was this reply helpful? Yes No