Dynamic Connect To Other Notes Applications

This is useful when you require to control the connectivity between two applications without revisiting the design of the application. I have used this extensively in my applications and seen the benfit over a period of time.
The tip here uses the profile extensively or you can create a separate profile form available in a separate view. The view name is "Profile" with one column that is sorted. The value shown in the column is the form name or a default value "Profile".
On the profile form create four text fields:

Server Database View Key

On the form you need to recover a list of Keywords that are available in the second database. Place the following code on the Keyword field with the following properties set:
Use Formula for choices
The following properties can be set as required: Refresh Fields on Keyword Change Refresh Choices on Document Refresh In the lookup formula place the following code:

 srv:=@DbLookup("Notes":"NoCache";"";"Profile";"Profile";"ServerName"); db:=@DbLookup("Notes":"NoCache";"";"Profile";"Profile";"Database"); vw:=@DbLookup("Notes":"NoCache";"";"Profile";"Profile";"View"); ky:=@DbLookup("Notes":"NoCache";"";"Profile";"Profile";"Key"); @DbLookup("Notes":"NoCache";srv:db;vw;ky;<fieldname / Columnnumber>)
The last Dblookup can be replaced with a dbcolumn also. The fieldname / column number can also be picked up from the profile. An enhancement to this could be using the profile commands available also eg.:

Dig Deeper on Domino Resources - Part 4

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...