Access Document via Dialog List?

I have what I think should be a very simple question—I’ve searched the Forums, but to no avail. Is there a way I can access the document a user selects in a Dialog list (namely, fields that are not listed in the Dialog List pop-up window)? I have a form where I have a Dialog list to allow the user to select a Contact. Currently, I’m able to do a lookup based on the text value entered in the Dialog List field (ie the first column in the view I use for the Dialog List lookup, currently the Contact Name). I’d like to allow the users to do the lookup (via the Dialog List) by Contact name, but I’d like to actually use the Contact Key in the Contact document the user selects (a custom key I’m generating) to lookup the document to get the values in other fields (ie address, phone). I’d like to do this without having to expose the Contact Key to the end user, to make the interface as user-friendly as possible. I hope this all makes sense. Please let me know if clarification is needed.

Any suggestions/directions would be greatly appreciated!

Thanks!

Subject: two ideas:

  1. (I don’t know if you can use this in your situation.) It is possible to specify a fieldname instead of a column number. That way, you can retrieve fields that are not visible in the view.2. Using script, explore Picklistcollection (in NotesUIWorkspace) a bit. That one returns pointers to documents.

Subject: Access Document via Dialog List?

You can use alias values to achieve exactly what you are looking for, i.e. the field value being different from the displayed text.

Construct the choices with the alias values to the right of a vertical bar, example:

Angela Krauskopf|AK47

Morten Hattesen|MH48

It’s only the alias value that gets stored in the dialog list field, so when the user selects “Angela Krauskopf” the field contains “AK47”, which you can use for your lookup.

But I would personally try solving the problem with a picklist (@functions or LotusScript), if possible. Possibly a single category picklist.

Subject: RE: Access Document via Dialog List?

Thanks so much for the great ideas! The Picklistcollection object did the trick! Thanks again!