How to apply filter when opening a sheet

[#1]

When I activate/open a sheet (SH16) using a button I would like a filter to be applied.  In this case, the field name is [Strategic Priority Only] and the field value is "Yes".  That is the only option for a field value.

I tried using the Action of Selection > Select in Field but it is not working.

[Clever_Anjos]

Use trigger tab at "Sheet Properties"

[#3]

Go to Sheet Properties, Actions, Selections, 'Select in Field'

[Gysbert_Wassenaar]

Did you assign that action to the OnActivate sheet trigger? If you want to select only the value "Yes" then the search string would be Yes without the quotes.

[jagan]

Hi,

Please find attached file for solution.  This is been implemented by using Sheet Properties -> Triggers -> On Activate Sheet -> Add

Please find attached file.

Regards,

Jagan.

[Anonymous · Accepted solution]

Sheet triggers don't work in WebView/AJAX.  Why don't add the select action right there, in the button?