Show specific list of choices in List Collector field based on another field

[Narmadha PR]

Hi,

I have 2 fields "Request" and "Label".  "Request" is a dropdown field with 5 options and  "Label" is a list collector field with 23 options. Based on the options I'm selecting from the Request field, I want to show the choices in the list collector field.

Can you please help?

[Ankur Bawiskar · Accepted solution]

@Narmadha PR 

you can use this advanced ref qualifier on list collector

Ensure you give correct choice value to compare and correct sysIds of question_choice records

javascript: var query; var choice = current.variables.firstVariable; if(choice == 'choice1') query = 'sys_idINsysId1,sysId2'; else if(choice == 'choice2') query = 'sys_idINsysId3,sysId4'; query;

Ensure you add this variable attributes

ref_qual_elements=firstVariableName

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar · Accepted solution]

@Narmadha PR 

you can use this advanced ref qualifier on list collector

Ensure you give correct choice value to compare and correct sysIds of question_choice records

javascript: var query; var choice = current.variables.firstVariable; if(choice == 'choice1') query = 'sys_idINsysId1,sysId2'; else if(choice == 'choice2') query = 'sys_idINsysId3,sysId4'; query;

Ensure you add this variable attributes

ref_qual_elements=firstVariableName

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Muhammad Salar]

Hi @Narmadha PR 
How would you make a decision?
if you select any value from request then which values will be populated in list "label"
Have you maintained any table for that decision ?

[Vishal Jaswal · Accepted solution]

Hello @Narmadha PR 

Taken reference from: https://www.servicenow.com/community/developer-forum/need-a-simple-onchange-client-script-to-force-l...

here is what you need to perform to achieve something like below:

Service portal screenshots:

Here are the variables:

Here is your List collector variable:

Reference qualifier:

javascript:
var listCollectorFilter = {
 'choice1': 'sys_idIN5e7101b697968d1021983d1e6253af4e,1f8101b697968d1021983d1e6253af4f',
 'choice2': 'sys_idINe59101b697968d1021983d1e6253af52,1ab7eafa9712cd1021983d1e6253af52',
 'choice3': 'sys_idINeda62e7a9712cd1021983d1e6253af19,09a7aafa9712cd1021983d1e6253aff6'
};
listCollectorFilter[current.variables.request] || '';

Variable Attributes: ref_qual_elements=request