Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Instead of using Clear Other use a Clear Field action for each field you want to clear.
tq....I dont find ant action saying Clear field....I am using QV9 I have clear alla nd clear other fields.....
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
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...