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

[Alberto Consonn]

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!!!

[manish64]

There few things you need take care 

1)reference correct table and map column which has display =true for you table is "account"

2)reference qualifier for dynamic javascript:query in your case your are filter with account column= curent.task for account table 

could please show me list view of account table and check whether manually filter with with task number you are getting value

moreover reference qualifier will be so filter out result for setting value you need to make use onchange script 

Please, remember to mark Correct or Helpful if you find my response useful.

[Dubz · Accepted solution]

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!