SharePoint question -- Adding "metadata" to a work item as it goes down an approval chain?

We have Microsoft Offices Sharepoint Services 2007 installed on our SharePoint server, and I'm trying to use SharePoint Designer to create a simple workflow.

I want the following overall effect:
1.  User A logs in and enters one or more work items.  He has three fields to fill out.

2.  User B (the "team lead") logs in and sees the items that User A has created.  He can modify any of User A's work items, and has two or three additional fields per work item that he can fill out.

3.  When User B finishes his step, SharePoint forwards them to User A.  User A can now see (but not edit) the extra fields that User B added.  User A now performs some task in the real world based on this information.

The key concept here is that User A submits an item with N fields, and by the end of the workflow, they receive their original item with M additional fields.

Any tips on how to implement this type of workflow?
ThoughtProcessAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

dp_expertCommented:
Hello

It would be hard to have it implemented with OOB tools. You can try SPD to hide the fields with javascript depending on the user's permisions and the item state.

You can also try these free add-on:
http://spff.codeplex.com/
http://sfg.codeplex.com/

If you are taking a paid solution into account, then my company has two products that in my opinion can ideally fulfill your requirements:

You can try this product - SharePoint column protector to protect the fields you want. There is a 30 day trial so you can try it and see if is suits you - www.datapolis.com/en/Products/SharePointColumnProtector.aspx

This product is also embeded in Datapolis Workbox - a graphical workflow designer  -also with 30 day trial www.datapolis.com/workbox. You can design the entire process and hide the selected fields for selected users for every process phase.
There is a short demo how it works - http://www.youtube.com/watch?v=lNWKaQWT0zE&feature=youtube_gdata (this video is a bit old - now we display the readonly columns on the edit form, without hiding them).

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ThoughtProcessAuthor Commented:
I would have preferred a way to implement this without 3rd party tools, but I'll investigate this solution further.
0
ThoughtProcessAuthor Commented:
dp_expert,

I hit "submit" too early.  THANK YOU for your input!  I appreciate the time that you took to put together this message. :-)

Thanks!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.