Leveraging Validation Settings

Another means of ensuring that the correct data is entered into columns in a list and library is through the use of validation settings, which can be added to the list or library on the List Settings or Library Settings page, or to an individual column. The equations that can be used are more limited, as the result of the equation must equal the value True or the user won’t be able to save the entry.

A simple example is

=[ColumnA]>[ColumB]

Assuming the value in ColumnA is greater than ColumnB, the formula generates the value True and therefore passes the validation test.

Building on the list created in the previous section, follow these steps to add validation to the CalculatedColumnTest list:

  1. Navigate to the CalculatedColumnTest ...

Get Microsoft SharePoint 2010 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.