Count the number of Records in a Subgrid

(0) Share

Report

Posted on by Community Member

I am hoping someone can shed some light on my problem. I am using the OOTB entity "CASE", I have a customer entity called "SAMPLE". One Case can have many Samples.

On the case form I have a field called "Sample Count". The following code calculates the number of records in the subgrid on the case form and adds the value into the Count Field.

I have this code called "onSave" and "onLoad" of the case form.

However, my issue is the sample count does not seem to calculate onload, It updates instantly when I save the case form.

In my case this is not sufficient, for example if I create a sample from a case and then save and close the sample...I come back to the case form BUT I need to save before the count is correct.

function CountNumSamples() {
    if (document.getElementById('Samples')!= null) {
        var count=document.getElementById('Samples').control.get_totalRecordCount();
		var x = parseInt(count);
		Xrm.Page.getAttribute("samplecount").setValue(x);
		Xrm.Page.getAttribute("samplecount").setSubmitMode("always");
		
        }
        else {
            setTimeout("CountNumSamples()", 1000);
        }
    }

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

RE: Count the number of Records in a Subgrid

Hello,

Just curious - why don't you use Rollup field? It will be much more easier to use and this will be no-code solution.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Count the number of Records in a Subgrid

Do rollup fields exist in CRM 2013?

Was this reply helpful? Yes No
Suggested answer

saadzag 1,145 on at

Like (0)

Report
RE: Count the number of Records in a Subgrid

Hi,

You can use an On load event.

example:

var myContactsGridOnloadFunction = function () { console.log("Contacts OnLoad occurred") }; Xrm.Page.getControl("Contacts").addOnLoad(myContactsGridOnloadFunction);

every time you subgrid refreshes you call the get_totalrecordcount

Regards

Saad

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

RE: Count the number of Records in a Subgrid

No, Rollup and Calculated fields were released later. Now I see that you tagged post with CRM 2013. My fault.

If you want to make your solution solid as a rock you should rework your approach to use Plugins instead of JavaScript.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Count the number of Records in a Subgrid

Can you help me with incorporating this using my code example and variable names?

am sure console.log is C# not javascript?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Count the number of Records in a Subgrid

Unfortunately plugins are not an option here...

any other ideas..greatly appreciated

Was this reply helpful? Yes No
Suggested answer

nilesh karale 132 on at

Like (2)

Report

RE: Count the number of Records in a Subgrid

Hi,

Please use below sample code to get the count of records from subgrid on load

// Sample Code

function ContactSubGridCount() {
setTimeout(function () {

if (Xrm.Page.getControl("Contacts") != undefined) {
var contactCount = Xrm.Page.getControl("Contacts").getGrid().getTotalRecordCount();

Xrm.Page.getAttribute("new_noofcontacts").setValue(contactCount);
Xrm.Page.getAttribute("new_noofcontacts").setSubmitMode("always");

};
}, 2000);
}

Was this reply helpful? Yes No
Suggested answer

Rawan Ismail on at

Like (0)

Report

RE: Count the number of Records in a Subgrid

Worked perfectly on Dynamics 365

Was this reply helpful? Yes No
naZir 850 on at

Like (0)

Report

RE: Count the number of Records in a Subgrid

You can try this code.

function getTotalGridRecordCount()
{
debugger;
var functionName="onLoad";
try{
setTimeout( function(){
if (Xrm.Page != null && Xrm.Page != undefined && Xrm.Page.getControl("accountopportunitiesgrid") != null && Xrm.Page.getControl("accountopportunitiesgrid") != undefined) {
var count=Xrm.Page.getControl("accountopportunitiesgrid").getGrid().getTotalRecordCount();
alert(count);}},5000);
}
catch(e)
{
Xrm.Utility.alertDialog(functionName + "Error: " +e.message || e.description);
}
}

Was this reply helpful? Yes No
Ahmad Saud 790 on at

Like (0)

Report

RE: Count the number of Records in a Subgrid

thanks.

Was this reply helpful? Yes No