Need to add more than 100 values for a dropdown variable.

[Akshay Bhonde]

I'm getting this requirement very frequently to add multiple choices under dropdown variable (I'm using Select Box) on catalog item form which is not referenced to any table. But it is not a best practice to add more than 15-20 values in select box variable type, and I also don't have option to refer to any table or I cannot add new table for every new catalog item. Can anyone please help what would be the best possible solution to achieve this, I'm writing the exact requirement below:

Need to create two variable -

1) Category - This has 10 dropdown values

2) Subcategory - It has more than 100 dropdown values for subcategory and that depends on category selected (Based on category value selected only related subcategories needs to be shown).

[Akshay Bhonde]

Hello Prince,

Sorry for the late reply.

Actually the solution was not accepted with this way, I also tried with use of both tables "question" and "question_choice", but as architect point of view they told its not the right way to use this tables and it will be difficult to maintain those tables.

So I have achieved the solution with other way using decision table and called the decision table in a script include and pushed those values to the select box variable with the help of onChange client script.

Thank You very much for your reply, and I have definitely learned something new with this.

Regards,

Akshay Bhonde

[Rahul Talreja]

Hi @Akshay Bhonde ,
Refer - Solved: What is the best way to hide 100's of choices in t... - ServiceNow Community
I think if it's a very dynamic case, such that every couple of the days you are required to change the choices.
Try creating a table!!