SharePoint | Change Settings of Calculated Column

By -
Problem:
It seems that, starting SharePoint 2010, some Site Column types do not allow changing the Column Settings to "Required", "Optional" or "Hidden", through the UI (browser), as they are greyed out.
One of these types is the Calculated column.



Solution:
This seems to be by design, a feature they say, probably a bug the way I see it.
Anyway, the same thing can be done through SharePoint Designer or PowerShell.

SPD:

If we open the List, go to the Content Type and go to Edit content type columns we will get to the view below. Although the calculated columns are grayed out as well, we can click the property until the dropdown menu appears, select the new property, and save the changes.

1/ Open SharePoint Designer 2010.
2/ Open the website that contains your list with the calculated column.
3/ Click on "Lists and Libraries" in the left column (under Site Objects).
4/ On the right, click on the list that contains your calculated column.
5/ Under "Content Types", click on the content type where you want to hide the calculated column
6/ In the content type screen, click "Edit content type columns" under "Customization
7/ In the column "Property", try clicking a few times on the "Optional" value until it changes into a dropdown list.
8/ Select "Hidden" from the dropdown list.
9/ Save your changes.



PowerShell:

A simple PowerShell script can also work by setting the visibility for each form type.

$web=get-spweb
$list=$web.Lists[“ ”]
$field=$list.Fields[“ ”]
$field.ShowInViewForms=$false
$field.ShowInDisplayForm=$false
$field.ShowInEditForm=$false
$field.ShowInNewForm=$false
$field.Update($true)
$web.Dispose()


Sources:
http://social.technet.microsoft.com/Forums/en-US/b678cc72-b7a1-42c5-a488-1e15736c39df/calculated-columns-value-cant-be-set-hidden-in-2010-but-it-can-be-done-in-2007

http://social.msdn.microsoft.com/Forums/sharepoint/en-US/4c07a7fc-d80b-4b3a-b3df-bd3e869ac606/set-a-calculated-column-as-hidden-in-a-content-type?forum=sharepointgeneralprevious

http://social.msdn.microsoft.com/Forums/sharepoint/en-US/7a3c7846-3b4f-4c76-9686-f89f1e16a4cf/hide-a-column-of-a-sharepoint-list?forum=sharepointcustomizationlegacy

Comments

Post a Comment

Popular posts from this blog

Breaking down document locking in SharePoint

By -
Image
This is a topic I've been meaning to discuss in a while. We open, change and close documents almost every day, and sometimes we collaborate with other people at the same time on those documents. SharePoint brings all co-authoring features we need, straight out-of-the-box, but sometimes, there are problems. While things are starting to look better on the cloud side, the concept of document locking is still very much up-to-date and understanding how it works and what to do when things go wrong is crucial. In an article that has since disappeared the Microsoft Knowledge Base (but still available here ), Microsoft explains it best: When a document is opened by a client program, Windows SharePoint Services puts a write lock on the document on the server. The write lock times out after 10 minutes. Users cannot modify the document during the time when the document is locked. In a scenario where the program that opens the document unexpectedly quits or crashes and you try to open the do
Read more

Working around X-Frame-Options for iframes

By -
Image
The problem: One of the first things we noticed after migrating to SharePoint 2013 was that our iframes have stopped working, giving the error: "Refused to display 'http://contoso/pages/home.aspx' in a frame because it set 'X-Frame-Options' to 'SAMEORIGIN'." Quickly we could see that this is in fact a security mechanism to prevent click-jacking and others: "The X-Frame-Options HTTP response header can be used to indicate whether or not a browser should be allowed to render a page in a frame or iframe. Sites can use this to avoid Clickjacking attacks, by ensuring that their content is not embedded into other sites." Soon we realized that, starting SharePoint 2013, an HTTP Module is adding the header " X-Frame-Options " by default, with the value " SAMEORIGIN ". This is effectively preventing the rendering of pages outside the scope of the current web application. The (attempted) solution: So what to do?
Read more

Document ID not being generated

By -
Image
Problem In a scenario where we have many document Content Types, we may want to enable Document ID - aka "Permanent Links" - which is a feature in SharePoint that assigns a specific ID for each document. That ID never changes even if the document is renamed or moved to another location. In this scenario, the Document ID field was being generated for some libraries/content types, but not others, which is a surprisingly common problem. Background There are several stages we need to go through to enable use this mechanism. Stage 1 We enable the feature in the Site Collection Features. Stage 2 Under Site Collection Administration > Document ID Settings, we need to enable the assignment and pick a prefix. The IDs use the format: PREFIX-LISTID-LISTITEMID ( ref ) Where: PREFIX: the preconfigured prefix for the site collection, which can be any set of numbers and letters between 4-12 characters LISTID: the property docid_msft_hier_listid of the list
Read more