Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Dynamic Auto-Populating Fields (Lists)

  Asked By: Reed    Date: Mar 07    Category: Sharepoint    Views: 25002

I'm trying to find a way to have a field automatically populate based on
data entered in a different field. For example, if a user in entering
data in a list and he selects Company A from a pull down, can the
Address field automatically display the address without having to click
OK? Can multiple fields auto-populate based on the single selection of
Company A?

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Jeremey Avery     Answered On: Mar 07

You could probably do this with a very complex calculated field, but I would
think that a workflow built around that in SPD would be a better approach. I'm
sure there are limitations to it though, and it won't happen the instant that
the file is uploaded. I have a similar situation where I change the value of a
field based  on the value of other fields  in a help desk setup, but I'm sure that
the same approach could be used in your situation.

 
Answer #2    Answered By: Mariel Ferrell     Answered On: Mar 07

There are several ways to do this.

1. An SPD workflow as Jay outlined. You would need to click the OK button to do
this.

2. You can code an event handler. Again, you would need to click the OK button
to do this.

3. Create your own custom field  type so that when you select a value in a
dropdown, it will autopopulate the value in another field. The following link
is an example  of parent/child dropdown. This CFT can be modified to do what you
want.
datacogs.com/datablogs/archive/2007/08/26/641.aspx

 
Didn't find what you were looking for? Find more on Dynamic Auto-Populating Fields (Lists) Or get search suggestion and latest updates.




Tagged: