QV9 Trigger Multiselect

[#1]

Hi,

how can I create a trigger that selects more than one field.
I tried Triggers->Edit Actions (on Activate Sheet) -> Select in Field

Is there something like and or & etc?

Thanks in advance.

Matt

[#2]

as far as i know, the only way to select more than one value in a field with this action is to use a wildcard in the search pattern

for example, selecting "A*" will select all values in that field beginning with A

you can use a macro with the Field.SelectValues method to achieve more complex selection

[#3]

Hi Matt,

see the attached example: On the main sheet the "Select some Weeks" button

Good luck!

Rainer

[#4]

Hi,

looks good for numbers, but selecting different text values might be a problem?

[#5]

Hi,

You could try the following macro for selecting multiple values from any field:

sub SelectionsProdArea

set ad = ActiveDocument

set vProdArea=ad.getfield("ProductArea")

vProdArea.clear

vProdArea.select ("100")
vProdArea.toggleselect ("200")
vProdArea.toggleselect ("400")

end sub

best regards,

Johan

[#6]

Hi,

If you want to use a expression to generate a selection you have to make a variable.

Something like '=>27<' & week(today())

to select a financial year that starts in week 27.

In the actionfield then add $(vVariablename).

Greetz, Halmar

[#7]

Hi Matt,

Please find an example with multiple selection through triger. Hope this is what you wanted.

Best Regards,

Sajeevan