Validation Settings in SharePoint 2013 and Office 365


Hello Readers.

Welcome to this article on Validation Settings in SharePoint 2013 and Office 365. Validation Settings provide a basic approach for assigning validation to our columns in Document Libraries.

This feature helps us to avoid the use of JavaScript to assign the validation to the columns. It provides a user-friendly approach compared to the users adding in JavaScript code.

Let’s see how to do that.

validation checking

  • Formula

    Here we need to specify a formula for all the validations, like for example if you add a criteria based on the created date like the case should be passed if the created date is greater than 01/01/2015 then that formula needs to be written in the text box below to validate.

    There are plenty of formulas SharePoint provides for validation.

    They can be found here.

    Please Note: The columns shown on the right can only be used when you assign formulas. These columns will do something from the list so the look-up columns or variables can be assigned a formula since they will not be visible here.

copy source

  • User Message

    Here you can write a message depending on the validation of the column such as what do the users require to do when the validation fails, so you can add that message here.

    user message

Isn’t that a better feature rather than searching a developer to validate small requirements?
Keep Learning,
Cheers!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s