http://spjsblog.com/
http://spjsfiles.com/index.php
Tuesday, April 14, 2015
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
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
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()
Labels:
PowerShell,
SharePoint
Subscribe to:
Comments (Atom)