auto populate values (single line text) based on another field value (type reference)

[santiago_bergal]

Hello, I have a variable (type reference) which is called territory. Based on the selection of a given territory, another field (CISO group) should be autopopulated. I was working on the client script below but it hasn't worked so far. Any clues? suggestions?

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

var territory = g_form.getReference('territory', callback); 

function callback(territory) { //reference is passed into callback as first arguments

g_form.setValue('ciso_group',territory.sys_user_group);

}

[Raghav Sharma24]

Tour code seems correct. can you confirm below:

var territory = g_form.getReference('territory', callback);   // which table does your territory field refers to?

function callback(territory) { //reference is passed into callback as first arguments

g_form.setValue('ciso_group',territory.sys_user_group);   // is sys_user_group a field on the table to which territory refers to?

[santiago_bergal]

RaghavSh, thanks for your quick reply.

territory is a reference type variable and it refers to the [core_company] table.
I don't know if sys_user_group is a field on the table to which territory refers to. I'll check. Thanks!

[Raghav Sharma24]

yes you can only dot walk the fields on core_company table like territory.name , will give you company's name selected in territory.

Please mark the answer correct/helpful accordingly.

[santiago_bergal]

Just checked. I tried with the name of the field (u_ciso_group) and with reference (sys_user_group) as a second attempt. Neither worked.