Need to get the phone number of the main contact in an opportunity

All Replies

• Saturday, March 16, 2013 2:01 PM

   

   
  

  0

  Hi there,

  I am using CRM 2011 online. I a neewby and need help for this problem please :

  In the opportunity form, I added a lookup field (schema name : notifiedby) to choose the person (contact) who notified the event. I have another text field (schema name : notifierphone) where I want to get the mobilephone number of that contact.

  Could anyone help please ?

  Regards

  yodo94

  I forgot to add that I would like to have it in JavaScript and to happen onchange of the lookup filed.

  Thank you again.

  • Reply
  • Quote

   
• Saturday, March 16, 2013 2:41 PM

  Moderator

   

   
  

  1

  Try something like this (make sure the field names are accurate):

  function Contact_OnChange() {
      var contact = new Array();
      //verfiy field name is correct
      contact = Xrm.Page.getAttribute("new_notifiedby").getValue();
  
      if (contact == null) {
          return;
      }
  
      var serverUrl = Xrm.Page.context.getClientUrl();
      var oDataSelect = serverUrl + "/XRMServices/2011/OrganizationData.svc/ContactSet?$select=MobilePhone&$filter=ContactId eq guid'" + contact[0].id + "'";
  
      var retrieveReq = new XMLHttpRequest();
      retrieveReq.open("GET", oDataSelect, false);
      retrieveReq.setRequestHeader("Accept", "application/json");
      retrieveReq.setRequestHeader("Content-Type", "application/json;charset=utf-8");
      retrieveReq.onreadystatechange = function () {
          GetContactData(this);
      };
      retrieveReq.send();
  }
  
  function GetContactData(retrieveReq) {
      if (retrieveReq.readyState == 4) {
          if (retrieveReq.status == 200) {
              var retrieved = JSON.parse(retrieveReq.responseText).d;
              //verfiy field name is correct
              Xrm.Page.getAttribute("new_notifierphone").setValue(retrieved.results[0].MobilePhone);
          }
      }
  }

  As you would expect - bind Contact_OnChange to the OnChange event of the lookup.
  

  ---

  Jason Lattimer
  My Blog -  Follow me on Twitter -  LinkedIn

  • Proposed As Answer by JLattimerMicrosoft Community Contributor, Moderator Saturday, March 16, 2013 2:41 PM
  • Marked As Answer by yodo94 Monday, March 18, 2013 2:08 PM
  •  
  • Reply
  • Quote

   
• Monday, March 18, 2013 5:20 AM

   

   
  

  1

  Hi,

  please go through this,

  function Contact_OnChange() {
      var contact = new Array();
      //verfiy field name is correct
      contact = Xrm.Page.getAttribute("new_notifiedby").getValue();
  
      if (contact == null) {
          return;
      }
  
      var serverUrl = Xrm.Page.context.getClientUrl();
      var oDataSelect = serverUrl + "/XRMServices/2011/OrganizationData.svc/ContactSet?$select=MobilePhone&$filter=ContactId eq guid'" + contact[0].id + "'";
  
      var retrieveReq = new XMLHttpRequest();
      retrieveReq.open("GET", oDataSelect, false);
      retrieveReq.setRequestHeader("Accept", "application/json");
      retrieveReq.setRequestHeader("Content-Type", "application/json;charset=utf-8");
      retrieveReq.onreadystatechange = function () {
          GetContactData(this);
      };
      retrieveReq.send();
  }
  
  function GetContactData(retrieveReq) {
      if (retrieveReq.readyState == 4) {
          if (retrieveReq.status == 200) {
              var retrieved = JSON.parse(retrieveReq.responseText).d;
              //verfiy field name is correct
              Xrm.Page.getAttribute("new_notifierphone").setValue(retrieved.results[0].MobilePhone);
          }
      }
  }

  • Marked As Answer by yodo94 Wednesday, April 24, 2013 3:32 PM
  •  
  • Reply
  • Quote

   
• Monday, March 18, 2013 6:02 AM

   

   
  

  0

  Hi,

  I think you can also do it using jsript initially get the guid of the lookup field selected record an then by using the if condition then retrive the field values which are required and set then in the related fields.

  • Proposed As Answer by meenakshi Patnala Tuesday, March 19, 2013 6:32 AM
  •  
  • Reply
  • Quote

   
• Monday, March 18, 2013 7:21 AM

   

   
  

  1

  Hi ,

  Please check this below link it may help you !

  http://social.microsoft.com/Forums/en-US/crm/thread/2bd39113-29a6-431f-8650-06e58662b2c4

  ---

  With Regards Athul MT http://www.athulmt.blogspot.in/

  • Reply
  • Quote

   
• Monday, March 18, 2013 7:25 AM

   

   
  

  1

  Hi,

  You can retrieve the data of another entity(Contact) when you select the record in the lookup field using "Odata endpoints".

  This the link that when you select the record in lookup it will retrieve the data of particular record and display the data in the fields where we requried in the form. Follow the steps carefully in the below link..

  https://community.dynamics.com/crm/b/crmmusings/archive/2011/12/01/odata-with-json-getting-related-values-from-a-lookup-field-in-crm-2011.aspx#.UTRjqaJHIn1

  ---

  Prudveen D If the answer helped you, remember to mark it as answer.

  • Proposed As Answer by prudween Monday, March 18, 2013 7:26 AM
  •  
  • Reply
  • Quote

   
• Monday, March 18, 2013 2:09 PM

   

   
  

  0

  Thank you so much !!!

  It works fine.

  • Reply
  • Quote

   
• Monday, March 18, 2013 2:10 PM

   

   
  

  0

  Thank you so much.

  Just used JLattimer version and it works fine. I shall try yours as well.

  • Reply
  • Quote

   
• Monday, March 18, 2013 2:11 PM

   

   
  

  0
  Thank you for your comments.
  • Reply
  • Quote

   
• Monday, March 18, 2013 2:12 PM

   

   
  

  0

  Thank you so much.

  Just used JLattimer version and it works fine. I shall try yours as well.

  • Reply
  • Quote

   
• Monday, March 18, 2013 2:13 PM

   

   
  

  0
  Thank you so much for your input. I shall have a look at that too.
  • Reply
  • Quote

   
• Tuesday, March 19, 2013 6:22 AM

   

   
  

  1

  Hi ,

  Please check this below link it may help you !

  http://social.microsoft.com/Forums/en-US/crm/thread/2bd39113-29a6-431f-8650-06e58662b2c4

  • Reply
  • Quote