How do I create a dialog list with emails in Lotus Domino that allows the Originator to only see the name not the emails?

For example, if my list contains the following names:

Charles Wentworth
Sally Kline
Peter Cunningham

and their respective emails are:

cwentworth@abc.com
skline@abc.com
pcunningham@abc.com

How can I code the emails to be placed in the field value behind the scenes for the distribution, but allow on the client end them to only see the list as names?
fselliottAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mbonaciCommented:
Use hidden field for mail addresses.
Show only names in dialog.
After the dialog is closed, to get e-mails of seleced person use:

@Replace( sourcelist ; fromlist ; tolist )

sourcelist is field from dialog
fromlist is the list of all names
tolist is the list of all mail addresses


Or, even better, use List in LotusScript, with name as list_key and mail as list_value.
0
fselliottAuthor Commented:
Cany you explain this in laymans terms please?  I've tried several ways but I'm just not getting it right.
0
mbonaciCommented:
@Replace returns the sourcelist, with any values from fromlist replaced by the corresponding value in tolist.
If none of the values in fromlist matched the values in sourcelist, then sourcelist is returned unaltered.

e.g.
@Replace("Red":"Orange";  "Orange":"Blue":"Red":"Green";  "Black":"Brown":"Gray":"White")

will evaluate to this list:

"Gray" : "Black"

How:
- it goes through sourcelist
- takes first element "red"
- then locates "red" in fromlist and establishes it's third in the list
- then takes third element from tolist and puts it in result list (list it'll return when it finishes)

- then it takes second element "Orange"
...

Now clearer?
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

mbonaciCommented:
In other words:
when you write the Replace function like in the example above you tell the function to:
    return the sourcelist, but first replace:
    "Orange" with "Black"
    "Blue" with "Brown"
    and so on...
0
Sjef BosmanGroupware ConsultantCommented:
Can you rephrase your question? I'm afraid I don't understand what you want. Are you talking about:
- a view
- an existing mail, e.g. in the Inbox
- a new mail you're preparing
- is it the standard mail template, or a different one?
- and, most importantly, why do you want to hide information?

Address information can usually be found in the Document Properties, 2nd tab...
0
fselliottAuthor Commented:
I'm using a dialog list to show the names to the client on a form.  I do not want them to see the emails that are going to the companies outside of ours, but I want to use the emails for distribution.

I am reading the HELP section on the @ReplaceSubstring function right now.  It looks as though I can create a hidden field that translates the dialog list name(s) chosen into a string of emails. Correct?
0
mbonaciCommented:
Yes, that's right.
Also, if your database design is hidden (which is normally the case) the user wont be able to see hidden field value even in document properties.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
fselliottAuthor Commented:
Where/how is the database design hidden? And that makes me think - shouldn't I also prevent changes being made by the company we replicate to?
0
fselliottAuthor Commented:
Thank you!  
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.