Thursday, April 20, 2006

Show-n-Tell Thursday - Preferred views

Silly little technique that I use a lot, since we have many databases with lots of views. To allow users to set their own default view, create a shared action and add it to all views:
tmpText:="Do you want to set this as your default view?";

x:=@Prompt([YesNo]; "Set view"; tmpText);

@If(x=1; @Environment("newArtTrackDefaultView"; @Subset(@ViewTitle;-1)); @Return(""))


Then set your frame content to Computed and enter the following formula:
y:=@Environment("newArtTrackDefaultView");

@If(y="";"vwUsages";y)


Show-n-tell thursday
Show-n-tell Thursday

2 comments:

Andrei Kouvchinnikov said...

For an alternative solution to Profile documents and @Environment function see my article about DigestSearch:
http://www-128.ibm.com/developerworks/lotus/library/digestsearch/
It solves problems with cached values, specially for multi-users, but is somewhat more difficult to implement.

Esther said...

I've read the article, Andrei, but in this case it seems a bit like swatting a fly with a Cadillac... just a bit of overkill for something as simple as allowing users to set their own default view.