Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have requirement like below,
For one of sheet I need to show selection for only Month='Dec', Year='2016', whenevr I am navigating to other sheet I need to clear the selection and show all data as it is.
Can you please suggest how to proceed.
Thanks
Just use a trigger on the sheet to select / clear the values as necessary
or you can also use Alternate state for the particular tab (not sure how exactly you plan to use it, but the closest solution to you description seems to be adamdavi3s idea of using sheet level triggers)
Go to sheet properties -> Triggers -> Actions
Then select the field and value
Thanks but can you please suggest how should i clear the selection for remaining sheets so that default view can be displayed.
Thanks
Use on leave trigger on this same sheet to clear selections in Year and Month field or clear all fields (based on your requirement)
As per my original answer which this one just repeats, just use a clear field function on a leave sheet trigger
Hi All,
When I am clearing selection in access point default selection is not selected on a sheet where I have applied the trigger.
Thanks
you need to set triggers 'on ActivateSheet'- so when you open the tab its clear all selection and next apply the year and month filters (order is very important)
and you can on leave for example clear all if you need but