Home > IT Answers > Lotus Domino > @dblookup command to populate multiple fields...
Help

Question

  Asked: Jan 25 2005   10:02 AM GMT
  Asked by: Rojane

@dblookup command to populate multiple fields in Lotus Domino database


Customer relationship management applications, Lotus Domino

Hi,

Does anyone know how to use the @dblookup command to populate multiple fields in Lotus Domino database. I can use it for one field now using a pop up dialog list.
[Use View dialog for Choices, Choose Database & View & Column]

Thanks in advance.

A

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Jan 25 2005  10:32 AM GMT  by studward




You can use @dblookup as the VALUE for a computed field, or a DEFAULT value for editable field by putting the corresponding @dblookup formual in each field. Be aware, multiple @dblookups on the same form can make it very slow.
When I need to do this, I usually make a view with all of my values, do ONE @dblookup, then parse to other field values from there. This is actually much more efficient to do using LotusScript though. If you want some sample code I can send it to you.
-Dale
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Lotus Domino.

Looking for relevant Lotus Domino Whitepapers? Visit the SearchDomino.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Stiletto  |   Jan 25 2005  10:32AM GMT

Design your view such that the column you’re retrieving contains all of the information you’re looking for, concatenated in some way of your choosing. A common method is to use the tilde as a concatenator. Example: the column you retrieve looks like field1~field2~field3

Then, just parse the column value for each field value.

 

Brooklynegg  |   Jan 25 2005  10:55AM GMT

Further note on Stiletto’s response, which is the best way to go: If you want the information to refresh everytime you open the document, you can put the code in the lookup in a Computed for Display field (let’s call it Lookup) then compute the individual values to the other fields using @word. For instance, if it is personnel information, the lookup for records matching an employee ID might be lastname~firstname~Middlename~Phone, or “Smith~Bob~James~(101) 555-1212″.

The formula for the LastName field would be @Word(Lookup; “~”; 1). The formula for FirstName would be @Word(Lookup; “~”; 2), and so one. If multiple records could be returned by the lookup, you can make all the fields multi-value fields and display multi values on separate lines. This gives you a table of information. Of course, you have to do error trapping, etc., which I didn’t include here, but that’s the general idea. If all the fields are computed for display, then the information refreshes whenever the user opens the document without putting it in edit mode and refreshing the document, which can be very handy. It is also very, very fast.