How to create Multi Select variable on a catalog Item and add/remove options dynamically.

[Padma17]

How to create Multi Select variable on a catalog Item and add/remove options dynamically. 

We have a requirement to create multi select field on the catalog form, and the options of this field depend on the selection of two other fields. 

I've found there is a List Collector type which I could reference to a table and use it, but using this will show all the records in the table but my requirement is to limit the choices based on the selections of other two fields.

Please help.

Thanks.

[Padma17]

Yes Jaspal, in normal case I do that. But here I have 100s of options and based on the other field chosen, I want to display on few 2-3 options only each time. Hope you got what I'm saying. In this case how can I use reference qualifier? 

Example - If user is choosing a "XYZ" group from group/application field I want to show only "a, b , c" roles. Similarly I have many number of groups and based on that selection want to show different roles.

[suuriya]

hi padma,

I too have same pbm....pls let me know if you have found the solution for it

[Erik Gunther2]

Although this question was posted years ago, I didn't see an answer marked as helpful. Here is my solution in case it helps anyone else.

Step 1: Create table called "Lookup List Item". This table extends Data Lookup Matcher Rules.

Step 2: Add the following fields:

Step 3: Populate the records using "Group ID" as a list key to segment the records into groups. These will be the available list of values to choose from.

Step 4: In your catalog item, create a List Collector variable.

Step 5: In your List Collector variable, set the List table to "Lookup List Item" and Reference qualifier to u_group_id=[name of Group ID value here without any quotes].

This worked for me and provided a reusable solution for other List Collectors.

If this response was helpful, please indicate Helpful. Thanks!

[josephjoechella]

I have the same requirement. Field A and Field B. Choices on the field B are dependent of choices of Field A and additionally Field B should be multiselect field.  Is there any way to achieve this without creating a new table ?

Example

Field A - Country - India,US,UK, Australia. Let's assume India is selected

then 

Field B should populate all the cities in India and there should be an ability to multiselect the cities .

Thank you