Wednesday, January 06, 2010 12:38 AMHi!
I have a SharePoint List where I want to auto populate the value of some of the columns from another List based on a field "Title" which is primary & unique....
I want to auto populate them when clicking "New Item" and entering data... you put the "Title" value and it should match the Title value from another List and auto-populate some the columns...
Please any idea would be highly appreciated....
Thanks in advance
Wednesday, January 06, 2010 4:08 AMHello Ashish,
You seem to have posted this same questions on 2 other forums here:
You shouldn't post duplicate threads in different forums.
Wednesday, January 06, 2010 4:22 AMWell, I was kinda confused in what SharePoint forum should i post, because the problem can be categorized in all 3 forums
Wednesday, January 06, 2010 6:28 AMNEVER NEVER post the same question to more than one forum. It wastes everyone's time.I am now going to delete those other two threads.(Thanks to pl7626 for pointing this out - I usually spot these !)(Moderator)
FAQ sites: (SP 2010) http://wssv4faq.mindsharp.com; (v3) http://wssv3faq.mindsharp.com and (WSS 2.0) http://wssv2faq.mindsharp.com
Complete Book Lists (incl. foreign language) on each site.
Wednesday, January 06, 2010 3:29 PMHi,
From your question, since you said the list is unique and primary, so for sure there is no redundant data.
You may try to use work flow to fill up the columns by using "update list item".
Create the workflow and match the value from the resource and bring the value to the list item you just created.
Hope this helps
Wednesday, January 06, 2010 7:13 PMHi,I thing you can very easily achieve this using Infopath forms. In that you just need to create one data connection to that list and you can get any column values of that list in the Drop down list box. I dont know how much familier and comfortable you are with infopath forms but they are a nice option to your requirement.RegardsGinni
Thursday, January 07, 2010 1:34 AMBased on the title of this tread and the description, I'd say this is definitely not a workflow related question. What I understand from Ashish's description is that:
1. Users browse to the newForm.aspx page of List A to enter new data to the list
2. Enter a value in the "Title" field
3. At this point, values of other fields should be populated automatically
a. The values that will be populated, are coming from List B, where the "Title" fields from List B matches the value in the current list's (List A) "Title" field.
Ashish: Please advise if I've misunderstood what you are trying to do. You can only run workflows once you saved the data, not while you are in the process of doing that. There are different approaches to this.
I don't know all of your requirements, but I'd recommend you not to populate data from the other list. Because you'll end up having duplicate data in both lists and later you'll need a workflow to synchronize the data when List B changes as per the above example. What you can do is create a Lookup field/column in List A and connect it to List B. This will create a link to List B for each records in List A.
1. Add a "onchange" event handler to the "Title" field
3. Set the values of fields in the newForm.aspx page accordingly
- Marked As Answer by Lily Wu Wednesday, January 13, 2010 1:15 AM
Thursday, January 07, 2010 2:28 AMHi Ginni!!
Thanks for your idea.. I do have little bit knowledge about Infopath forms but haven't associated one with any List...
Do you have any articles, tutorials or references from where I could learn about associating infopath with SharePoint List & creating data connection to other List
Friday, January 08, 2010 6:19 AM
References below may take you through the basic steps to create a data connection and query data from a SharePoint document library or list via Office InfoPath.
Monday, October 04, 2010 3:17 PM
I know this post is a bit old, but I just wanted to add this for anybody looking for an answer in the future.
I've been working on something similar to this where some of the fields are automatically populated based on the user when they click "New Item".
I have found jQuery and a sharepoint specific jQuery library called "SPServices" invaluable.
jQuery can be found here: http://jquery.com
SPServices can be found here: http://spservices.codeplex.com
What has been helpful for me is the "Cascading Dropdowns" feature as well as GetUserName which wouldn't be as appropriate here.