Clear All Selection with Background Filter

[#1]

Hello Community,

Does anyone know how I can keep a default selection on a sheet even when the Clear All Selection button is hit and if a Person is selected and then unselected?

Thank you kindly!

[#2]

Hi,

Try using locking feature to lock the desired selections on the fields.

[#3]

Hi,

Thanks for your response, but that won't work because if I lock selection for Persons A-Z, I cannot just select Person B or C. I would like to apply a filter to a field that is not in a list box (e.g. DEPARTMENT = "Sales").

[#4]

Joming,

Could you post an example to get a clear understanding??

[#5]

Hi Kiruthi,

Here's a sample:

I have a sheet trigger on activate that filters to Grade='A'. But notice if you hit Clear Selection, you lose this filter. Likewise, if you select anything in the CLIENT list box and then unselect it, you lose the Grade='A' filter. I would like the Grade='A' filter to persist no matter what selections are made throughout the sheet. Hope that is clear...

Thank you for any suggestions,

Joming

[sundarakumar]

Use always one selected on the particular filed. In the list box the option is available in general tab. Make sure u have selected only one value in the list box, this will make this option available..

-Sundar

[#7]

Hm...I don't have a list box with the Field that I need the filter to be applied on (The field, "Grade", in the case of the Sample). In the real app, such a list box would cloud the look of the app.

[#8]

Use the suggestion by Sundarakumar and hide the list box. Something like this.

[NickHoff]

Click on setting > document properties, then click triggers.  Once there you will see "Field Event Triggers", select the name of the field you would like to keep selected and add an action to lock field.

[#10]

Great! Thank you Padmaja and Sundarakumar for the solution!