Microsoft Office Tutorials and References
In Depth Information
External data fields and external lists are both covered in Chapter 16, “Advanced Installation
and Configuration,” along with more details about managing the Business Data Connectivity
service. This new feature of SharePoint Foundation deserves to be the focus of an entire
section of a chapter.
All fields in a list can be configured to require data. When a user is adding a new item record
to the list, they won’t be able to finish it until there is a value in each required field.
Most data fields can also have a default value and/or a calculated default value. The
calculated value in that case must be a simple calculation (no field references, just variables,
functions, formulas, or simple math). Using a calculation value for a field is nice because the field
can have a simple calculation in it (like a default expires date for example), or you can override
that value by typing something into the field manually. Calculated fields don’t have that option.
They only do calculations based on the content of other fields or the value of a variable at the
time the item record was created and are not available for the users to change.
In addition, all fields have a setting that adds them to the default view. If you don’t want
a field to be added to the current default view of the list, remove the check from the Add To
Default View box when you are creating the field. This is simply a convenience. As you’ve
already learned, you can add or remove fields from a view at any time.
Adding a Field to a List
Now that you are familiar with all the settings in the Create Column page (via the Create Column
button in the List ribbon), let’s add a Category field to the Announcements list. This field should
require the person entering the data for a new announcement to choose a category for it.
1. In the Name And Type section (Figure 6.13), enter the name of the field. My example uses
The Name And