Q
Problem solve Get help with specific problems with your technologies, process and projects.

Setting up a help desk app with @DBLookup and @columlookup

Help! I am new to Notes applications. In fact, I have just finished a help desk application, and now I would like to set up a @DBLookup and @columlookup. I want the user to be able to enter in the user ID, and the name, address, phone#, and other info would appear, so that all the tech will have to do is enter in the problem. Is this possible?

I think that I have to create a view with columns, but I don't know where to go from there. Also, I have a hardware/software app that I would like to link to the help desk app and have a pop-up box that will show the related hardware for that user. I guess that I am just wishing. Thanks for your help.

What you need is a view that contains documents sorted by userID. When the user enters their userID, you can execute a series of lookups and then populate the other fields.
 . . .
TempUserID := @Prompt
([OkCancelEdit]
; "UserID"; "Enter your UserID"; "");
@SetField("Name"; @DbLookup("";
"":"UserDatabase";"UserID"; TempUserID;
"Name");
@SetField("AnotherField"; @DbLookup
("";"":"UserDatabase";"UserID"; 
TempUserID;"AnotherField");
 . . .

Do you have comments on this Ask the Expert question and response? Let us know.


@DBLookup advice

 Home: Introduction
 Tip 1: @DBLookup function for Web
 Tip 2: LotusScript equivalent of @DBLookup and @DBColumn
 Tip 3: Use scheduled agent to refresh all @DBLookup/computed values
 Tip 4: Error with @DBLookup command: 'Entry not found in index'
 Tip 5: JavaScript version of @DBLookup and @DBColumn
 Tip 6: Using Ajax as a replacement for @DBLookup
 Tip 7: Set up a help desk app with @DBLookup and @Columnlookup
 Tip 8: "Field or view column exceeds 32 Kb" errors using @DBLookup
 Tip 9: Workaround for @DBLookup error
 Tip 10: @DBLookup and @DBColumn for all browsers using Ajax

This was last published in May 2004

Dig Deeper on Lotus Notes Domino Application Development

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

Search400

  • 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 ...

SearchDataCenter

SearchContentManagement

Close