How to populate a field on the the sys_user_group based on another field in the sys_user_grou via BR

Daniel R2 · ‎02-13-2023

Hi,

On the sys_user_group form we have added a custom field called 'Display Name'
This is due to the fact that the name is to complex and we would prefer a more understandable display name.

There is a requirement to populate the custom field 'Display Name' based on the 'Name' field on the sys_user_group form through a Business Rule.

(The reason for this configuration, is due to a previous integration which has imported the necessary groups. So if more groups get loaded in the future, this Business Rule should organise it. We would also like a better dislplay name, as already mentioned above)

For e.g.

If the "Name" field starts with "ABC-Random_ABCD-ServiceNow_AB_" it should be cut and the remaining text should be the "Display name"
Otherwise "Name" should be copied fully to "Display name".

Is it possible if someone can please provide their support here or provide a script that would allow this to work.

priyasunku · ‎02-13-2023

Hi @Daniel R2

You can try below Before Business Rule

var Name = current.name;

var Name_length = Name.toString().length;

if(Name.contains('ABC-Random_ABCD-ServiceNow_AB_'));

{

var display_name = Name.substring(30,Name_length);

current.u_display_name=display_name;

}

else

current.u_display_name=Name;

Please let me know if this helpful.

View solution in original post

Daniel R2 · ‎02-14-2023

thanks @priyasunku - that has worked and it has updated the necessary 'ABC-Random' groups. Is another background script required to update the groups where 'ABC-Random' is not included? How would we go about updating these?

Also, on the case form, we have a reference field called 'assignment group' which references the sys_user_group. Currently the display value shows the 'name' of the groups, how would we set the display value to actually show the new custome field 'Display Name's value

priyasunku · ‎02-14-2023

Hi @Daniel R2

Just replace the addQuery condition for the groups where 'ABC-Random' is not included

gr.addQuery('name', "DOES NOT CONTAIN" ,"ABC-Random_ABCD-ServiceNow_AB_");

Try changing the display field to true for "Display Name" field instead of "Name" in table configuration.

Daniel R2 · ‎02-14-2023

Thanks @priyasunku it is much appreciated.

By changing the display field to true for "Display Name" field instead of "Name". I think this changes the display field for this reference on every table. What we would like is that it only changes for a specific table?