Department is a string variable and need to autopopulate department name as per user

[Momi]

Kindly help and let me know how can i auto populate department name (department variable- string) for login user in service catalog. it auto populates sys id instead of department name. I need the variable single line text so that in case if some user donot have department name can manually entered. Please help.

[Dr Atul G- LNG]

Hi @Momi 

1st thing, make the department a reference that will be better, please check in the dictionary of the department display value is true or not.

[Juhi Poddar]

Hello @Momi 

• Seems like you are fetching the value using getValue() or getUniqueValue() method.
• Try using getDiSplayValue() method.
• It will be better if you can share the script so that I can help you modify the script.

If this helped, please like and mark it as an accepted solution. This helps future readers to locate the solution easily in community.

Thank You 

Juhi Poddar 

[Ramya V]

Hi @Momi,

I have used a String field named 'Department' in the catalog item form.

Script Include: Make sure that the Script Include is set to Client Callable

var GetUserDepartment = Class.create();

GetUserDepartment.prototype = Object.extendsObject(AbstractAjaxProcessor, {

getDepartment: function() {

var result = '';

var user = gs.getUser(); 

var departmentID = user.getDepartmentID(); 

if (!departmentID) {

result = 'Department not available';

} else {

var department = new GlideRecord('cmn_department');

if (department.get(departmentID)) {

result = department.getDisplayValue();

} else {

result = 'Department not available';

}

}

return result;

},

type: 'GetUserDepartment'

});

Catalog Client Script:

function onLoad() {

var ga = new GlideAjax('GetUserDepartment');

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

ga.getXML(function(response) {

var department = response.responseXML.documentElement.getAttribute("answer");

g_form.setValue('department', department); //Replace 'department' with your field name

});

}

Please mark my answer as Correct and Helpful if this solution works for you.

[ViktoriaMikoova]

If you have a variable with reference to the User table that's default value is the current user, you can easily use the Auto-populate on the Department variable and specify the dot-walk to a value you want. But the Dependent question needs to be a reference in order for this approach to work. I have Requested for variable which is a reference to the user table and it's default value is the current signed in user. Below is the setting of the Department variable