SP2010: Autofill from Person or Group column

Question

Using Sharepoint Designer 2010 and no access to Foundation, VB, or installation of third-party software, is it possible to do the following:

1. I have a People or Group column called Student Name. It allows the users to search our AD database and captures the name.
2. I would like a second column next to it, called Student Email, that auto fills the email associated with the person in Student Name.

Unfortunately, I don't have access to making customized code, but might be able to inject Javascript with a little help.

Is there any way to do this dynamically?

Answer 1

You can leverage SPServices http://spservices.codeplex.com/. Download the js library file and upload it into a SharePoint library (ex Site Assets)

Then edit the page in question, add a content editor webpart and link the JS files.

Now handle the onchange event of the text box where the search is happening, then use SPServices http://spservices.codeplex.com/wikipage?title=GetUserProfileByName method to get additional information of the selected user.

And populate the email of the selected user.

Answer 2

Using the SPJS Utility and SPJS Autocomplete libraries, I was able to implement this dynamically with the following code:

//intialize fields
fields = init_fields_v2();

//Autocomplete email column from name column
spjs.ac.peoplePicker({
"applyTo":"Student_x0020_Name",
"forceOn2013":false,
"helpText":"Enter name or email address...",
"showField":"Title",
"chooseFromUserGroup":null,
"showUsersOnly":true,
"rowLimit":5,
"listOptionsOnFocus":false,
"reValidateOnLoad":false,
"setFields":[
    {
        "fromFIN":"EMail",
        "toFIN":"Student_x0020_Email",
        "skipIfEmpty":false
    }
]
});