Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 396
  • Last Modified:

Configurable picklist



The basic question is : how can i display a categorised view ( from another db ) in a user pop-up. The solution has to be configurable ( i.e. depending on my db settings , anopther view can be opened )
On creation of my document , i search in the settings of the db which view has to be displayed when the user hits a particulare button.
I used the picklist exemple from the sandbox

http://www-10.lotus.com/ldd/sandbox.nsf/ecc552f1ab6e46e4852568a90055c4cd/6a0d72dd2f052e5285256918004d5b31?OpenDocument&Highlight=0,%40picklist

and it works great if i specify the db , view , columnname statically , but i don't seem to be able to configure it , since the script works with the ComposeDocument method.

Any ideas , hope this is clear enough of what my goal is.
0
Steamer
Asked:
Steamer
  • 3
  • 2
1 Solution
 
HemanthaKumarCommented:
Create a seperate button (say plbutton) and include this code in click event..

Sub Click(Source As Button)
     On Error Goto errorhandler    
     Dim session As New NotesSession
     Dim db As NotesDatabase
     Dim ws As New NotesUIWorkspace
     Dim uidoc As notesuidocument
     Dim uidoc2 As notesuidocument
     Dim thisdoc, doc As NotesDocument
     Set db = session.CurrentDatabase
     Set uidoc = ws.currentdocument
     Set thisdoc = uidoc.document
     Set doc = db.CreateDocument
     doc.Form = "(PICKLIST)"
     doc.db = ""
     doc.view = "(LU-JobTemplates)"
     Set uidoc2 =ws.EditDocument( True, doc)
     tmpstr = uidoc2.fieldgettext( "TmpDocID" )
     Call uidoc2.close
     If tmpstr <> "" Then    
          uidoc.editmode = True
          uidoc.Document.JobName = tmpstr
     End If
     Exit Sub
ErrorHandler:
     If Err = 4412 Then
          Print "Picklist cancelled"
     Else
          Msgbox Error$ &  " occurred at line " & Erl,, Err
     End If
     Exit Sub
End Sub


Change the picklist formula in tmpdocid field to
tmp:=@PickList( [Custom] : [Single] ;db; view ; "Template Selection" ; "Please select a job template to load." ; 4);

@If(@IsError(tmp);"";@Text(tmp))

This enables you to send the db and view name depending upon the profile to the picklist form

~Hemanth
0
 
SteamerAuthor Commented:
I think i tried something similar and it didn't work because i noticed that the @Picklist formula was evaluated at Create Document , so before i assign values to db and view field.

To be 100% sure , I'll give it another try tomorrow.

Thanx in advance
0
 
HemanthaKumarCommented:
I just used the same template from sandbox and made it to work. If you want that to be mailed let me know the email address
0
 
SteamerAuthor Commented:
I tried the same but i must have chaged the computing type of the @PIcklist field to Calculate on Create.


Thanx
0
 
HemanthaKumarCommented:
It is in office, let me send it to you tomorrow.
Sorry for the late reply, I had a very long weekend
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now