Polpulate lookup select box variable based on another lookup select box variable

[Vivek13]

Hi please help me with the following:

I have 2 lookup select box variable both has lookup from table as sys_user. One for lookup value field Email and another for  lookup value field Employee number. I want to set the value of Employee number variable based on the email chosen.

[Jaspal Singh]

Hi Vivek,

For the Employee number look-up can you try using below as reference qualifier

javascript: 'email='+current.variables.email;

Additionally, you can use an onChange() client script that runs when Email variable field changes.

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading || newValue == '') {
        return;
    }
    var emailis = g_form.getReference('email', empnois);

    function empnois(emailis) {
        g_form.setValue('employee_id', emailis.employee_number);
    }

}

[Vivek13]

Hi,

I have tried both, but its not setting the employee id and still its showing all the employee numbers in the drop down.

[Jaspal Singh]

Hi Vivek,

There is a typo in your script.

Line 8 should be emp.employee_number & not emailis.employee_number

Also, if you are using script then you need not use the reference qualifier.

[Vivek13]

Hi,

Yes I have changed it, but still the same