Input box to select and deselect particular items

[markgraham123]

Hi all,

I'm using an input box to select large number of items at a time using the below string.

='(' & Replace(Replace(Replace(Trim('$(vSelect)'), '  ', '|'),' ', '|'), chr(10), '|') & ')'

Can someone help me with string - To show the items other than the selected items

Any help is highly appreciated!

[sunny_talwar]

What is your definition for vSelect?

[markgraham123]

vSelect takes the list of items.

[sunny_talwar]

Is it picking those using GetFieldSelections()?

[markgraham123]

Sunny,

It is a trigger whose action is set to select items:

='(' & Replace(Replace(Replace(Trim('$(vSelect)'), '  ', '|'),' ', '|'), chr(10), '|') & ')'

This works to get all items from spreadsheet and copy it in input box to select all those items.

[sunny_talwar]

I understand that, but You have used vSelect in your expression above. Just trying to understand what vSelect is?

[markgraham123]

sunny,

I created a vSelect variable to store all items into it.

[sunny_talwar]

Is this done manually? or using an expression?

[markgraham123]

Here is the sample app.

[sunny_talwar]

So in this example you would want to see 2 and 3 selected because 1 is entered in the input box? Sorry I did not know you were using input box for vSelect