Add multiple users into the group from catalogue form.

[Sravani47]

We have a catalogue form with a field name "select the users" type of "list collector" and a reference to the sys_user table, as well as a field with a "select the group" type of "reference" and a reference to the sys_user_group table. When multiple users are selected in that "select users" field and the catalogue form is submitted, all of the selected users should be added to that group.

Issue : : Only the first user is added to the group when multiple users are selected in the "select the users" field and the catalogue form is submitted. We want to add all of the selected users to the group.

In Workflow - Run Scrip Code:

var array1 =[];

array1 = current.variables.u_users.toString();

var array2 = [];
array2 = array1.split(',');
var Length = array2.length;
for (var i =0; i< Length; i++){
gr.addQuery('sys_id',array2[i]);

var gr = new GlideRecord('sys_user_grmember');
gr.initialize();
gr.addQuery('group',current.variables.u_group1);
gr.addQuery('user',array2[i]);
gr.query();
if(gr.next()){

}
else
{
gr.group = current.variables.u_group1;
gr.user = array2[i];
gr.insert();
}
}

catalogue form screen

Please help me on this issue .

[Brian Lancaster]

So the log only shows up once? Before the for loop can you do a gs.log("array1: " + array1 + " length: " + array1.length);

[Brian Lancaster]

Also just try deleting the variable and recreate it. I have seen in the past were this fixes the issue.

[Mike_R]

Untested, but i modified your code. Try this

var array1 = current.variables.u_users.toString();
var array2 = array1.split(',');
var length = array2.length;
for (var i = 0; i < length; i++) {

    var grCheck = new GlideRecord('sys_user_grmember');
    grCheck.addQuery('group', current.variables.u_group1);
    grCheck.addQuery('user', array2[i]);
    grCheck.query();
    if (!grCheck.next()) {
        var groupAdd = new GlideRecord('sys_user_grmember');
        groupAdd.initialize();
        groupAdd.user = current.variables.u_group1;
        groupAdd.group = array2[i];
        groupAdd.insert();

    }
}

[Sravani47]

Hi Mike,

Thank you for your response, but after adding your code to the Run Script, users were not added to the selected group.

Please assist me with this.

[Sagar Pagar · Accepted solution]

Hi,

Try this updated scritps -

var array1 = [];
array1 = current.variables.u_users.toString();
var group_sys_id = current.variables.u_group1.toString();

var array2 = [];
array2 = array1.split(',');
var Length = array2.length;

for (var i = 0; i < Length; i++) {

	var grMember = new GlideRecord('sys_user_grmember');
	grMember.addQuery('user', array2[i]);
	grMember.addQuery('group', group_sys_id);
	grMember.query();
	if (!grMember.next()) {

		var newRecord = new GlideRecord('sys_user_grmember');
		newRecord.initialize();
		newRecord.group = group_sys_id;
		newRecord.user = array2[i];
		newRecord.insert();
	}
}

Thanks,

Sagar Pagar