Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to clear all filters when a document is reloaded or the client triggers a refresh in their browser?
We have an app that should always default to showing all data. It is displayed on a team monitor and is refreshed every 15 minutes. If someone accidentally applies a filter, It should be cleared the next time a reload/refresh occurs.
You can right a trigger for it..
Action--> Selection---> Clear all or Clear Field or Clear other field..
In Document Properties--> Triggers--> Document Event trigger you can set the trigger..
or you can right macro and call the macro in the trigger...
Sub Clear()
ActiveDocument.SetClearState
ActiveDocument.Clear
End Sub
See this blog
Clear All while Reload.
Settings -> Document Properties -> Triggers -> OnOpen Click on Add Action(s)
Actions -> Add -> Selection(Action Type) -> Clear All
Show the Default Sheet Tab when you open the Document.
Clear All while Reload.
Settings -> Document Properties -> Triggers -> OnOpen Click on Add Action(s)
Actions -> Add -> LayOut(Action Type) -> Activate Sheet , Next to Sheet ID Mention the required Sheet Name.
Hope you got the Answer