Setting a value in a Catalog Task field from the User table

[sarahleighton]

Hi all

As part of our New Employee process, we'd like to set 2 values in 2 fields on a Catalog Task record, from the User table.

I've attempted a client script on the Catalog Task table to do this, but I know it's not right, and was hoping someone could put me on the right track with it.

What I've tried to do is create a variable (newname) to get the name entered in a string variable on the catalog form (that variable is called full_name on the form)

I've then queried the User table to find any match of newname in the u_name field which is on the user table.

Then I've said if the employee_number field on the user table for that record is not empty, then set the u_staff_number field on the Catalog Task (which I want to populate) to whatever is in the employee_number field on the user record.

Here it is -

function onLoad() {
//Type appropriate comment here, and begin script below

var newname = ritm.variables.full_name;
var gr = new GlideRecord('sys_user');
gr.addQuery('u_name', newname);
gr.query(myCallbackFunction); //Execute the query with callback function//After the server returns the query recordset, continue here
function myCallbackFunction(gr) {
while (gr.next()) { //While the recordset contains records, iterate through them
if (gr.employee_number != ' ') {
g_form.setValue(u_staff_number = gr.employee_number);
}
}
}

}

Any help would be great!

Thanks

[Martin Ivanov]

Try with After insert business rule like this one.

Let me know if it works fine.

Mark Correct AND Helpful. Thanks!

[Martin Ivanov]

Here is the Script

(function executeRule(current, previous /*null when async*/) {

	var newname = current.ritm.variables.full_name;
	var gr = new GlideRecord('sys_user');
	gr.addQuery('u_name', newname);
	gr.query();

	while (gr.next()) {
		if (gr.getValue('employee_number') != ' ') {
			current.setValue('u_staff_number', gr.getValue('employee_number'));
		}
	}
	current.update();


})(current, previous);

[Ankur Bawiskar]

Using current.update() in business rule is not recommended by ServiceNow.

[Martin Ivanov]

Before business rule is also not recommended for reqs, ritms, tasks. Current.update() may cause a loop, but here I don't see such danger.