select multiple values

ali_hijazi — Thu, 23 Aug 2012 07:38:44 GMT

Hello

I got a trigger on one of the sheet and added an action to select multiple values of a field

the field is Business Type

the values are OFFICE and REGIONAL OFFICE

I put in the action the field [Business Type] and in the value I put (REGIONAL OFFICE|OFFICE)

Only OFFICE is selected

values that contain spaces are not being selected

Please advise

Re: select multiple values

jonathandienst — Thu, 23 Aug 2012 09:15:22 GMT

Try replacing the spaces with *

(REGIONAL*OFFICE|OFFICE)

That appears to work.You can use Replace() to swap the space for a *

Regards

Jonathan