Skip to main content

Project Server Read Only Custom Fields

There are multiple ways to create read only custom fields in Project Server 2007/2010/2013. The most common way is through Javascript and a Content Editor Web part
(see: http://technicaltrix.blogspot.dk/2014/10/project-server-read-only-custom-fields.html).

Another more simple way is to use the build in custom fields in Project Server. The downside in this solution is that it is not as flexible as the javascript solution, however it can easily solve the most common scenarios.

Read only custom field - through standard functionality

Assume we have a custom field "Project SAP Number", this field is maintained by the PMO and we do not want the project managers to change it.
We would then create a new calculated custom field.
Go to the PWA and navigate to Server Settings->Enterprise Custom Fields and Lookup Tables.
Click on New Field.
Name the new field "Project SAP Number (Read Only)" and select "Project" in Entity, "Text" in Type and "Formula" in Custom Attributes (see below).
In the Enter formula type the name of the custom field you want to be read only, surrounded by brackets. In our case it's [Project SAP Number].
Click Save.

Now navigate to the PDP where you want the read only field to be displayed. Edit the PDP and modify the Project Fields web part.
Add the "Project SAP Number (Read Only)" field.
Click OK, OK and Stoop Editing.
The field is now read only on the selected PDP.

Note: If you like you can have a PDP only viewable for the PMO with the actual "Project SAP Number" field, this way the PMO can view and edit the field and project managers can only view the field.
The trick is simply to limit the SharePoint permissions so only the PMO can see this PDP.




Comments

Popular posts from this blog

Azure DevOps - Gantt Chart

It's been a while since my last post - in the past couple of weeks I have played around with some videos of topics I find interesting. One of these topics are a very cool way of displaying a Gantt Chart upon your Azure DevOps board's. Check it out here!

Sharepoint/Project Server App with javascript and Web Part

Getting Project Server code to run in a AppPart Today I tried to get project server CSOM/javascript code to run within an app part. This caused a lot of troubleshooting and guessing to get it to work. By simply adding the ps.js library to the app part page I kept getting an error. Library: <script type="text/javascript" src="/_layouts/15/ps.js"></script> Error: "executeordelayuntilscriptloaded is undefined" Then I tried to use ScriptLink to load the library but got the same error. <SharePoint:ScriptLink runat="server" Name="ps.js" Localizable="false" OnDemand="False" LoadAfterUI="True"></SharePoint:ScriptLink> The code I was trying to run was very simpel and worked fine if I added it to a normal aspx page.  $(document).ready(function () {     var projContext = PS.ProjectContext.get_current();       var projects = projContext.get_projects();     projContext.load(projects...

PowerShell results size unlimited/truncated - $FormatEnumerationLimit/Width

Ever experienced the problem where you run a Powershell command and you cannot see the whole result because the result is truncated. Problem: If you for example run the Test-SPsite command you might see something like the following: Site : SPSite Url=http://atlas/pwa Results : { SPSiteHealthResult Status=Passed RuleName="Conflicting Content Types" RuleId=befe203b-a8c0-48c2-b5f0-27c10f9e1622, SPSiteHealthResult Status=FailedWarning RuleName="Customized Files" RuleId=cd839b0d-9707-4950-8fac-f306cb920f6c, SPSiteHealthResult Status=Passed RuleName="Missing Galleries" RuleId=ee967197-ccbe-4c00-88e4-e6fab81145e1, SPSiteHealthResult Status=Passed RuleName="Missing Parent Content Types" RuleId=a9a6769f-7289-4b9f-ae7f-5db4b997d284, SPSiteHealthResult Status=FailedError RuleName="Missing Site Templates" RuleId=5258ccf5-e7d6-4df7-b8ae-12fcc0513ebd, ...