Populating data from another List RRS feed

  • Question

  • I have two lists. One is a consulting request list, and the other is one of 9 Solution Request Lists. After the user requests the consultation and the consultation is closed, We will be providing the requester with a Consulting Request Number, and a link to a solution oprdering page. When the requester inputs the Consulting Request number, we want all matching fields to be populated into the solution request list. Can you recommend a method for this? I am trying to avoid coding, but have found no simpole method of doing this within sharepoint. here is what it would do. Please advise.

    User enters Consultation number to new list item
            Solution number to be generated from Consultation Number + backend text
                    ENS200903260001--------------------------------->>>> ENS200303260001-RVPN

            Following fields would need to be populated to exact fields in Solution Request List
                    User ID ----------------------------------------------->>>> User ID
                    User Location --------------------------------------->>>> User Location
                    User Department ----------------------------------->>>> User Department
                    User Supervisor ------------------------------------>>>> User ID
                    Business Case -------------------------------------->>>> Business Case
                    Financial Benefit ------------------------------------>>>> Financial Benefit

    Please advise. Again, if this can be done in Sharepoint without coding, would be greatly appreciated. Thanks to all for your assistance.
    Thursday, March 26, 2009 2:17 PM


  • Have you got access to use a SharePoint designer workflow, this should provide all the logic you require above, and does not need any coding.

    Gavin Morgan - http://blog.gemsolution.co.uk
    • Proposed as answer by AndyGett Tuesday, March 31, 2009 2:17 PM
    • Marked as answer by Mike Walsh FIN Tuesday, March 31, 2009 4:18 PM
    Tuesday, March 31, 2009 10:41 AM

All replies