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

(0) Share

Report

Posted on by DevCrmUser

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.

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Kosenurm 85 on at

Like (0)

Report

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);
});
}
}

Was this reply helpful? Yes No