Script to validade if a group in sys_user_group table is Active (true or false).

[rafaelalves4337]

Hello team,

I created a Catalog Item form that users can request to activate or deactivate a group, form is completed and the flow is also working fine.

the variable type is Reference, like the image below:

Depending of user selection (Re-Activate or Deactivate) the requirement is to show an error message below field "Name_of_the_Group": 

"This group is already activated" or "This group is already deactivated".

I'm struggling to find a way to make this happen, my scripting is beginner...

[Brad Bowman]

You would most likely want to run this onChange of the t/f variable:

function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue == '') {
	return;
}

g_form.hideFieldMsg('var_name'); //hide any previous messages
if (newValue == 'true') { //try without the quotes if it doesn't work
    g_form.showFieldMsg('var_name','valid name','info', true);
}
if (newValue == 'false') {
    g_form.showFieldMsg('var_name','invalid name','info', true);
}

[rafaelalves4337]

Your script is working fine for me, I forgot to mention that there is a selection before that (Deactivate or Re-Activate):

If the user select Deactivate and write a group name that the active status is False, the Show field msg will be 

if (newValue == 'false') {

    g_form.showFieldMsg('name_of_the_group_2','This group is already INACTIVE in Service Now','info', true);

If the user select Re-Activate, and the group is already Active, the fieldmsg is:

if (newValue == 'true') { //try without the quotes if it doesn't work

    g_form.showFieldMsg('name_of_the_group_2','This group is already ACTIVE in Service Now','info', true);

If I user the variable group_status, it show the messages in both selections (Deactivate and Re-Activate), and it need to respect the selection, I don't  want to see the message that a group is already active if the user selected to Deactivate the group.

I tried many things here, nothing is working, so I guess I do not know how to do it.

Sorry for the long text!

[Brad Bowman]

It sounds like you just need an AND condition in the IF statements:

if (newValue == 'false' && g_form.getValue('select_the_option_bellow') == 'DEACTIVATE') { //or whatever the actual value is
    g_form.showFieldMsg('name_of_the_group_2','This group is already INACTIVE in Service Now','info', true);