Auto Populate associated Lookup value on selection of other lookup in MSCRM 2011

All replies

• 

  

  1

  Sign in to vote

  Hi Toushu,

  Here is some tested JS code (using oData) that might assist you. Hook the product_onchange() function to the onchange event of your product lookup field. (Make sure you change the entityname/attributenames highlighted in BOLD to match your system). Hope this helps.

  function product_onchange() {
      var product = Xrm.Page.getAttribute("new_productid").getValue();
  
      if (product == null) {
          return;
      }
  
      var serverUrl = Xrm.Page.context.getClientUrl();
      var query = serverUrl + "/xrmservices/2011/OrganizationData.svc/new_productSet?$select=new_productstateid&$filter=new_productid eq guid'" + product[0].id + "'";
  
      var retrieveReq = new XMLHttpRequest();
      retrieveReq.open("GET", query, false);
      retrieveReq.setRequestHeader("Accept", "application/json");
      retrieveReq.setRequestHeader("Content-Type", "application/json;charset=utf-8");
      retrieveReq.onreadystatechange = function () {
          getproductstate(this);
      };
      retrieveReq.send();
  }
  
  function getproductstate(retrieveReq) {
      if (retrieveReq.readyState == 4) {
          if (retrieveReq.status == 200) {
              var retrieved = JSON.parse(retrieveReq.responseText).d;
              Xrm.Page.getAttribute("new_productstateid").setValue([{id: retrieved.results[0].OwnerId.Id, name: retrieved.results[0].OwnerId.Name, entityType: retrieved.results[0].OwnerId.LogicalName}]);
          }
      }
  }

  
  

  ---

  Eric UNG [Senior Analyst Programmer :: Sydney, Australia]

  Thursday, February 27, 2014 10:23 AM
• 

  

  0

  Sign in to vote

  Hi Eric,

  Thanks for your response,

  But I'm unable to complete my requirement by using above  code.
  because my requirement slightly changed I apologies for this

  In account  entity I'm selecting  the Product lookup.

  Product record value is populating on the Product lookup
  while opening the Product Record left navigation I had a Sate entity.

  In state entity product and City are lookup values City lookup is pointing to City entity
  Product is pointing to Product entity .

  Now I want to auto populate on change of the  Product lookup in the  Account entity product associated city in the City lookup
  City lookup attribute is placed on the Account entity.

  Can you please suggest me how will I achieve this.

  Account entity:
  Product = new_Product
  City = new_city

  City Entity:
  Product = new_Productid
  City = new_Cityid

  Thanks,

   

  ---

  
  

  • Edited by Rahul-22 Friday, February 28, 2014 7:28 PM

  Friday, February 28, 2014 7:20 PM
• 

  

  0

  Sign in to vote

  Hi Rahul,

  I hope I understand your requirements correctly. So, basically; the State Entity contains the mapping of Products to Cities.

  In summary:

  1. Account entity have a  lookup to the Product entity
  2. Product have a 1 to many relationship with the State entity 
  3. State entity have a lookup to the Product and City entity

  If this is correct, then the following JS should do the job

  function product_onchange() {
      var product = Xrm.Page.getAttribute("new_productid").getValue();
  
      if (product == null) {
          return;
      }
  
      var serverUrl = Xrm.Page.context.getClientUrl();
      var query = serverUrl + "/xrmservices/2011/OrganizationData.svc/new_stateSet?$select=new_cityid&$filter=new_productid eq guid'" + product[0].id + "'";
  
      var retrieveReq = new XMLHttpRequest();
      retrieveReq.open("GET", query, false);
      retrieveReq.setRequestHeader("Accept", "application/json");
      retrieveReq.setRequestHeader("Content-Type", "application/json;charset=utf-8");
      retrieveReq.onreadystatechange = function () {
          getproductstate(this);
      };
      retrieveReq.send();
  }
  
  function getproductstate(retrieveReq) {
      if (retrieveReq.readyState == 4) {
          if (retrieveReq.status == 200) {
              var retrieved = JSON.parse(retrieveReq.responseText).d;
              Xrm.Page.getAttribute("new_cityid").setValue([{id: retrieved.results[0].OwnerId.Id, name: retrieved.results[0].OwnerId.Name, entityType: retrieved.results[0].OwnerId.LogicalName}]);
          }
      }
  }

  BTW: you said "while opening the Product Record left navigation I had a Sate entity."; Does this mean a Product can have more than one state? If this is true, then a product can have more than one city. The above code will bring back the first city but you can adjust the query to sort or filter based on other conditions. Hope this helps and good luck.

  ---

  Eric UNG [Senior Analyst Programmer :: Sydney, Australia]

  
  

  • Edited by Eric Ung Saturday, March 1, 2014 3:36 AM
  • Marked as answer by Rahul-22 Tuesday, March 4, 2014 2:44 PM

  Saturday, March 1, 2014 3:35 AM
• 

  

  0

  Sign in to vote

  Eric,

  Thanks for your response,

  Function Product_Onchange is working fine but when it comes to the getproductstate function.

  In retrieved.text I'm getting below error.

  {
  "error": {
  "code": "", "message": {
  "lang": "en-US", "value": "Operator 'eq' incompatible with operand types 'Microsoft.Crm.Metadata.ComplexTypeInstance`1[[Microsoft.Xrm.Sdk.EntityReference, Microsoft.Xrm.Sdk, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]' and 'System.Guid' at position 11."
  }
  }
  }

  Thanks,

  ---

  
  

  • Edited by Rahul-22 Sunday, March 2, 2014 5:31 PM
  • Marked as answer by Rahul-22 Tuesday, March 4, 2014 2:44 PM
  • Unmarked as answer by Rahul-22 Tuesday, March 4, 2014 2:44 PM

  Sunday, March 2, 2014 5:30 PM