How to populate the assigned_to field with the opened_by user's manager that is defined in sys_user

ChuanYanF · ‎04-08-2025

Dear experts,

I am facing a problem where my onLoad script is not working as expected. I want to make the assigned_to field in the risk event form to autopopulate the user's manager for whichever users that creates a new risk event record. I have defined each user's manager in the sys_user record and I have created a script include called GetManager and a onLoad client script. Please advise what approach or amendments I need to be done to my scripts or my actions.

var GetManager = Class.create();
GetManager.prototype = Object.extendsObject(AbstractAjaxProcessor, {

    getManager: function() {
        var userID = this.getParameter('sysparm_user_id');
        var userGR = new GlideRecord('sys_user');
        if (userGR.get(userID)) {
            if (userGR.manager) {
                return userGR.manager.toString();
            }
        }
        return '';
    }

});

function onLoad() {
    var openedBy = g_form.getValue('opened_by');

    if (openedBy) {
        // Use GlideAjax to call a Script Include that returns the manager
        var ga = new GlideAjax('GetManager');
        ga.addParam('sysparm_name', 'getManager');
        ga.addParam('sysparm_user_id', openedBy);
        ga.getXMLAnswer(function(response) {
            if (response) {
                g_form.setValue('assigned_to', response);
            }
        });
    }
}

Shivalika · ‎04-08-2025

And use below 👇 script

function onLoad() {

if (g_form.isNewRecord()) {

var openedBy = g_form.getValue('opened_by');

if (openedBy) {

g_form.getReference('opened_by', function(user) {

if (user.manager) {

g_form.setValue('assigned_to', user.manager);

}

});

}

This will work if fields are correct and also try by removing "is New Record"

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket.

Regards,

Shivalika

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQC

View solution in original post

Shivalika · ‎04-08-2025

Hello @ChuanYanF

With my recent solution even without bringing "opened by on the form" its working, I have done it for incident and see the reference screenshots and code -

//CLIENT SCRIPT
function onLoad() {
   //Type appropriate comment here, and begin script below
   
    var ga = new GlideAjax('GetOpenedByManager');
    ga.addParam('sysparm_name', 'getManager');
    ga.addParam('sysparm_record_number', g_form.getValue('number')); // Replace with actual record number
	alert(g_form.getValue('number'))
    ga.getXMLAnswer(function(response) {
        alert("working");
        alert("Opened By's Manager: " + response);
		g_form.setValue('assigned_to',response);
    });

}

//SCRIPT INCLUDE

// Name: GetOpenedByManager
// Accessible from: Client Callable - true
var GetOpenedByManager = Class.create();
GetOpenedByManager.prototype = Object.extendsObject(AbstractAjaxProcessor, {
    getManager: function () {
        
        var recordNumber = this.getParameter('sysparm_record_number');
        
        var gr = new GlideRecord('incident');
        gr.addQuery('number', recordNumber);
        gr.query();

        if (gr.next()) {
            var openedBy = gr.getValue('caller_id');
            if(openedBy) {
                var userGR = new GlideRecord('sys_user');
                if (userGR.get(openedBy)) {
                    var manager = userGR.getValue('manager');
                    return manager;
                }
            }
            
        }
        
    }
});

This answers your second question as well @ChuanYanF

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket.

Regards,

Shivalika

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

View solution in original post

Shivalika · ‎04-08-2025

Hello @ChuanYanF

Thanks !!

Use below 👇 @ChuanYanF it should work -

function onLoad() {

if (g_form.isNewRecord()) {

var openedBy = g_form.getValue('opened_by');

if (openedBy) {

g_form.getReference('opened_by', function(user) {

if (user.manager) {

g_form.setValue('assigned_to', user.manager);

}

});

}

Shivalika · ‎04-08-2025

Also remove isNewRecord - if you are trying with older records - you can remove it also - not needed actually. @ChuanYanF

ChuanYanF · ‎04-08-2025

Hi Shivalika,

I tried the latest script of yours and also removing and not removing the isNewRecord, but it still wont populate for me. Any steps I mistook?

Shivalika · ‎04-08-2025

And use below 👇 script

function onLoad() {

if (g_form.isNewRecord()) {

var openedBy = g_form.getValue('opened_by');

if (openedBy) {

g_form.getReference('opened_by', function(user) {

if (user.manager) {

g_form.setValue('assigned_to', user.manager);

}

});

}

This will work if fields are correct and also try by removing "is New Record"

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket.

Regards,

Shivalika

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQC

ChuanYanF · ‎04-08-2025

I tried this latest script of yours but it is still not functioning in my side.