Nick Grattan’s SharePoint Blog

About Microsoft SharePoint and some .NET

Metadata, Default Values and Required Columns

with one comment

To improve the quality of metadata associated with documents it is advisable to make columns required:

req1.PNG

When applied to “Choice” types, the first choice from the list is automatically selected. Thus the user is not forced to make a choice, and the likelyhood is that the correct value will not be selected.

To circumvent this problem you can set a calculated default value that sets an empty string as the default value. This is an equal sign followed by two double quotes:

req2.PNG

Now, when a new item using this field is presented to the user a blank item is selected. If the item is added without supplying a value an error is presented:

req3.PNG

Written by Nick Grattan

September 22, 2009 at 9:20 am

One Response

Subscribe to comments with RSS.

  1. [...] Metadata, Default Values and Required Columns [...]


Leave a Reply