Need to select a set of values in a list box, using a button action.

[Anonymous]

Here's the list of values in the list box (or field)

YTD,

MTD,

Jan,

Feb,

Mar,

..

..

..

Dec

I created a button to help the user select all the months at one go - Toggle select.

Field_name: AdhocCols

String: (Jan|Feb|Mar|Apr|May|.........|Dec)

This works fine only if the user hasn't already selected one of the months in my list. If he has selected YTD, MTD, Jan & Feb already, then my button deselect Jan & Feb.

Please help. how do I make the button disregard the current selections in that field.

[Anonymous]

Thanks for clarifying

Lastly, how can I have a clear months button - I used toggle select action to clear months but that doesn't sound right. In case the user clicks on clear months when no months are selected, the toggle will select all months for them.

[Miguel_Angel_Baeyens]

You need another button (or a conditional in the one you already have) to Toggle Select and then use this string:

(Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dic)

All other values will be kept selected.