Get and Set Lookups from a related entity using Javascript CRM

(0) Share

Report

Posted on by Community Member

Hi all!

I have this request in Account Entity, where if user enters a Zip/Postal (Lookup Field) , the form auto-populates the Region number (Lookup) and County number (Lookup) base on the Zip/Postal. Relationships are already set in CRM. I've done this using Plugin and it's a success, but it needs to be real-time. So it need to be done uisng JS and I'm not quite good with Javascript. Can anyone provide me a code structure for this? I'm using CRM 2013

Thanks in advance!

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Rawish Kumar 13,758 on at

Like (1)

Report
Copy link

Link copied!

Hello There,

I would suggest you install and use the CRM restbuilder. It will let you create odata request. [View:https://github.com/jlattimer/CRMRESTBuilder/releases:750:50]

once you install this you will be able to access this tool from solutions are.

basically this is what you need to do.

1. select the endpoint as 2011 ( odata)

2. select the retrieve multiple option

3. select the entity you need to retrieved

4. add filtering attributes in this case it will be your zip/postal code.

and generate the code. later you can use the retrieved value to set on the current form by using Xrm.Page.getAttribute("fieldname").setValue(retrievedValue);

and that's how you set lookup value : passion4dynamics.com/.../how-to-retrieve-lookup-value-and-set-it-on-another-lookup-field-in-dynamics-crm-2016-javascript

Was this reply helpful? Yes No
Suggested answer

Alex Fun Wei Jie 33,628 on at

Like (0)

Report
Copy link

Link copied!

Hi,

you can refer below blog on how to retreive data for CRM 2013.

mscrmtechie.blogspot.com/.../retrieve-records-from-crm-using-odata.html

mahenderpal.wordpress.com/.../retrieve-primary-entity-and-related-entity-data-using-odata-in-ms-crm-2011

dynamicscrmgirl.wordpress.com/.../crm-2013-javascript-retrievemultiple-records-using-fetchxml-query-and-soap-endpoint

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

User CRMRestBuilder to build the query -

www.youtube.com/watch

Here I have answered similar requirement , you can have a look -

community.dynamics.com/.../304043

Was this reply helpful? Yes No