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.
. . . 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.
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 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
Dig Deeper on Lotus Notes Domino Application Development
Related Q&A from Brian Mahoney
Find out what types of calculations can be computed for a column in a Lotus Notes view and the best way to go about it with this expert response. Continue Reading
Find out why you can't use Formula language to include a doclink to a specific Lotus Notes view or database and need to use LotusScript instead. Continue Reading
Discover the reasons behind a Notes/Domino admistrator having trouble with disabled options in the "customize this view" section of his Lotus Notes ... Continue Reading