I'm trying to implement this in my work SharePoint site, which is used to store project documents (Word documents, Excel spreadsheets, Powerpoint presentations, Outlook emails). There are new projects that come up regularly, so new documents will be uploaded to the site regularly.
There are different document types, including:
- Bill of Material
- Effort estimate
- Offer document
- Price sheet
- Project schedule
There are a number of groups who would have different access levels for different document types, including:
- Engineering team
- Sales team
- Project management (PM) team
So for example, say I want to implement the following group permission levels for each of the document types:
- Bill of Material
- Full control: Sales team, Engineering team
- Read: PM team
- Effort estimate
- Full control: Engineering team
- Contribute: PM team
- Read: Sales team
- Offer document
- Full control: Sales team, Engineering team
- Read: PM team
- Price sheet
- Full control: Sales team
- No access (hidden): Engineering team, PM team
- Project schedule
- Full control: PM team
- Contribute: Engineering team, Sales team
We used to use a new folder for each project which contained sub-folders for each of the different document types, so that we can control/restrict access for each group by changing the folder permission. We want to move away from using folders and use metadata instead - however, we need to retain the different permission levels for different groups.
What I want to happen is for the document creator to specify the 'document type' as a mandatory field at the start during the document upload/check-in process. Since each document type already has the permission levels for each group pre-defined, that there is no need to manually set them for each document.
My question is, is the above actually possible to implement in SharePoint?
We are currently using SharePoint 2013 (I think), as part of the work Office 365 suite. I also have SharePoint Designer 2013 installed, although I haven't had much experience using this program.
Any guidance/advice would be great.