Reference field display value to String field on Catalog Item

Shane J · ‎01-06-2015

How can I get a value from a Reference field to populate a String field via an OnChange client script (for a Catalog Item)? Right now, all I can get is the Sys_ID. The field needs to get populated initially with the cost_center field, based on the logged in under, but after that it may need to be manually changed (to a non-reference value).

Kalaiarasan Pus · ‎01-08-2015

This will work

Script Include:

var UserDetailsAjax = Class.create();

UserDetailsAjax.prototype = Object.extendsObject(AbstractAjaxProcessor, {

getCostCenterDetails: function()

{

var getUserCostDetails = new GlideRecord('sys_user');

if(getUserCostDetails.get(this.getParameter('sysparm_requested_for')))

{

return getUserCostDetails.cost_center.getDisplayValue();

}

});

Client script

var getCost = new GlideAjax('UserDetailsAjax');

getCost.addParam('sysparm_name','getCostCenterDetails');

getCost.addParam('sysparm_requested_for',newValue);

getCost.getXML(setCostCenter);

function setCostCenter(response) {

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

g_form.setValue('cost_center', answer);

}

View solution in original post

Anurag Tripathi · ‎01-06-2015

Hi Jued

Try this

g_form.getDisplayBox('reference field').value;

-Anurag

Shane J · ‎01-07-2015

How would that play into this OnChange script (or is this the wrong approach entirely)? I tried using it in a couple different ways but without success.

function onChange(control, oldValue, newValue, isLoading) {

if(newValue != ""){

var reqFor2 = g_form.getReference('requested_for');

// g_form.getDisplayBox('reference field').value;

g_form.setValue('cost_center', reqFor2.cost_center);

}

Kalaiarasan Pus · ‎01-07-2015

A screenshot would help us to see your current setup and respond accordingly

Shane J · ‎01-07-2015

Ask and ye shall receive: