How to populate a Reference field automatically (no dot-walking, GlideAjax)

Alberto Consonn · ‎02-21-2019

Hi guys,

I need an help for configuring the Advanced Reference Qualifier in the right way.

In the Time Worker table, I've created a Reference custom field "Account_ref" to the customer_account table.

I would like to fill this field automatically with the account of the selected task, I tried dding with the following Advanced Reference Qualifier...no luck.

javascript:'account='+current.task;

Thanks for your help!!!

Dubz · ‎02-22-2019

Hi Alberto,

I replicated your config and figured out the issue, real rookie error for which i accept full responsibility 🙂

The function call in the getXMLAnswer() line is in quotes, it shouldn't be! use this:

//client script
function onChange(control, oldValue, newValue, isLoading, isTemplate) {
	if (isLoading || newValue === '') {
		return;
	}

	var ga = new GlideAjax('TestScriptInclude');
	ga.addParam('sysparm_name', 'testFunction');
	ga.addParam('sysparm_task', g_form.getValue('task'));
	ga.getXMLAnswer(getAjaxData);

	function getAjaxData(response){
		g_form.setValue('u_account_ref', response);
	}
}

EDIT: Just noticed Harsh has already picked this up!

View solution in original post

Alberto Consonn · ‎02-21-2019

Hi David,

I tried to use the following onChange client script but it's raising the error below:

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
   if (isLoading || newValue === '') {
      return;
   }

   //Type appropriate comment here, and begin script below
   var task = g_form.getValue('task');
	g_form.setValue('u_account_ref', task.account.name);
}

Any idea?

Thanks a lot

hvrdhn88 · ‎02-21-2019

dot walk will not work here, until you use callback function in your client script. A

hvrdhn88 · ‎02-21-2019

The Fantastic g_form getReference Callback

try using callback function

Alberto Consonn · ‎02-21-2019

I tried but still getting "undefined" with the below code, could you please help me?

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
   if (isLoading || newValue === '') {
      return;
   }
   //Type appropriate comment here, and begin script below
   var task = g_form.getReference('task', setAccount);
}

function setAccount(task) {

    if (task)
        g_form.setValue('u_account_ref', task.account);

}

hvrdhn88 · ‎02-21-2019

can you give a try again

g_form.getReference('task', cbFunc);

function cbFunc(gr) {
    var test= gr.getValue('account');
    alert('Value is ' +test); 
}

i tested this way and its working for me.