Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Created another variable: vSelectExcluded and added another action of Select Excluded. See if this serves your purpose
What is your definition for vSelect?
vSelect takes the list of items.
Is it picking those using GetFieldSelections()?
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.
I understand that, but You have used vSelect in your expression above. Just trying to understand what vSelect is?
sunny,
I created a vSelect variable to store all items into it.
Is this done manually? or using an expression?
Here is the sample app.
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