Pulling additional data fields along with the primary field in a DBColumn lookup.

15 pts.
Tags:
Domino Designer
Lotus Domino
Lotus Notes
Lotus Notes Formulas
LotusScript
I'm a newbie to Domino and Lotus Designer, and am loving the seemingly inexhaustable flexibility and power that Domino has to offer. But I was wondering if someone could help me with what is probably a very simple question.

I have created two Notes databases on the same server. Addresses.nsf contains static customer contact information. Incident.nsf is a primary customer-facing database which is used to track daily contact events. From within Incident.nsf I want the user to be able to use a pull-down list to select a customer contained in the address.nsf database, and then once chosen, to have some additional fields from that same document to be carried over and populated in the incident form currently being edited.

To do this I have done the following: From within Incident.nsf I setup a listbox field which uses a @DBColumn lookup to provide the drop-down list of names which can be selected as valid name choices (@DBColunm("":"NoCache";"":Address.nsf";"ListAll";1). This functionality works exactly as I want. But the problem I have is in how do I also pass along other field values from this chosen external document back to the current incident form being created in the Incident.nsf database to populate other fields?

Example of information I would like to transfer back to the current form are things like street address, city, state, etc. which are directly related to the name which was chosen from the listbox names pulled by the @DBColumn formula. I would like the names field to be populated by the @DBColumn procedure (or any other method if there is a better way to do this), and then based upon whatever the choice is chosen from that list; the related field data information will be automatically populating theĀ corresponding fields in my incident form.

Any info that someone could give me to point me in the right direction to accomplish this task would be very appreciated.

Answer Wiki

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

Best way I have found, if I understand correctly, is to make a single column that delimits a string with all the data I want. Then when you get the info returned to you, separate (@Explode) to get the individual elements. Generally much faster than several lookups.

Discuss This Question: 4  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
    Agreed. I usually put a hidden column in the view that I use for lookups. The formula for that column is the data I want separated by "~". For example, an entry might look like: John Doe~5551212~45 Use @Picklist to present the view and get the data in the hidden column. Then, use @Explode to separate the data back out into an array, and assign the elements to the appropriate field values, like: FIELD Name := lookup[1] FIELD Phone:= lookup[2] etc.
    4,050 pointsBadges:
    report
  • YoDoctor
    Thank you both ever so much for the replies.... Any chance you could show a sample Script code including both the @Picklist and @Explode commands in conjunction with the filed assignments? I'm struggling with piecing it together as a cohesive I really appreciate the assistance, and for helping pointing me in the right direction.
    15 pointsBadges:
    report
  • YoDoctor
    [...] Pulling additional data fields along with the primary field in a DBColumn lookup [...]
    0 pointsBadges:
    report
  • VikramSolanki
    I agree with the comments from SLikTool.. We have made use of this way to perform dblookup and it works absolutely fine for me.
    10 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