Filter a dropdown field in Service Portal

Jo_o Luis
Tera Contributor

I want to filter "Area / Subject / Expertise" field depending on the "Country for F.M.V calculation" field. So if I select for example "Albania" it should appear only relevant options in "Area / Subject / Expertise" field. How do I do that?

 

 

 

Jo_oLuis_0-1697193337358.png

 

2 ACCEPTED SOLUTIONS

Ok...the "country_for_fmv_calculation" is not Reference variable on catalog item....right...??

Can you try like below.....!!

 

javascript:'country.name=' + current.variables.country_for_fmv_calculation;

 

Vishal Birajdar
ServiceNow Developer

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

View solution in original post

Hi @Jo_o Luis 

 

As it's reference field, It will be difficult.

What I suggest is if possible, make the field type as "Lookup select box" & use "unique values only" option.

e.g.,

The screenshot below is just example...You can use your table & lookup value which you want to display.

 

VishalBirajdar_0-1697451055330.png

 

 

 

 

 

 

Vishal Birajdar
ServiceNow Developer

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

View solution in original post

14 REPLIES 14

Here it is

Jo_oLuis_0-1697209407071.png

 

Ok...the "country_for_fmv_calculation" is not Reference variable on catalog item....right...??

Can you try like below.....!!

 

javascript:'country.name=' + current.variables.country_for_fmv_calculation;

 

Vishal Birajdar
ServiceNow Developer

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

Nice! It works now

Do you know how can do to filter this dropdown and get one value of each Area of expertise? 

Jo_oLuis_0-1697445873461.png

 

Hi @Jo_o Luis 

 

As it's reference field, It will be difficult.

What I suggest is if possible, make the field type as "Lookup select box" & use "unique values only" option.

e.g.,

The screenshot below is just example...You can use your table & lookup value which you want to display.

 

VishalBirajdar_0-1697451055330.png

 

 

 

 

 

 

Vishal Birajdar
ServiceNow Developer

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