Show list collector values based on variable selection

[Sandy7]

Hello - I have a service request that has a dropdown variable (where user can select 1 value). Based on that, I have a list collector. I want only certain values to show up in the list collector based on what is selected in the dropdown variable.  So, from the Field 1, an example option is "Compliance Risk Assesments". 

If Compliance Risk Assements is selected in field 1, I want only the associated Roles to be populated in the list collector (variable 2)...

Here is the table that I want to use to populate the list collector: as you can see, in the "GRC" field, that is associated with the dropdown variable above "Please select the Archer GRC Module"..  so I would like to now have the values in the "roles" column of the table selected 

Any help would be appreciated. Thank you!!!!

[Community Alums]

Does this help?

Advanced Filtering of List Collector Variables - Dependent on a Value of Another Variable

[ryan_pope]

For a bit of a simpler approach to this (and if you're willing to stray a bit from the slushbucket - move items from the left to the right), what you can do is:

1. On the List Collector variable, set the "Variable attributes" field to: glide_list=true,ref_qual_elements=[put name of dropdown variable here, and remove the brackets]
2. On the List Collector variable, set the "Reference qualifier" field to javascript:'[field name that aligns with the data being selected in the dropdown, w/o the brackets]='+current.variables.[name of the dropdown variable w/o the brackets];
3. On the the dropdown variable, set the "Variable attributes" field to: ref_qual_elements=[name of the list collecter variable]

The end result looks something like this: