Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Hiding an option in reference field based on another field

Go to solution
Ramel
Mega Guru

‎09-14-2023 06:22 PM

Hi Community,

 

I was trying to hide an option in a reference field based on the selection on another field but I can't seem to make it work. I have seen a couple of similar question here in community but the solution that works for them does not seem to work when I tried it.

Requirement: 

When country = Singapore, category shoould show Recruitment, all other countries should not show the Recruitment category.

 

My script Include:

var CategoryCheck = Class.create();
CategoryCheck.prototype = {
    initialize: function() {
    },
    checkCountry: function(country) {
        gs.info('Check Country' + country);
        if(country == 'f9955b451bec55500826cbf2164bcb88') {//Singapore
        return "u_available_forISNOTEMPTY";
        }
        else {
            return "u_available_forISNOTEMPTY^u_name!=Recruitment/Onboarding";
        }
    },
    type: 'CategoryCheck'
};
 
Then, I have added the reference qualifier in the category field: javascript:new CategoryCheck().checkCountry(current.variables.u_country);
 
Can someone help to advise what am I missing.
 
Thank you.

 

0 Helpfuls
  • 1,881 Views
1 ACCEPTED SOLUTION

Go to solution
Vishal Birajdar
Giga Sage
In response to Ramel

‎09-14-2023 08:37 PM

Hi @Ramel 

 

Ok lets do vice-versa...have a try once.

 

javascript: 

var query;

if (current.variables.u_country != 'SINGAPORE'){
query = "u_available_forISNOTEMPTY^u_name!=Recruitment/Onboarding";
        }
else { 
query = "u_available_forISNOTEMPTY";
}

 

I have checked in my PDI its working as expected....!!

Vishal Birajdar
ServiceNow Developer

I know one thing, and that is that I know nothing.
- Socrates

View solution in original post

0 Helpfuls
10 REPLIES 10

Go to solution
Ramel
Mega Guru
In response to Vishal Birajdar

‎09-14-2023 08:47 PM

This worked. I have also tried the below with script include and it worked. But since your sueggestion does not need scipt include, I will go with that. Appreciate your help. Thanks a lot.

 

var CategoryCheck = Class.create();
CategoryCheck.prototype = {
    initialize: function() {
    },
    
    checkCountry: function(country) {
        gs.log('Check Country' + country);

        var query1 = "u_available_forISNOTEMPTY^u_name!=Recruitment/Onboarding";
        var query = "u_available_forISNOTEMPTY";
        if (country == 'SINGAPORE') {
        return query;
        }
        else
        return query1;
    },
    type: 'CategoryCheck'
};
0 Helpfuls