clear some fields while navigating from one sheet to another

[Anonymous]

Hi,

I have multiple sheets in a dashboard.

While users can select multiple fields in one sheet, i need to clear all except region, country,state (these 3 are grouped as one dimension called Geography).

Please can anyone suggest a script/macro to enable this functionality.

Thanks in advance

[jrepucci15 · Accepted solution]

See Sheet properties / Triggers

My typical process is
Lock Field  (in your case, region, etc...)

Clear All

Unlock All

Also see:

Select in Field

or Clear in Field

[Anonymous]

Yeah i know we can use the Clear Field as Action, but i was actually looking for some code if we can add do it together rather than adding each field with"Clear Field"

[jrepucci15]

I agree, it would be nice to have some code rather than do the tedious process of setting up the triggers and actions.

Most of my pages have both on enter & on exit triggers AND actions attached to the "Clear" button. 

I also have some Document Properties /  Triggers (of all three varieties).

At least once a year I have to sweep through all of the applications and update the documentation showing all of the actions & triggers.  Tedious.  Would be nice if there was a central spot for all of those.  (sigh)