Generic Notes Developer 4.Mar.10 12:39 PM a Web browser Domino Designer7.0.1 FP1Windows XP
Hi,
I am making a button on a view, to save me a bit of time, because the view selection keeps changing, I have to keep changing the database...
Essentially I have created a Lotus Script button,
it gives me a list of status's to select from people want to see in the view.
Using a single selection Prompt is fine, but I want it to work so you can select more than one status..
I can make the box that appears allow more than one selection, but I can't remember how to process this into a formula for the view..probably it's quite easier..I am very rusty in the Notes Development area...
Here is a sample of my code:
The selection:
Dim ws As New NotesUIWorkspace
Dim uiview As NotesUIView
Dim view As NotesView
Dim db As NotesDatabase
Dim session As New NotesSession
Set db = session.CurrentDatabase
Dim response As Variant
Dim eval
Dim RepID
tlookup = "Status"
RepID = "1111111:22222222"
Dim Values1 As Variant
Values1 = Evaluate(|"All":@DbLookup( "" : "NoCache"; "| & RepID & |"; "LkupByKey"; "Status"; 2 )| )
Dim values As Variant
values = Values1
response = ws.Prompt(PROMPT_OKCANCELLISTMULT, _
"Select a Status", _
"Please select the status's you would like in the view.", _
values(0), values)
So far so good, a box appears where you can select more than one status...
I need to process this into a view selection formula:
Something like this is required, but it needs some sort of loop I beleive:
Dim formula As String
If asklist<>"All" Then
formula = {SELECT form = "discussiontopic" & Status ="} + v1 + {"}
Else
...
Return to top
Making a dynamic view button work w... (Generic Notes D... 4.Mar.10)
. . 
Print this page
