programming4us
 
Technology
 

Sharepoint 2013 : Enforce Custom Validation on a Column

8/14/2013 9:30:53 AM

Scenario/Problem: You want to set more complex validation rules on a column. For example, in a single text column, you might want to prevent users from entering certain words, such as the word test. Or you might want to make sure the user filling in the form types I agree before submitting the form to make the user think twice before submitting it.


Solution: Most column types support a rudimentary type of validation, allowing you to select whether the column must have a value (in most cases). Some columns are even more specific, requiring you to, for example, specify a minimum and a maximum for a Number column. However, sometimes you need more validation options than are available.

Some SharePoint columns support a formula-based validation mechanism similar to Microsoft Excel formulas. This mechanism is available for columns under the Column Validation heading, and this heading is collapsed by default. Expanding this section reveals two additional settings that you can set for the column.

The first option is the formula. Here you can type a formula that is evaluated when the user tries to save the value for that column. For example, you can add a formula to prevent the word test from being used as a value:

=[column_name]<>"test"

In this example, you replace column_name with the name of the actual column you are validating, as shown in Figure 1.

Image

FIGURE 1 Setting custom column validation on a text field.

The second option you can set in this section is the message that is displayed to the user when validation fails. For example, you can write The term “Test” is inappropriate for the Title of an announcement. This message is displayed to the user below the column in red text, as shown in Figure 2.

Image

FIGURE 2 The column validation prevents a user from submitting an announcement with the title Test.

You can also enforce validation based on comparison between two columns. 

 
Others
 
- Sharepoint 2013 : Add a Site Column to a List or Document Library
- BizTalk Server 2010 : Testing BizTalk application — BAPI walkthrough
- BizTalk Server 2010 : Building a BizTalk application — BAPI walkthrough
- BizTalk Server 2010 : Testing BizTalk application — RFC walkthrough
- BizTalk Server 2010 : Building a BizTalk application — RFC walkthrough
- SQL Server 2008 R2 : Understanding Index Structures (part 2) - Nonclustered Indexes
- SQL Server 2008 R2 : Understanding Index Structures (part 1) - Clustered Indexes
- SQL Server 2008 R2 : Understanding Table Structures
- SQL Server 2008 R2 : Data Compression (part 3) - Implementing Page Compression, Evaluating Page Compression, Managing Data Compression with SSMS
- SQL Server 2008 R2 : Data Compression (part 2) - Page-Level Compression, The CI Record
 
Video tutorials
- How To Install Windows 8

- How To Install Windows Server 2012

- How To Install Windows Server 2012 On VirtualBox

- How To Disable Windows 8 Metro UI

- How To Change Account Picture In Windows 8

- How To Unlock Administrator Account in Windows 8

- How To Restart, Log Off And Shutdown Windows 8

- How To Login To Skype Using A Microsoft Account

- How To Enable Aero Glass Effect In Windows 8

- How To Install Windows Store Apps From Windows 8 Classic Desktop

- How To Disable Windows Update in Windows 8

- How To Disable Windows 8 Metro UI

- How To Add Widgets To Windows 8 Lock Screen

- How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010
programming4us programming4us
 
REVIEW
 
- First look: Apple Watch

- 10 Amazing Tools You Should Be Using with Dropbox

- Sigma 24mm f/1.4 DG HSM Art

- Canon EF11-24mm f/4L USM

- Creative Sound Blaster Roar 2

- Alienware 17 - Dell's Alienware laptops

- Smartwatch : Wellograph

- Xiaomi Redmi 2
 
Popular tags
 
Video Tutorail Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Biztalk Exchange Server Microsoft LynC Server Microsoft Dynamic Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 Adobe Indesign Adobe Flash Professional Dreamweaver Adobe Illustrator Adobe After Effects Adobe Photoshop Adobe Fireworks Adobe Flash Catalyst Corel Painter X CorelDRAW X5 CorelDraw 10 QuarkXPress 8 windows Phone 7 windows Phone 8 BlackBerry Android Ipad Iphone iOS
 
Top 10
 
- How To Unlock An Account From Active Directory (Windows Server 2008)
- How To Install A deviantArt Theme In Windows 7
- How To Install Windows Server 2012 On VirtualBox
- How To Fix Skype High CPU And Memory Usage In Windows 8
- Add 270 Additional Cleaning Options To CCleaner With CCEnhancer
- FPPT Provides More Than 2000 Free And Attractive PowerPoint Templates
- Setup Free Media Server To Stream Videos To DLNA Compatible TV, Xbox 360 & PS3 (Play Station 3)
- How To Install Android Market & Google Apps On Kindle Fire
- How To Make Ubuntu Look Like Windows 7
- How To Add A New Account in MS Outlook 2013