Autopopulate Custodian L4 Name and another field Custodian L4 Name2 based on Custodian Name

[Naman Jain2412]

Hi, 

I have created a Script Include and Client Script however it is working fine when I select one custodian Name and it's autopopulating the Custodian L4 Name however when I select two user in Custodian Name it's not autopopulating the another person Custodian L4 Name 2 that I have created another field. Please let me know the resolution of the same based on the below script attached for the reference and let me know in case of any query,

SCRIPT INCLUDE SCRIPT 

Custodian L4 Name

 autopopulateL4Name: function() {

        gs.info("user")

        var userID = this.getParameter('sysparm_user_id');

        varuserIDArray = userID.split(',');

        var result = [];

        for (var i = 0; i < userIDArray.length; i++)

            var userGR = new GlideRecord('sys_user');

        userGR.addQuery('sys_id', userID);

        userGR.query();

        if (userGR.next()) {

            var l4name = userGR.department.u_l4_headempcode.getDisplayValue();

            gs.info("l4name" + l4name)

            var l4name2 = userGR.department.u_l4_headempcode.getDisplayValue();

            gs.info("l4name2" + l4name2)

        }

        return l4name;

    },

});

CLIENT SCRIPT 

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

    if (isLoading || newValue === '') {

        return;

    }

    // Check if a user is selected

    var userID = g_form.getValue('u_custodian_name');

        var ga = new GlideAjax('sn_compliance.Autopopulate_L4_Name');

        ga.addParam('sysparm_name', 'autopopulateL4Name');

        ga.addParam('sysparm_user_id', userID);

        ga.getXMLAnswer(function(response) {

            // g_form.addInfoMessage(response)

            if (response) {

                g_form.setValue('u_custodian_l4_name', response);

                g_form.setValue('u_custodian_l4_name2', response);

            }

        });

    }

[Mohammad Danis1 · Accepted solution]

Hi @Naman Jain2412 ,
As per your script it looks  like Field "Custodian Name" is of type "LIST".

Please find the working script:

SCRIPT INCLUDE SCRIPT 

Custodian L4 Name:

 autopopulateL4Name: function() {
        var userIDs = this.getParameter('sysparm_user_id');

        var userIDArray = userIDs.split(',');
        var result = [];
        for (var i = 0; i < userIDArray.length; i++){
        var userGR = new GlideRecord('sys_user');
        userGR.addQuery('sys_id', userIDArray[i]);
        userGR.query();
        if (userGR.next()) {
        result.push(userGR.department.u_l4_headempcode.getDisplayValue());
        }
        return result.toString();
    },

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

    // Check if a user is selected
    var userID = g_form.getValue('u_custodian_name');

        var ga = new GlideAjax('sn_compliance.Autopopulate_L4_Name');
        ga.addParam('sysparm_name', 'autopopulateL4Name');
        ga.addParam('sysparm_user_id', userID.toString());
        ga.getXML(pop_details);
    
 function pop_details(response) {
      var values = response.responseXML.documentElement.getAttribute('answer').toString().split(',');
                g_form.setValue('u_custodian_l4_name', values[0]);
                g_form.setValue('u_custodian_l4_name2', values[1]);

}
}

It's working in PDI 🙂

Let me know if you still stuck somewhere.

[Mohammad Danis1 · Accepted solution]

Hi @Naman Jain2412 ,
As per your script it looks  like Field "Custodian Name" is of type "LIST".

Please find the working script:

SCRIPT INCLUDE SCRIPT 

Custodian L4 Name:

 autopopulateL4Name: function() {
        var userIDs = this.getParameter('sysparm_user_id');

        var userIDArray = userIDs.split(',');
        var result = [];
        for (var i = 0; i < userIDArray.length; i++){
        var userGR = new GlideRecord('sys_user');
        userGR.addQuery('sys_id', userIDArray[i]);
        userGR.query();
        if (userGR.next()) {
        result.push(userGR.department.u_l4_headempcode.getDisplayValue());
        }
        return result.toString();
    },

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

    // Check if a user is selected
    var userID = g_form.getValue('u_custodian_name');

        var ga = new GlideAjax('sn_compliance.Autopopulate_L4_Name');
        ga.addParam('sysparm_name', 'autopopulateL4Name');
        ga.addParam('sysparm_user_id', userID.toString());
        ga.getXML(pop_details);
    
 function pop_details(response) {
      var values = response.responseXML.documentElement.getAttribute('answer').toString().split(',');
                g_form.setValue('u_custodian_l4_name', values[0]);
                g_form.setValue('u_custodian_l4_name2', values[1]);

}
}

It's working in PDI 🙂

Let me know if you still stuck somewhere.

[Naman Jain2412]

Thanks for your response.I have tried via the same script however it is autopopulating the value for only 1 field as Custodian L4 Name not autopopulating the value when I have selected 2 users for another field as Custodian L4 Name 2. pls check and let me know the issue.

[Shraddha Kadam]

@Naman Jain2412, Please share your updated script.

[Mohammad Danis1 · Accepted solution]

@Naman Jain2412 , Please share the updated script.
The one I shared should work.

[Naman Jain2412]

It is working fine. Thanks