Adding fields to an alternate state listbox

[#1]

Hi,

I have a simple need to implement a feature where a user can  add all "possible" or "selected" fields from an inherited state list box into an inherited list box. The attached app should work like so:

Clear Group A button: clear all selections in the Group A list box.

Add to Group A button:  Add all 'selected' or 'possible' values from color list box to the Group A list box. So for example if user selects 'high' from the color_popularity list, then blue and red values should be added to the Group A list box. If user selects orange from the color list box, then orange should be added to the Group A list box

[JonnyPoole · Accepted solution]

I think i got it work. The concatenated  pipe delimitted list of possible values is created in a variable which evaluates in the default state.

Then i use a 'select in field' action in state 'A' to apply the variable value.

Need to ensure the variable formula has '=' so it calculates in the default state first.

Please see attached and validate it works as you need

[#3]

Hi,

Thanks for your solution. This solution is almost there. I should've been more precise and called it "Append to Group A" instead of "Add to Group A". I need to append any subsequent selections from color list to Group A list. So something like this in the search string of the "Add to Group A" button action:

='$(vCopy)' & '|' & GetFieldSelections(color), which obviously is not the right syntax.

and what did you mean by your note about the '=' sign. Isn't this part of the syntax? How does it relate to the state?

EDIT:

I figured out the solution. Instead of "Select in Field" you need to use "Toggle Select" for the button action.