question Re: Dependent Dropdown In Service Catalaog Form in ITSM forum

Dependent Dropdown In Service Catalaog Form

sonu123 — Mon, 22 May 2017 18:55:03 GMT

Hi Folks,

I am new to service now and I have a requirement.

I have two dropdown fields in our catalog form. in first dropdown there are two values and values in 2nd dropdown field is coming from a custom table.

The actual requirement is to filter the 2nd dropdown based on first dropdown selection. In our custom table there is an entry of the first dropdown value in all record. So we can filter based on that. But I dont know the process to do that.

Please help me to do the same.

Regards,

Sonu

Re: Dependent Dropdown In Service Catalaog Form

sachin_namjoshi — Mon, 22 May 2017 21:37:52 GMT

Please refer below post which will help you to implement your requirement.

http://wiki.servicenow.com/index.php?title=Adding_Dependent_Variables#gsc.tab=0

Regards,

Sachin

Re: Dependent Dropdown In Service Catalaog Form

Alikutty A — Tue, 23 May 2017 06:48:17 GMT

Hi Sonu,

You should be writing an on change client script on the first drop down variable and the dependent values can be populated on the 2nd dropdown. If the values are stored on a different table, then you need to make a server call from your client script or if values are hard coded, you can just add these lines after modifying logic according to your requirement.

if(newValue == 'a'){

g_form.addOption('seond_variable_name', 'b', 'B');

g_form.addOption('seond_variable_name', 'c', 'C');

}

Thank You

Please Hit Like, Helpful or Correct depending on the impact of response

Re: Dependent Dropdown In Service Catalaog Form

sonu123 — Tue, 23 May 2017 07:36:24 GMT

Thanks Alikutty and Najoshi for you reply

@ Alikutty - I have the values stored at server side. I have also written an script include to filter the dropdown. But it is filtering only at the loading time. But I need to refresh the 2nd dropdown every time when I change my first dropdown. This is not happening. How to achive the functionality when I change the value in my first dropdown.

Regards,

Vikash

Re: Dependent Dropdown In Service Catalaog Form

Shishir Srivast — Tue, 23 May 2017 07:59:16 GMT

you can call the script include on your 2nd field as advanced reference qualifier. Reference Qualifiers - ServiceNow Wiki

sample code, please modify per your need.

var GetListValue = Class.create();

GetListValue.prototype = {

initialize: function() {

getList : function()

{

var ids = [];

var gr = new GlideRecord('Your table name');

var sys_id = this.getParameter();

gr.addQuery('<sys_id variable>', sys_id);

gr.query();

while(gr.next())

{

ids.push(gr.sys_id.toString());

}

return 'sys_idIN' + ids;

type: 'GetListValue'

};

also, i think you can create a datal ookup between between these two fields.

Re: Dependent Dropdown In Service Catalaog Form

Kailash Bhange — Fri, 12 Jun 2020 07:02:51 GMT

Hi All,

Please take a look at Article below:

1. dependent on single table
2. dependent on two tables using referene

[SOLVED]: - Dependent variable on Catalog item using Lookup Select Box
https://community.servicenow.com/community?id=community_article&sys_id=1ce7dceedb5914101cd8a345ca961952

If my answer solved your issue, please mark my answer as ✅ Correct & 👍Helpful based on the Impact.

Thank you!
Regards,
Kailash.