Help getting fields from a related entity through a lookup in javascript

(0) Share

Report

Posted on by Mattw112b

387

Hi,

Looking for how to do this? I have a lookup field on one form... I want to get other data from the selected record in the lookup field to populate another field on the form.

I've found a million articles with the same stuff.. that shows how to get id, name, and type... but I want to get a different fields from those from the original record, in this case users entity.

This works to get id from new_user lookup field on form.

function GetUserDetails(executionContext) {
var formContext = executionContext.getFormContext();
var entityId = formContext.getAttribute("new_user").getValue()[0].id.slice(1,-1);

alert(entityId);

}

But can't use it to get fullname for example?

Doing this doesn't work:

formContext.getAttribute("new_user").getValue()[0].fullname;

Anyone help with missing piece?

Thanks,

Terry

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Hello Terry,

You will need to use Xrm.WebApi for this purpose. Check this post - carldesouza.com/.../

Was this reply helpful? Yes No
Mattw112b 387 on at

Like (0)

Report

marked this as the answer, but would've been nicer if there was some direct examples or something... but after trial and error I have it working. For others looking for this here's what I did:

function GetUserDetails(executionContext) {
var formContext = executionContext.getFormContext();
var entityId = formContext.getAttribute("new_user").getValue()[0].id.slice(1, -1);

if (entityId !== null) {

Xrm.WebApi.retrieveRecord("systemuser", entityId, "?$select=fullname").then(

function success(result) {
if (result !== null) {

//set text field
if (result.fullname !== null)
formContext.getAttribute("new_name").setValue(result.fullname);
}
},
function(error) {
alert(error.message);
}
);
}
}

Thanks,

Terry

1 people found this reply helpful.

Was this reply helpful? Yes No
a33ik 84,331 Most Valuable Professional on at

Like (0)

Report

Terry,

I'm glad that you resolved your issue. And just for your understanding - I'm not for the "giving the fish" I'm for the "teaching to fish" approach if you understand that.

Was this reply helpful? Yes No