Show one choice in drop down based on selection of another drop down field

vahini
Giga Guru

Hello Friends,
Need your help with this requirement

There are two drop down fields on the form:
1.Select Request Area (select_request_area ) with 13 choices
2. Request Type ( request_type) with 12 choices

got a requirement like this , if select area = claims or Group benefits or Commerical or small scale
then
Show only one option 'Verint Quality' for 'Request type' drop down

For all other request areas show all options under Request type ( i.e do nothing )

How to achieve this requirement?

Thanks for your time reading my post and responding to it.

1 REPLY 1

Kai Tingey
Tera Guru

you could use an onChange client script to build the variable list for your second field, e.g.

 

 

 

function onChange(control, oldValue, newValue, isLoading) {
   if (isLoading || newValue == '') {
      return;
   }
var getAPP = g_form.getValue('select_request_area');
	
	if (getAPP == "value here"){
		g_form.clearOptions('request_type');
                g_form.addOption('request_type','Verint Quality','Verint Quality','1');
                }

 

 

 

the issue with this, is if the user selects that value - it will change the list to show just the one option, if the user then selects something else instead, you will still be stuck with just that one option unless they refresh the page.

You can write an else condition to rebuild the list but it gets pretty clunky if you want to start having more conditional options.

Another option, and one i've been using when the conditional lists get more complicated, is to have a custom table for conditional list choices. In my case its something like u_custom_variable_values

 

I have a field name and a related value column for the table, to allow me to use qualifiers to show what i want. The good thing about this is it's re-usable. 

KaiTingey_2-1739233493495.png

 

 

 

then you set your request_type field as a lookup select box, point it to your custom table and write a reference qualifier to show what you want

e.g.

javascript:"u_field_name=request_type^u_related_value="+current.variables.select_request_area

 

then depending on what you select in the 'select_request_area' field, it will only show the entries that match.

 

hopefully that helps