sorry, maybe i wasn't clear. I will have to make some assumptions as the information you provided did not have some needed clarification:
ASSUMPTIONS:
I will assume you are trying to pull "Catalog Default", "Phone Default" and "PC Catalog" from CMN_LOCATION by your screenshot.
I will also assume that on the Locations table, the following fields exist:
"Phone Default" = cmn_location.phone
"Catalog Default" = cmn_location.u_catalog_default
"PC Catalog" = cmn_location.u_pc_catalog
I will further assume that your catalog item has the following variables:
Location: Reference cmn_location table
Phone: Single Line Text
PC Catalog: Single Line Text
Default Catalog: Single Line Text
(Your Specific CODE):
Create a SCRIPT INCLUDE (with "Client Callable" checkbox set to TRUE). Put this in the script box
var GetLocationDetailsAjax = Class.create();
GetLocationDetailsAjax.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getInfo: function(){
var obj={};
obj.phone='';
obj.u_catalog_default='';
obj.u_pc_catalog='';
var id=this.getParameter('sysparm_location');
var gr= new GlideRecord('cmn_location');
if(gr.get(id)){
obj.phone = gr.phone.toString();
obj.u_catalog_default = gr.u_catalog_default.toString();
obj.u_pc_catalog = gr.u_pc_catalog.toString();
}
return JSON.stringify(obj);
},
type: 'GetLocationDetailsAjax'
});
Next, create a client script on your catalog item:
- UI Type: ALL
- TYPE: onChnage
- Variable Name: Location
- Script:
function onChange(control, oldValue, newValue, isLoading) {
if (newValue == '') {
return;
}
var id = g_form.getValue('location');
var ga = new GlideAjax('GetLocationDetailsAjax');
ga.addParam('sysparm_name','getInfo');
ga.addParam('sysparm_location',id);
ga.getXML(CallBack);
function CallBack(response)
{
var answer = response.responseXML.documentElement.getAttribute("answer");
var location=JSON.parse(answer);
g_form.setValue('phone',location.phone);
g_form.setValue('pc_catalog',location.u_pc_catalog);
g_form.setValue('default_catalog',location.u_catalog_default);
g_form.setReadOnly('phone',true);
g_form.setReadOnly('pc_catalog',true);
g_form.setReadOnly('default_catalog',true);
}
}
The result is that when a user selects a location, the values update. Please note that i included readOnly lines as typically, you want to keep users from editing pre-populated fields
