How to Clear Multiple Fields

[#1]

Hi,

I have a requirement wherein out of the 20 selections made i need to clear 17 of them and keep the other 3 selections as is and also the  use must be able to change the selections made on these 3 fields.Please let me know how this could be acheived,I tried using the clear other field action and giving the field value as (Field1|Field2|Field3).But it does not work

[tresesco]

(Field1|Field2|Field3) - works unless the values have spaces in between. If spaces are there try like:

=("Value  1"|"Value  2")                   // enclose within double quotes.

Otherwise try to share your app sample.

Update: Are you talking about multiple fields or field values? For multiple fileds, you have to use multiple triggers; way you tried won't work then.

[ajaykumar1]

Hi,

Can you try other way like select in field put all your 17 fields.

Regards,

Ajay

[#4]

Hi Tresesco,

I have put them within [] (Square brackets) But still it does not help

[#5]

Hi Ajay,

Adding all 17 within the Select in Field does not seem to be feasible option as there are possiblities that an unexpected 18th selection could be made

[ashfaq_haseeb]

Hi,

Have a look at attached file, you can always search in field by passing values in i/p box.

First time pass 20 values, second time pass 3 values.

Hope it helps

Regards

ASHFAQ

[tresesco]

Note my update statement, multiple fields won't work. You have to use separate triggers for each fields. 'Clear other fields' is for something else. It actually:

"Clears the selections in all the other sheet objects, while maintaining the ones in the current list box."

[israrkhan]

what if you use "clear all" first, and than use "select in field" for those three fields...