Can anyone help? I want to be able to auto populate a field within a SharPoint list based on the most up-to-date field within another list.


List Details

Projects List - List of projects.

Fields inc. Project ID, Most Recent Comments, Status etc.

Project Comments list - List of Project Comments linked to Project List by Project ID.

Fields inc. Project ID, Subject, Comments, Created Date etc.


Therefore the 'Most Recent Comments' field in the Projects List always has the latest comment.

I know I can either use a workflow or a calculated field but not sure how to start it.

Any help is greatly appreciated. Thanks.


  • Just to note that I am currently using Sharepoint 2010 Foundation. Aug 6, 2013 at 13:44

3 Answers 3


I found the solution was a lot easier than first thought.

I just created a Reusable workflow in SPD running an update event handler which triggers upon new or any changes made to my Comments list.

Thanks for your contributions regardless guys, much appreciated.


You could use some javascript to query Comment list to find the most recent comment and push that value into the Project list form field. SPServices helps with a lot of these things.


You can use ItemAdding event handler to autopopulate the field in the list.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.