Clear other fields for multiple fields

[#1]

I have 5 list boxes as filters and 2 multi boxes(Date filters) with year,day and Month fields as filters.....I have 4 tabs(sheets)....when I select any values in list boxes it will change in all 4 sheets, and in the same way with multiboxes.....but when I go to next sheet I want only the multi boxes(date filters) to clear all, and list box selections should remain as it is in previous sheet......I went trough community and found that clear other fields can do.....but I am unable to specify multiple fields in clear other fields.....thanks

[adamwilson]

Hi

Instead of using Clear Other use a Clear Field action for each field you want to clear.

[#3]

tq....I dont find ant action saying Clear field....I am using QV9 I have clear alla nd clear other fields.....

[adamwilson]

I'm not sure if Clear Field is available in QV9

In that case you need to add multiple actions to the trigger in order to clear one selection:

Lock All

Unlock Field (the field you want to clear)

Clear All

Unlock All

[thomduvi83]

You can also try :

"Select in Field" action with nothing in "Search string" to remove a selection in one field.

It's working well in V11...