Hiding Calculated Columns from Display Form

By default, the option to hide a calculated column for a content type is grayed out. Some people are able to use SharePoint Designer to hide these columns, but we kept running into an error when saving our changes. "This column already exists in the list. Choose a different column." The workaround, as always, was … Continue reading Hiding Calculated Columns from Display Form

Workflow to Update Hyperlink Display Text

Problem: I wanted to use Quick Edit to update the URL column for a bunch of items in a list. The problem is that when you edit a hyperlink column, you have to click the little hyperlink editor icon next to the cell to also edit the display text. Otherwise, it just shows up as … Continue reading Workflow to Update Hyperlink Display Text

Internal Column Names

Document Library Fields: Display Name Internal Name GUID Type ID ID {1d22ea11-1e32-424e-89ab-9fedbadb6ce1} Counter Content Type ID ContentTypeId {03e45e84-1992-4d42-9116-26f756012634} ContentTypeId Content Type ContentType {c042a256-787d-4a6f-8a8a-cf6ab767f12d} Text Created Created {8c06beca-0777-48f7-91c7-6da68bc07b69} DateTime Created By Author {1df5e554-ec7e-46a6-901d-d85a3881cb18} User Modified Modified {28cf69c5-fa48-462a-b5cd-27b6f9d2bd5f} DateTime Modified By Editor {d31655d1-1d5b-4511-95a1-7a09e9b75bf2} User Has Copy Destinations _HasCopyDestinations {26d0756c-986a-48a7-af35-bf18ab85ff4a} Boolean Copy Source _CopySource {6b4e226d-3d88-4a36-808d-a129bf52bccf} Text Approval Status … Continue reading Internal Column Names

Update All List Items Using PowerShell

Scenario: You added a new column and need to update that column for every item in a list or library. Solution: Here is an example PowerShell script that can be used to update one or more columns for every single item in a list. Remember: change $WebURL to the URL of the site or subsite … Continue reading Update All List Items Using PowerShell