Auto populate one variable on a Catalog item based on the value of another variable

[Olaf0816]

Hi!

On my test catalog item, I have created two variables, one call 'Location' and the other called 'Sitecode'.    The 'Sitecode' value should automatically update when I select a value in the 'Location' variable.

I have created a custom table.

This is my test form.

 

This are my catalog item variables.

This is my client script.

Unfortunately, it's not working. What am I doing wrong? Can someone help me please?

BR

Manfred

[Ankur Bawiskar]

Hi,

update it as below:

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

var og = g_form.getReference('Location', callBackMethod);

}

function callBackMethod(og){

g_form.setValue('Sitecode', og.u_og_site_code);

}

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Olaf0816]

Hello Ankur.

Unfortunately, that doesn't work either.

BR

Manfred

[Ankur Bawiskar]

Hi,

Is the Location field a reference to that table?

Regards
Ankur

[Subhojit Das]

Hi,

May I know what is the field type of sitecode in location table?

Regards,

Subhojit