autocomplete variable on record producer based on another reference field

[JHughes62]

Hi,

We have this company variable on one of our record producers, the company variable is a reference to the core_company table.

We have added another variable called 'Company ID'. Based on the company that is selected in the company variable, the Company ID variable should auto complete. The company ID is a custom field on the core_company table. 

How do we autocomplete this field?

[Ankur Bawiskar · Accepted solution]

@JHughes62 

no scripting required. you can use Catalog lookup definition

Catalog Data Lookup Definition - A zero code way to fetch data like requester Details in a catalog i... 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[JHughes62]

@Ankur Bawiskar - Hi Ankara, thank you for your response we ended up actually going with an onchange catalog client script and an unload catalog client script.

function onChange(control, oldValue, newValue, isLoading) {
   if (isLoading || newValue == '') {
      return;
   }
	
	var comp = g_form.getReference('company', callback);
	function callback(company){
	var sa = company.getValue('backend_name_of_field_from_reference_table');
	g_form.setValue('backend_name_of_new_variable_in_record_producer', sa);
		
	}
	
   //Type appropriate comment here, and begin script below
   
}

[Ankur Bawiskar]

@JHughes62 

there is no script required as per my earlier comment.

Thank you for marking my response as helpful.

If my response helped please mark it correct and close the thread so that it benefits future readers.