@dblookup command to populate multiple fields in Lotus Domino database

0 pts.
Tags:
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
ASKED: January 25, 2005  10:02 AM
UPDATED: January 25, 2005  10:55 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Stiletto
    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.
    2,945 pointsBadges:
    report
  • Brooklynegg
    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.
    3,845 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following