Custom Quick Edit Button

To add a custom Quick Edit button to a page or view, add a Script Editor Web Part and embed the following code. Make sure you change the number in [WPQ2SchemaData] to the ID of the Web Part you want to Quick Edit. You can find that by inspecting the list or library Web Part using … Continue reading Custom Quick Edit Button

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

Excel 2016 – “We didn’t find anything to print.”

Error message: "We didn't find anything to print." Symptoms and Testing: Opened an Excel document we use as a template from SharePoint and saved it as a new document. Tried to print the new document and received the message "We didn't find anything to print." in the print preview pane. Tried to print the original template … Continue reading Excel 2016 – “We didn’t find anything to print.”

Update List/Library Columns With External Content Type Columns

Scenario: You have a column on a custom list or library that needs to be back-filled with data from an External Content Type (ECT). Solution: Create a list from the ECT and use PowerShell to update your custom list's column with the ECT's list column. Creating a list (assuming you already connected an ECT): Open SharePoint Designer 2013 … Continue reading Update List/Library Columns With External Content Type Columns

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

Unlock Documents With PowerShell

One of my users was constantly getting locked out of his own documents. Upon saving a document, he would receive the following error: "The file "filename" is locked for exclusive (or shared) use by "his username"" The issue was that his user only had "contribute" permissions. While that should be enough, he needed "edit" permissions to avoid … Continue reading Unlock Documents With PowerShell

Filter Items By First Letter

Copy the following JavaScript into notepad and save it as a .txt file. Upload this text doc to the Site Assets library. Create a calculated column on the library you want to filter and name it "FL". Add this to the Formula field: =IF(ISNUMBER(INT(LEFT(Title,1))),"0-9",LEFT(Title,1)) Add a Content Editor web part to the page and open … Continue reading Filter Items By First Letter