auto populate Employee Title, Employee Email ,Employee User ID, Employee Department

[Purushotham9963]

Hi , 

If I select employee name in service portal , how can we auto populate  Employee Title,   Employee Email,  Employee User ID,   Employee Department, Employee Manager,    Manager Email

Thanks in advance 

[Dr Atul G- LNG]

Hi @Purushotham9963 

In SN , it is OOTB available. 

Create these variable and#

use Auto populate where depend on question 1 for all, and do the dot walk. 

[Purushotham9963]

May I know what is dot walk and how can i fill below 3 columns if select employee name in service portal , how can we auto populate  Employee Title

[Dr Atul G- LNG]

Hi @Purushotham9963 

Dot walk to 

 Employee Email,  Employee User ID,   Employee Department, Employee Manager,    Manager Email

[Purushotham9963]

HI 

i wrote catalog client script(onChange) instead of dot walk , but it is populating user Email only 

function onChange(control, oldValue, newValue, isLoading) {

    if (newValue == '') {

        g_form.setReadOnly('employee_manager_email', false);

        g_form.clearValue('employee_manager_email');

        g_form.setReadOnly('employee_manager_email', true);

        return;

    }

    g_form.setReadOnly('employee_manager_email', false);

    g_form.clearValue('employee_manager_email');

    var ga = new GlideAjax('global.userDataPopulation'); //This argument should be the exact name of the script include.

    ga.addParam('sysparm_name', 'userEmailAddress'); //sysparm_name is the name of the function in the script include to call. (Change)

    ga.addParam('sysparm_client_requested_for', newValue); //This is an optional parameter which we can reference in the script include.

    ga.getXML(myCallBack); //This is our callback function, which will process the response.

    function myCallBack(response) { //the argument 'response' is automatically provided when the callback funciton is called by the system.

        //Dig out the 'answer' attribute, which is what our function returns.

        var server_result = response.responseXML.documentElement.getAttribute('answer');

        if (server_result != false) {

            g_form.setValue('employee_manager_email', server_result);

            g_form.setReadOnly('employee_manager_email', true);

        }

    }

}

Thanks in advance