We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Auto populating a field in a sharepoint list

vithal_m
vithal_m asked
on
Medium Priority
2,391 Views
Last Modified: 2012-08-14
How do I auto populate a field on one list based on an item entry in another? I have two lists, lets just call the first list DepartmentList and the second list TaskList (both are just custom lists).

DepartmentList will be the list used to pull data from and it contains: Title, Assigned To, Team (Column type for Title and Team is Single line of text, Assigned To is People or Group)

An example value to be entered into this list - IT Support , John Smith, IT

TaskList contains: Task Name, Start Date, End Date, Due Date, Assigned To, Team (Column Type for Title and Team is Single line of text, Assigned To is People or Group, and the others are just Date and Time)

All I need is a simple out of the box solution (if any) to auto populate the Team column when a person is selected for the Assigned To field. Example, If I was to enter John Smith for the Assigned To field, the Team column within TaskList will auto populate with the value of IT.

Also, we'll need to ensure that if the value within the Team column has changed, the values within TaskList is also updated with those changes.

We're using WSS 3.0 if that makes any difference.

Thank you in advance.
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
GreatGerm: Thanks for your reply, however i'm still unable to find an acceptable solution when it comes to workflows in SPD as I am still unable to link both lists together to get the functionality as mentioned in my original post. What are your recommendations?

Things to consider:
DepartmentList is essentially a short list of users (approx 11 entries) and their associated teams (there are three different values to represent each team).
Each task needs to be assigned to a user, and ideally I would like the Team column to be auto populated when a user has been chosen (so somehow this needs to reference the DepartmentList for this). My reasoning for this is that although I could have left the option to the user to decide which Team the Assigned To person belongs to (there are only three choices), people tend to make mistakes.
I am looking for this same solution. Please update. I am a SP newbee!
Same here,

any help would be great. maybe a simple walk through in sharepoint designer.

thansk

Author

Commented:
I am unable to keep this question open as I need to post new questions.

Commented:
Was anyone able to find a solution?
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.