Select in Field action

[#1]

I have a parameter (Items) containing the following values:

Apple, Orange, Table, Chair, Banana, Kiwi, Pen

I want to add a button + an action that that will select all those values except for Table and Chair.

Can someone please help with how I can achieve that? If at all possible?

Thanks,

Amit

[sunny_talwar]

May be this as the search string

("Apple"|"Orange"|"Banana"|"Kiwi"|"Pen")

[#3]

I know this can be done but I was looking for something more generic in cases where I have a long list and I need to exclude only a few.

[#4]

I think I found the answer

Basically it's 2 actions and the order is important.

Select in Field - Items

(Table|Chair)

Select Excluded - Items

Does anyone else have any better suggestions?

[stigchel · Accepted solution]

use for search expression

='('&Concat({<Items=-{'Table','Chair'}>} DISTINCT Items,'|')&')'

[stigchel]

Example attached

[sunny_talwar]

Look at stigchel‌'s response

[#8]

Hi,

You have to add "select in field" to button actions.

Your field should be "Items" and search string will be (Apple|Orange|Banana|Kiwi|Pen).

Hope it helps!

[#9]

Thank you!!!!

[stigchel]

You're welcome