asked on

populating information from a shortname

I have a users form

ShortName: [UserName]

First Name: [FirstName]
Last Name: [LastName]
Email [Email]
Phone: [Phone]
Manager [Manager]

Is it possible to update all the fields under shortname after they select a person?

Jaziar

ASKER

I am thinking they will use the Address book to find the user. So maybe I could have a userName as the first field and the shortname will populate like the rest.

Sjef Bosman

Set on the first field
Refresh document on field change

Jaziar

ASKER

I under the stand the FirstName has to computed, but how does the field know to get the values from the document used to get UserName?

p_partha

Do a dblookup or nameslookup with Username as the key

Partha

Jaziar

ASKER

I put this in a feild default -UFirstName

@DbLookup("":"NoCache";"domino1/Lexmark":"names.nsf"; "($Users)";UserName; "FirstName");

I get the error on open that UFirstName is not in Index

Jaziar

ASKER

Being the UserName is a person field I do not have the option to refresh the fields - do I need a action button that refreshes all the fields - should the fields be computed.

HappyFunBall

Yes, you should use an action button instead that populates the Username field as well as the other computed fields. Then you won't need to rely on the refresh on keyword change option.

Jaziar

ASKER

100 points to show me some code :)

ASKER CERTIFIED SOLUTION

HappyFunBall

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jaziar

ASKER

Thanks