Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
michaelfentondata
Partner - Contributor III
Partner - Contributor III

Clear All on Reload or client Refresh

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.

Labels (1)
3 Replies
selvakumarsr
Creator
Creator

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

er_mohit
Master II
Master II

Not applicable

ClearAll-Reload.png

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