Learn SharePoint In Series - Part Eight - Validation Settings In List Settings

Here, what we want is that the item should not be saved if the Obtained Marks are greater than the Total Marks. Then the formula will be like.

=[Obtained Marks]<[Total Marks] 

Enter the text message that should be displayed if the validation fires and click on Save. Now open the list new item form. Try to enter value 25 into Obtained Marks and 50 into Total Marks and submit the form.

It will save the record into the list as validation checks if the data are correct. Now, again, try with entering 50 into Obtained Marks and 25 into Total Marks and then try to submit the form. You will get the error message that you have specified in the Validation Settings.

So validation settings work in the explained manner.

Benefits of configuring the list level validation settings

As I said, the validation can be specified at list level and field level. Every approach has its own benefits and limitations. If you want to display the field-wise validation message then you can write the field-level validation code. But if you want to generalize the validation message and you want to manage every validation in one place then, in that case, you can use List Level Validation Settings.

The major benefits of configuring validations at the list level are, that we have to write every formula in one box and one general validation message is enough. This validation check is executed when we submit the form.

Available functions and statements in the validation formula

We already know some of the programming statements such as IF, Else, and functions like Date Functions, etc. The validation Formula also has its own set of Statements and Functions. The complete list of formulas and functions is available here Examples of common formulas in SharePoint Lists

Also, there is a well-written and great post on the same topic already available in CSharpCorner here Validation Settings In SharePoint 2013

Available are different kinds of formulas

Conditional formulas

In conditional formulas, we can make use of IF, AND, OR, NOT, ISERROR, and ISBLANK formulas available. For example, let’s demonstrate the use of the IF statement in SharePoint List Validation and traditional c#.

IF works the same as the If statement in C#, the only difference is with syntax. In C#, we write IF as

if (Condition) {
    // Condition is true
    Execute Success part
} else {
    // Condition is false
    Execute Failure part
}

If we write the above same situation in List Validations settings, it would be written as

=IF(Condition,”Success Part”,”Failure Part”)  

Summary

So in this article, we have seen how list validation settings work, although it's the basic information about how we can configure the list validations with a straightforward example. Utilizing list validation settings we can also configure business-level validations using some complex level formulas.

In the next article, I will be talking about audience targeting settings available in List. If you have any suggestions or questions please feel free to post a comment.