Monday, April 13, 2015

SharePoint: Simple Sample Approach to Autonumber

Below is a formula for a quick and dirty autonumber for lists in SharePoint. There are a variety of ways to generate this field. Some solutions use workflow or external lists, but I prefer this method because of its simplicity.
Note: Because this solution depends on the record’s ID column, it generates the autonumber *after* a record has been added, so if you need the autonumber to appear in the “New..” form, this solution is not for you. My project, which required the Request Number to be in “WR-0000″ format, was fine with having it generated after the fact.
To create my Request Number, I created a new calculated column, named it Request Number and entered the following formula:
=CONCATENATE(“WR-“,REPT(0,4-LEN(ID+1)),ID+1)
This formula combines WR- with leading 0’s and the ID number that’s built into SharePoint lists. The output looks like so:
WR-0001
WR-0002
WR-0003
WR-0004


Article Link

Thursday, April 2, 2015

Performance Tuning

To enable and see Developer Debug tool on SharePoint pages.


http://www.wonderlaura.com/Lists/Posts/Post.aspx?ID=201


http://www.aptimize.com/Upload/docs/SharePoint-Performance-Optimization-10-Steps.pdf


http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=189


$dash =


[Microsoft.SharePoint.Administration.SPWebService]::ContentService.DeveloperDashboardSettings;


$dash.DisplayLevel = 'OnDemand';


$dash.TraceEnabled = $true;


$dash.Update()