How to Add Selected options one field as selection for another field?

Go to solution
Pratiksha_kadam
Tera Contributor

‎07-04-2023 01:09 AM

Hello,

we have the requirement to create one field that contains choices from another field. 

Example: -

Suppose there are two field 'A' and field 'B'. Field A is multiselect field where we can select multiple options. Whatever selected in field A those will be the choice for B. For B we have to select any one of option from those options of 'A'. When multiselect field 'A' contain only one selection then field 'B' contain that as default value. we have to make ' B ' field mandatory when 'A' field contains more than one selection.

please guide me to implement this functionality.

Thanks in advance.

0 Helpfuls
  • 931 Views
1 ACCEPTED SOLUTION

Go to solution
Anil Lande
Kilo Patron
In response to Pratiksha_kadam

‎07-04-2023 06:54 AM

Hi,

You need use advanced Reference qualifier on Field B like below:

 javascript: "sys_idIN"+current.u_field_a

 

It will restrict list to options selected in 1st Field.

To achieve 2nd scenario, you need to create onChange Client script running on change of 1st field.

 

Use logic in your client script like below:

 

var first = g_form.getValue('u_field_a');
var arr = first.split(",");
if(arr.length<1){
g_form.setValue("u_field_b",newValue);
}
Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande

View solution in original post

10 REPLIES 10

Go to solution
Kiranmai_KVL
Kilo Sage

‎07-04-2023 06:40 AM

Hi Pratiksha,

 

I suggest the following:

1) Create variable A as 'list collector' & refer to the table to get the options.

2) Create variable B as 'Select box'.

 

You need to client script to get the values dynamically to variable B, below is the approach :

  • Write a onChange client script on variable A & get all the display values selected for variable A. You may need to call the script include to get the display values of selected values in list collector. 
  • Once you get the values of variable A, write 'addOption' to variable B in the same client script.

Hope this helps. Let me know if you need any further assistance. 

 

0 Helpfuls