Select by Default

[#1]

Hi,

In my dashboard, I have a Multi-box object as a filter with several dimensions.

I need fix values on one or two of these dimensions just for when the dashboard is opened, in order to it presents data filtered according these dimensions in the  multi-box.

How I can do that?

[#2]

Here is a thread that may be of interest to you.  I know it says macro, but the solution given there uses document actions instead which makes it much easier

Macro for default Selections

[nam]

Settings>sheet Properties>Triggers.. you can put a trigger on activate to make the

[Jason_Michaelides]

How about just saving the doc with the selections made?

[#5]

I already do that, but it's not working

Thanks!

[Jason_Michaelides]

How do your users access the application?  You could save a bookmark, then give a URL to the users that opens the doc and applies the bookmark.

[alec1982 · Accepted solution]

Set the trigger on Opening the document to select these values.

Setting>>Document Setting>>Triggers>> On Opening>>Type in the field name and the field value.

[Jason_Michaelides]

A word of caution against OnOpen triggers...they can be problematic. For example, I had persistent browser crashes with IE10 when using OnOpen triggers. Once they were removed the crashes stopped.

I would always minimise use of triggers if possible.

[#9]

You can put a trigger on opening the QVW that makes the selections in the fields you want.

Settings > Document Properties > Triggers > Document Event Triggers > OnOpen > Add Action

Here you will add Action Type "Selection" with an Action of "Select In Field"

[#10]

Both ways: vía URL and direct from server...

Because of that, I need fix the defaults...