how to make field mandatory when group name.manger,members added have changes

[raj765_32]

Hi can anyone pls help me with scenario for,

when a field in group table 

"Name"

"Manager"

"Group Members'

are updated. i have to make a field "Worknotes" mandatory in group table

i have written a before business rule with an update option and written the below code:

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

if(current.name.changes() || current.manager.changes() || current.sys_user_grmember.changes())

if(current.u_work_notes.isNil){

gs.addErrorMessage("Please fill data in worknotes field");

current.setAbortAction(true);

}

})(current, previous);

whenever changes are made for the above two fields record is getting saved but i dont want record to be saved unless worknotes field is filled and the above code is not working when group members are added or removed.

Please help me with this

[SN_Learn · Accepted solution]

Hi @raj765_32 ,

Please try the below:

In Advance section:

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

    if (current.u_work_notes.isNil()) {
        gs.addErrorMessage("Please fill data in worknotes field");
        current.setAbortAction(true);
    }

})(current, previous);

This will work for both the fields 'Name' and 'Manager' but not for Group members because that is not a field rather it is a separate table. So, we need to write a business rule on that table separately.

[raj765_32]

this is not working for group members

[SN_Learn]

@raj765_32 ,

Could you please share your setup of business rule and what is not working, the users are getting added?

[raj765_32]

i have kept before business rule, insert and update and sys_group member table and the below code:

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

var grp = new GlideRecord('sys_user_group');

if (grp.get(current.group)) {

if (gs.nil(grp.u_work_notes)) {

gs.addErrorMessage("Please fill data in worknotes field");

current.setAbortAction(true);

}

}

})(current, previous);

[SN_Learn]

Hi @raj765_32 ,

I have tried the same in PDI and it is not adding user in the group.

Business Rule on [sys_user_grmember], before insert+update

From the group, adding member using 'edit' or 'new' button. No user added.

Please show the screenshots of the issue from your end.

[raj765_32]

when i add or remove users worknotes should display mandatory like which we did in name or manager