Multiple Select Trigger

[#1]

Hi

I have found how to set a selection on activating a sheet using Trigger--->OnActivateSheet--->AddAction--->Select in Field--->Field--->Search String

Having entered a string ='2013/14' this selects 2013/14 as expected.  What if I wanted to select both 2013/14 and 2014/15 on sheet activation?  I can't find a way of entering both strings (such as an AND statement or a + sign) or do I have to add it as a separate statement?

Any help appreciated.

[Anonymous]

use =('2013/14'|'2014/15') in search string for field. you can do more than two...just separate the strings using the pipe (|) character.

from help for "Add Action Dialog",

Select in Field

Selects the values and fields that are specified. In the Search String you can specify a search mask, e.g. (A|B) will select both A and B.

[jagan]

Hi,

Try like this

Give search string as ("2013/14"|"2014/15")

Regards,

Jagan.

[rwunderlich]

You may also use the "Toggle Select" action, which is an additive select.

-Rob

http://masterssummit.com

http://robwunderlich.com