Basically I have 2 entities. for example B,C
In Entiy B I have one field called OfficerName(Lookup)
In Entity C I have one field called Advisor(lookup).
My question is if you select Advisor as XYZ it should auto populate in OfficerName same like XYZ only.
They don't have relationship between each entities
Version: MS Dynamics CRM 2016
I was struck in this situation can you help me
Thanks
*This post is locked for comments
What about oncreate?
can we create oncreate java-script function for same property???
Yes Aric, it worked for me finally after many hurdles.
Thanks for your suggestion
You can select the first entity, get the value from the lookup, and call a web api function using JavaScript to query the other entity for the same name. The query will return the Guid from the second entity, and you can call the setValue function of the second lookup attribute to set the value from what is returned from the web api.
If you have not used web api previously, download the CRM Rest Builder by Jason Lattimer. This tool will help you build web api queries which you can then paste into your JavaScript code:
Here is an example of an article on using web api (you can generate the code from Rest Builder) on this community:
community.dynamics.com/.../ms-crm-2016-web-api-operations-retrieve-single-or-multiple-records
Hope this helps.
Hi, this one can be done using presearch (Javascript). Something like this:
Share
Report
All responses (
Answers (
function AddPreSearch(){
var run;
var fnCampaignFilter = function(){
var b = Xrm.Page.getAttribute("new_b").getValue();
if(!b) return;
var bOfficerId = GetBOfficerId(b);
var filterXml = [
"<filter type='and'>",
"<condition attribute='new_advisorid' operator='eql' value="+bOfficerId+" />":""),
"</condition>",
"</filter>"].join("");
Xrm.Page.getControl("new_c").addCustomFilter(filterXml);
}
return function(){
if(!run){
Xrm.Page.getControl("new_c").addPreSearch(fnCampaignFilter);
}
}();
};
You must understand that you need retrieve entity B data to get the correct Officer. After you've got this Officer, you only need to give filter entity C lookup using this method. Btw, you called this method using OnLoad function. Everytime you want to changed entity C lookup value, it will populate based on the filter.
Hope this help.
Hi,
Without having a relationship between entity B & C how would you identify which Entity B record needs to be updated.
So 2 answer your question, it is not possible to update the record without relating them (unless you have some other criteria to find the related record for example say by name etc).
Because you have this requirment, there must be some sort of link/ relation between entity B & C ( which you may have not yet created in CRM but exists as business requirement). I may be wrong, its just a thought.
Hope this helps.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156