Hi,
below comments
Are those groups already existing? if yes then currently you will have to manually add the Group Managers of Nike A, Nike B, Nike C, Nike D to the Group Nike Owners
1) For Existing scenario -> do it manually if less group; if more groups are there then write background script
2) For real-time scenario -> below approach
For making it real-time whenever manager of any of the 4 groups changes you want it to be added and remove the older one
Please use below approach
Business Rule on Group Table
BR Condition: Name is One of those 4 and Manager Changes
After Update:
Script: It would get previous manager and current manager
query table and delete record of previous manager and create new record for current manager
var previousManager = previous.manager;
var currentManager = current.manager;
// query Group Member Table
var member = new GlideRecord('sys_user_grmember');
member.addQuery('group', current.sys_id);
member.addQuery('user', previousManager);
member.query();
if(member.next()){
member.deleteRecord(); // this will delete old manager
// now you need to add new manager to this group as member
var member1 = new GlideRecord('sys_user_grmember');
member1.initialize();
member1.group = current.sys_id;
member1.user = currentManager;
member1.insert();
}
Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur
Hi,
Unsure of your exact requirement for adding it as members I would simply create a Relationship from System Defintion >> Relationships & create something as below.
Once done will add it to the Group form as a Related list & then simply modify the Relates list layout to display only Group Managers.
Output as below.
