Pull data from related entity onLoad javscript

(0) Share

Report

Posted on by l ringel

Hello all,

I am trying to create a script that will run onLoad of one of my forms. Among the many things that this script will do, it needs to check a field on one of the lockups on the form.

How do i check the field value of the related record?

Thank you in advance!!

Leibish Ringel

*This post is locked for comments

All responses (3)

Answers (0)

Suggested answer

ntn32 401 on at

Like (0)

Report

RE: Pull data from related entity onLoad javscript

Hey,

To read the details of related entity from the lookup value follow the below steps

1. On entity B form "OnLoad" script read the lookup value.

var entitiyALookup = Xrm.Page.data.entity.getAttributes.('LookUpSchemaName').getValue()

if(entitiyALookup != null && entitiyALookup.length[0]){

var entityARecordId = entitiyALookup[0].id

var entityARecordType = entitiyALookup[0].entityType

}

2. Now make a web API call to get the field value (in your case the optionset field value ) from entity A record.

Xrm.WebApi.retrieveRecord(entityARecordType, entityARecordId).then(function(result){
console.log(result);
//Here you can read the field data from entity A. i.e., the optionset field value
}, function(error){ console.log(error); alert(error)});

Note: Xrm.WebApi.retrieveRecord method is only for dynamics 365 v9.0. If you are running any old version of CRM then make use of AJAX to consume the webapi.

Thanks

Nitin
l ringel on at

Like (0)

Report

RE: Pull data from related entity onLoad javscript

Thank you for you reply.

Does this pull up the field on the related lookup or just the lookup value?

I have entity A and B. Entity A is a parent of B. Im writing a script that runs onload of entity B and it will check the value of a given option set on the parent entity, A.
Suggested answer

litonn 913 on at

Like (0)

Report

RE: Pull data from related entity onLoad javscript

You can get information about a lookup field the following way. Lookup field consists of 3 properties together.

var luf = Xrm.Page.data.entity.attributes.get('FIELD SCHEMA NAME HERE').getValue()

if(luf != null){

id= luf[0].id;

type= luf[0].entityType;

name = luf[0].name;

}

Hope this will help!