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

[Olaf0816]

Hi,

its a single line text variable type.

BR

Manfred

[Ankur Bawiskar]

Hi,

what is the type of field Location? Is it a reference to your custom table? if yes then only the getReference() code would work

Regards
Ankur

[Olaf0816]

Hi.

This solution work for me

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

    var location = g_form.getReference('location_it', getLocationDetails);
}

function getLocationDetails(loc) {
    if (loc) {
        g_form.setValue('site_code2_it', loc.u_og_sitecode);
    }
}

BR

Manfred