Filter a dropdown field in Service Portal

[Jo_o Luis]

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?

[Vishal Birajdar · Accepted solution]

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;

[kamlesh13]

Hey @Jo_o Luis,

Is it catalog item you using the portal? or the values from the form?

Regards,

Kamlesh

[Samaksh Wani]

Hello @Jo_o Luis 

Use Catalog Client Script :- OnChange Script.

function onChange(control, oldValue, newValue, isLoading, isTemplate) {

   if ( isLoading || newValue == '') {
      return;
          }
}

var con = g_form.getDisplayBox('country_field_name').value;

if (con == 'Albania'){
g_form.clearOptions('area_field_name');
g_form.addOption(<fieldName>, <choiceValue>, <choiceLabel>, <targetIndex>);  // option 1
g_form.addOption(<fieldName>, <choiceValue>, <choiceLabel>, <targetIndex>); // option 2
g_form.addOption(<fieldName>, <choiceValue>, <choiceLabel>, <targetIndex>); // option 3
}

}

Plz mark my solution as Accept, If you find it helpful.

Regards,

Samaksh

[Jo_o Luis]

I have a table with all options corresponding to a different countries... should I do a GlideRecord and then create an array to push all options that correspond to that country?

  var s = g_form.getValue('country_field_name');

    var array = [];

   var gr = new GlideRecord ('table');

    gr.query();

    while(gr.next()){

        if (s == gr.getValue('country_table_field') ){

            array.push(gr.getValue('area_table_field'));

            g_form.setDisplay('area_field_name', array );

        }

    }

[Samaksh Wani]

Hello @Jo_o Luis 

You can't do GlideRecord in client script.

You need to use script include for the same.

Plz mark my solution as Accept, If you find it helpful.

Regards,

Samaksh