The CreatorCon Call for Content is officially open! Get started here.

We have a requirement to display the group members of a particular group on a reference field of User table.

Arindam Bose
Giga Contributor

I want to display the name of group members of a particular group to be shown on a reference field to User table. The field's name is "approver ". Only members of a particular group needs to be populated. This is reference field to the User table.Please find the screenshot.

5 REPLIES 5

Sanket Khabiya
Kilo Sage

Hi Arindam,

 

Try below Solution: 


Script Include Name : GetGroupMembers
API Name : global.GetGroupMembers

function GetGroupMembers(){
var array = [];
var grp = "<sys_id_of_group>" //paste sis_id of group
// gs.addInfoMessage(grp);
var gp = new GlideRecord('sys_user_grmember');
gp.addEncodedQuery('group='+grp);
//gs.addInfoMessage(gp.getEncodedQuery());
gp.query();
while(gp.next())
{
array.push(gp.getValue("user"));

}
gs.addInfoMessage(array.toString());
return 'sys_idIN' +array;
}

Add this reference qualifier to the Approver field
Reference qualifier :

javascript:global.GetGroupMembers();

 

Regards,

Sanket