Attach OnClick event in Sub grid Records MS CRM 2013 Using JavaScript !!!

Sometimes we have requirements to attach click event to sub-grid. So we could read selected record data and do the stuffs.

Here is sample code to attach click event to sub grid :

function ReadSelectedSubGridRecords() {

    if (document.getElementById("SubGridName")) {

        var grid = document.getElementById("SubGridName").control;

        for (var rowNo = 0; rowNo < grid.get_selectedRecords().length; rowNo++)

            alert(grid.get_selectedRecords()[rowNo].Name);

    }

}

function Form_OnLoad() {

    if (document.getElementById("SubGridName")) {

        var grid = document.getElementById("SubGridName");

        // Google chrome

        if (grid.addEventListener) {

            grid.addEventListener('click', ReadSelectedSubGridRecords, false);

            // IE

        } else if (grid.attachEvent) {

            grid.attachEvent('onclick', ReadSelectedSubGridRecords);

        }

    }

    else {

        setTimeout("Form_OnLoad();", 2000);

    }

}

Attach Form_OnLoad function to form OnLoad event handler !!!

Read Selected Sub grid Records MS CRM 2013 Using JavaScript !!!

Sometimes we have requirements to play with selected sub-grid records using client side scripting.

Here is same code to read selected sub-grids records :

function ReadSelectedSubGridRecords() {

        if (document.getElementById("SubGridName")) {

        var grid = document.getElementById("SubGridName").control;

        for (var row = 0; row < grid.get_selectedRecords().length; row++)

            alert(grid.get_selectedRecords()[row].Name);

    }

}

Read SubGrid Records MS CRM 2013 using JavaScript !!!

Many times we have requirements to read sub grid records and do subtotal or some others stuff with grid data. Here is same code to retrieve entire rows and columns from SubGrid.

function RetrieveSubGridRecords() {

    if (document.getElementById("SubGridName")) {

        var grid = document.getElementById("SubGridName").control;

        for (var rowNo = 0; rowNo < grid.GetRecordsFromInnerGrid().length; rowNo++)

            for (var cellNo = 0; cellNo < grid.GetRecordsFromInnerGrid()[rowNo][3].cells.length; cellNo++)

                alert(grid.GetRecordsFromInnerGrid()[rowNo][3].cells[cellNo].outerText);

    }

    else {

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

    }

}

Hope it helps. J

Retrieve account record based on account Id using SOAP request MS CRM 2011 !!!

Here is the same to code to get account record based on account Id using SOAP request.

function ExecuteRequest(_XML, Message) {

try {

var _ResultXML = null;

var xmlhttp = new XMLHttpRequest();

xmlhttp.open("POST", Xrm.Page.context.getServerUrl() + "/XRMServices/2011/Organization.svc/web", false);

xmlhttp.setRequestHeader("Accept", "application/xml, text/xml, */*");

xmlhttp.setRequestHeader("Content-Type", "text/xml; charset=utf-8");

xmlhttp.setRequestHeader("SOAPAction", "http://schemas.microsoft.com/xrm/2011/Contracts/Services/IOrganizationService/" + Message);

xmlhttp.send(_XML);

_ResultXML = xmlhttp.responseXML;

var errorCount = _ResultXML.selectNodes('//error').length;

if (errorCount != 0) {

var msg = resultXml.selectSingleNode('//description').nodeTypedValue;

alert(msg);

_ResultXML = null;

return _ResultXML;

}

else {

return _ResultXML;

}

}

catch (Err) {

alert(Err);

return;

}

}

function GetAccountName() {

var request = "<s:Envelope xmlns:s='http://schemas.xmlsoap.org/soap/envelope/'>" +

"<s:Body>" +

"<Retrieve xmlns='http://schemas.microsoft.com/xrm/2011/Contracts/Services' xmlns:i='http://www.w3.org/2001/XMLSchema-instance'>" +

"<entityName>account</entityName>" +

"<id>44b1719c-4440-e311-8fae-00221960bc47</id>" +

"<columnSet xmlns:a='http://schemas.microsoft.com/xrm/2011/Contracts'>" +

"<a:AllColumns>false</a:AllColumns>" +

"<a:Columns xmlns:b='http://schemas.microsoft.com/2003/10/Serialization/Arrays'>" +

"<b:string>name</b:string>" +

"<b:string>accountnumber</b:string>" +

"</a:Columns>" +

"</columnSet>" +

"</Retrieve>" +

"</s:Body>" +

"</s:Envelope>";

var _ResultXML = ExecuteRequest(request, "Retrieve");

var _AccountName = _ResultXML.selectSingleNode("//a:Attributes").selectSingleNode("//b:value").text;

return _AccountName;

}

You could call GetAccountName function to get account name like :

Var _Name= GetAccountName();

You could also pass accountId as parameter to GetAccountName function.