Hi Chris,
Isn't
var rows = Xrm.Page.getControl("Contacts").getGrid().getRows();
the same as
var productGrid = Xrm.Page.getControl("subgrid_products").getGrid();
var productRows = productGrid.getRows(); // this always returns 0I used that example to write this code but it doesn't work as detailed in that code sample.
The problem is not the getRows(). getRows() always returns an object the problem is that forEach never returns an object from the collection.
A second problem I found is that productRows.getLength() always returns 0 when the subgrid OnLoad first calls the function.
This is how I finally managed to get this working:
CalculateLeadProductsTotal: function () {
var productGrid = Xrm.Page.getControl("subgrid_products").getGrid();
var productRows = productGrid.getRows();
var rowCount = productRows.getLength();
var total = 0;
if (rowCount == 0) {
setTimeout(FBCrm.Lead.CalculateLeadProductsTotal, 2000);
return;
}
for (var i = 0; i < rowCount; i++) {
var rowEntity = productRows.get(i).getData().getEntity();
var listPrice = rowEntity.getAttributes().get("price").getValue();
total += Number(listPrice.replace(/[^0-9\.]+/g, ""));
}
/* This is not working as documented in the sdk documentation
productRows.forEach(function (attribute, index) {
var rowEntity = attribute.getData().getEntity();
var listPrice = rowEntity.getAttributes().get("price");
total += Number(listPrice.replace(/[^0-9\.]+/g, ""));
});
*/
Xrm.Page.getAttribute("cust_totalprice").setValue(total);
Xrm.Page.getAttribute("cust_totalprice").setSubmitMode("always");
},
Tony
Tony
