October 2010
Intermediate to advanced
1008 pages
46h 16m
English
If this link is clicked, the library administrator will be taken to the Validation Settings page, as shown in Figure 20.16, where she can specify a formula to validate the data when new items are saved to the list or are edited. User message text can be entered as well, so the end user is informed of the criteria that weren’t met successfully. In this example, the formula is as follows:
=ProjectNumber>5000
Figure 20.16. Validation Settings page with sample formula.

This translates to: The value entered in the ProjectNumber column must exceed 5000 to provide a value of True.
If the results of the equation entered do not equal ...
Read now
Unlock full access