Dynamic Dropdown Menu

[cc11]

I have three fields as shows in the screenshot below,

1 User selects Category = 'Software'

2 On clicking Type dropdown, we want to query a Table called 'Inventory' (where we have Category, Type & Subtype columns data) and pull matching Type values from there.

But here is another thing - while displaying Type values, we need to transform them by appending Type & Subtype together with a dot(.) and making them lowercase.

So the Type dropdown should show the values in this format ->   type.subtype

Is this possible?

Thank you,

Yogesh

[cc11]

I created client script below(screenshot 2). The intent was to build simple menu values for 'Type' field when 'Category' field was changed. But I got error error (from screenshot 1)

screenshot 1

screenshot 2

[Shishir Srivast]

Hi Yogesh,

I tried like below code and it worked, you might need to make some changes to meet your requirements.

onChange Client Script:

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

if (isLoading || newValue === '') {

return;

}

g_form.clearOptions('u_new_choice'); //change the field name with dependent field name

var listDetails = new GlideAjax("DisplayTypeList");

listDetails.addParam("sysparm_name", "getListDetails");

listDetails.addParam("sysparm_order", newValue);

listDetails.getXML(ajaxResponse);

function ajaxResponse(serverResponse) {

var answer = serverResponse.responseXML.documentElement.getAttribute("answer");

var myObj = JSON.parse(answer);

if(myObj.length > 0)

{

for(var i = 0; i<myObj.length; i++)

{

g_form.addOption('u_new_choice', myObj[i].toLowerCase(), myObj[i].toLowerCase()); //Replace the field name where you have to assign the value

}

}

}

}

Client Callable Script Include:

var DisplayTypeList = Class.create();

DisplayTypeList.prototype = Object.extendsObject(AbstractAjaxProcessor, {

getListDetails : function() {

var list = [];

var gr = new GlideRecord('sys_choice'); //Replace with your table name

var order = this.getParameter('sysparm_order');

gr.addQuery('element', order); //Add your queries here

gr.query();

while(gr.next())

{

var item_val = gr.getValue('value') + '.' + gr.getValue('label'); // Replace the field names from where you have to fetch the value

list.push(item_val);

}

return JSON.stringify(list);

},

type: 'DisplayTypeList'

});

[cc11]

Just want add -

In my case, Type field is of type 'Reference'.

Does it need to be of type 'Choice'?

Thank you,

Yogesh

[cc11]

I tried by making 'Type' a Choice field. It doesnt seem to be working

[Shishir Srivast]

On reference field this will work, you need to have it as choice field, let me know what code are you using?

In sysparm_order you should pass the category value, sysparm_order is a variable which will be used in script include.