How to set value to reference field using sys_id

[peshwen]

Hi all,

I am having sys_id of company name and i want to set that company name to reference field using sys_id.So how to do it?Please anyone can tell?

[peshwen]

Hi Mihir,

I tried but the value is not setting to field.Its empty only.

Thanks ,

Nikhil

[Mihir Mohanta]

Can you share the script that you have written ?

Thanks,

Mihir

[peshwen]

function ajax(serverResponse) {

  var answer = serverResponse.responseXML.documentElement.getAttribute("answer");

}

    g_form.setValue('contractorCompanyName',answer);

script include function:

getCompanyDetails : function() {

  var answer = " ";

  var number = this.getParameter("sysparm_companyname");

  var index = number.indexOf("(");

  var index1 = number.indexOf(")");

  var s = number.substring(index+1,index1);

  var gr = new GlideRecord("core_company");

  gr.addQuery("name",s);

  gr.query();

  while(gr.next())

  {

  answer =   gr.getValue('sys_id');

  }

  return answer;

  },

This is code.I am getting correct sys value in answer variable.But it is not being set in contractor campany variable.It is reference variable.in variable s i am getting the company name.in var number i am having company name with some prefix which i dont need.

Thanks,

Nikhil

[bernyalvarado]

Hi Nikhil,

A couple of pointers that may be helpful:

a) have you tried setting the field within the callback function?

function ajax(serverResponse) {
   var answer = serverResponse.responseXML.documentElement.getAttribute("answer");
   g_form.setValue('contractorCompanyName',answer);
}

b) make sure your variable name contractorCompanyName is right.

c) make sure it's actually a reference field of the Company table

Thanks,

Berny

[bernyalvarado]

I'm almost sure a) will solve your problem

I hope this helps.

Thanks,

Berny