Best Practice - Replacing Paper Forms

[gnosis13]

My task is to replace 3 paper-based forms by incorporating into SharePoint. Each form contains, say, 25 fields with 20 fields in common between them and 5 unique to each form. They want to use as many out of box SharePoint features as possible so that the users/managers can take ownership and not bug the developers too much.

I had planned to store the data in a single list so that the results can easily be analyzed using Excel which the managers know how to use. The problem is that when the user enters data we don't want them to see the fields that do not pertain to them. If you click 'New' in a SharePoint list view you see all the fields including those not included in your particular view.

My question is: What would be the simplest/best method to achieve these results? I am hoping to find a clean way to just hide fields based on username during the new item entry but this seems to give SharePoint hemorrhoids.

 

[dinger2121]

You may want to look into using InfoPath forms.
I would search google to see if you can create personalized views.

 

[trujillr78]

just as the previous answer... i solved my issues by using infopath.

 

[gnosis13]

I actually found an easy workaround not using InfoPath. On the data entry side the users lists only contain the fields relevant to them but an automatic workflow is launched that first does a delay (allowing them time for editing) and then moves the data to the master list that contains all of the fields (create new list item then delete current).

Thanks for the help