When a selection is made from a specific block chart object, I'd like to take the user to another tab...so selection, set filter, activate tab. However, this field is used throughout the application so I can't set a document trigger that activates the tab whenever a selection is made from that data field...only from a specific object. Thoughts?
Unfortunately, block chart objects are not coming with "Actions", so you can't trigger the thing directly.
You can try work around solutions, for example:
1. When the block chart is being activated, set a variable "vBlockChartActivated" = 1, and then a compensating action "vBlockChartActivated" = 0, when it's being deactivated, or on any other sheet opening, etc...
2. Define a document trigger based on the field selection that will set another variable to 1 only when "vBlockChartActivated" = 1
3. Define the final action or a set of actions, based on the combined condition - the field was selected from, and the chart was active.
This idea might require some tweaking and fine-tuning.
Another work around could be based on data Fields... You can have a clone Field with the same values. Throughout your application, use the original Field name, but only for this particular chart, use the "clone". Then you can define a Document trigger, based on the selection made in the "clone" field.
