Dynamics Community Forum Thread Details

I want to populate lookup value in child entity subgrid which has also this lookup field

I have a lookup field on parent entity which should be populated in all existing or newly created record in child entity which present as a subgrid in parent entity form. So,

basically populate all subgrid record with the lookup value (field) present on the main form

Can I get the sample javascript code to do it?

Thanks in Advance.

Categories:

Sales

Development / Customization / SDK

I'm not sure this is the best code, but it should work as I do similar in my model driven app. Xrm.Page is deprecated so I think this should be updated.

function populateLookupChildRecords() {
var parentRecordId = Xrm.Page.data.entity.getId();
var lookupValue = Xrm.Page.getAttribute("new_lookupfield").getValue();

// Get the child entity records
var childRecords = Xrm.Page.getControl("childentity_subgridname").getGrid().getRows().get();

for (var i = 0; i < childRecords.length; i++) {
var childRecordId = childRecords[i].getData().getEntity().getId();

// Set the lookup value on the child record
var entity = {};
entity.new_lookupfield = { Id: parentRecordId, LogicalName: "parententity_logicalname" };

Xrm.WebApi.updateRecord("childentity_logicalname", childRecordId, entity)
.then(function success(result) {
console.log("Lookup value set on child record with ID: " + childRecordId);
},
function (error) {
console.log(error.message);
});
}
}

Quick Links

Leaderboard