Is @prompt possible in views

HCL Domino Domino Forum
1

Hi,

is it possible to have a variable which gets declared when a user opens the view (using @prompt([OkCancelEdit]… )?

I want to have a view with quotations for everything older than 2 years. Since we use this database since '97 , there would be tooo much in the “All documents” view.

I want the user to input the year.

Thanks

Joerg

PS: I want to realize this with @Language, since I’m not very comfortable with LotusScript (I think it would be possible with the NotesDocumentCollection, but I had no success with trying this :frowning: )

2

Subject: Alternative #1

How about creating a Categorized view… and put the year in the first column… categorize that column… and have it Collapsed when view is first opened… then they can open the category they want. This would also allow them access to several years at once… .instead of limiting them to what they would key in IF indeed the @Prompt would work (which it wont)…

Ruth

3

Subject: RE: Alternative #1

Hi,

just sae that there have been answers to my topic :slight_smile:

Can anybody tell me what a categorized view is ? I searched the 7.0.1 Designer help, but I did not find anything ???

Here is what I can create (Am I blind or is it hidden somewhere else ?):

Thanks Joerg

4

Subject: RE: Alternative #1

A categorized view is just a view where a specific column is marked to be sorted and categorized, as shown below:

5

Subject: RE: Alternative #1

Thank you very much :slight_smile:

There are a lot of nice things, that can be done with this feature I did not knew about :slight_smile:

Regards

Joerg

6

Subject: Alternative #2

…would be to put the view in a FORM, as an embedded view… and have it a Computed embedded view, based on a field at the top… where they choose the year… then based on that field, an embedded view pops in below. For this scenario, just make one view for each year… then pop in the appropriate view when they choose from a Combo box or dialog list field above.

This is easier than it sounds…if you have questions about it… feel free to email me.

Ruth

ruth.inman@imwebworks.com

7

Subject: RE: Alternative #2

A single category embedded view would be much easier than creating multiple views. Use the categorized view from your first suggestion, with selections via a dialog/combo/list box made from @Trim(@Unique(@DBColumn(“”:“Cache”;@DBName;“view”;1)))

:slight_smile:

8

Subject: Alternative #3

very similar to a categorised view… but available in R6

use @SetViewInfo to limit view display to a single category