Search This Blog

Wednesday, 10 October 2012

Understanding Default Site Columns in SharePoint 2010

Dear All,

In this post I just explained the default columns available in SharePoint 2010. This might be a simple thing, but should know every SharePoint developers. Hope It helps more for beginners.


Column
Options
Default Value
Single line of text
Additional Column Settings
    Description
    Require Field
    Enforce unique values
    Maximum numbers of characters
    Default value
    Add to all content types
    Add to default view
Column Validation              
    Formula
    User message


Description of the column
Yes/No
Yes/No
1 to 255
Text/Calculated Value
Check box
Check box

Formula Text
Text



No
No
255
Text
Checked
Checked



Multiple lines of text
Additional Column Settings
    Description
    Require Field
    Allow unlimited length
    Number of lines for editing
    Add to all content types
    Add to default view


Description of the column
Yes/No
Yes/No
Number Input Box
Check box
Check box



No
No
6
Checked
Checked
Choice
Additional Column Settings
    Description
    Require Field
    Enforce unique values
    Choice Value

    Display Choices

    Allow ‘Fill-in’ choices
    Default Value
    Add to all content types
    Add to default view
Column Validation              
    Formula
    User message


Description of the column
Yes/No
Yes/No
Text Input Box
Drop-Down/Radio Button/Checkboxes

Yes/No
Choice/Calculated Value
Check box
Check box

Formula Text
Text



No
No
Type choice on a separate line
Drop-Down (Checkboxes allows multiple selections)
No
Choice(First choice value)
Checked
Checked

Number
Additional Column Settings
    Description
    Require Field
    Enforce unique values
    Min and Max Value
    Number of decimal places
    Default value
    Show as Percentage (%)
    Add to all content types
    Add to default view
Column Validation              
    Formula
    User message


Description of the column
Yes/No
Yes/No
2 Number Input Box
Automatic, 0 - 5
Text/Calculated Value
Check box
Check box
Check box

Formula Text
Text



No
No

Automatic
Text
Unchecked
Checked
Checked



Currency
Additional Column Settings
    Description
    Require Field
    Enforce unique values
    Min and Max Value
    Number of decimal places
    Default value
    Currency Format
    Add to all content types
    Add to default view
Column Validation              
    Formula
    User message


Description of the column
Yes/No
Yes/No
2 Number Input Box
Automatic, 0 - 5
Text/Calculated Value
Drop-Down
Check box
Check box

Formula Text
Text



No
No

Automatic
Text
United States
Checked
Checked



Date and Time
Additional Column Settings
    Description
    Require Field
    Enforce unique values
    Date and Time Format
    Default value

    Add to all content types
    Add to default view
Column Validation              
    Formula
    User message


Description of the column
Yes/No
Yes/No
Date only/Date & Time
None/Today’s Date/Date Input Box/Calculated Value
Check box
Check box

Formula Text
Text



No
No
Date Only
None

Checked
Checked



Lookup
Additional Column Settings
    Description
    Require Field
    Enforce unique values
    Get information from
    In this column

    Add to all content types
    Add to default view
Relationship                          
    Enforce relationship behavior


Description of the column
Yes/No
Yes/No
Drop-Down
Drop-Down and Check box

Check box
Check box

Check box
Restrict delete/Cascade delete



No
No
Shows the available Lists
Shows the available columns
Checked
Checked

Unchecked
Restrict delete
Yes/No
Additional Column Settings
    Description
    Default Value
    Add to all content types
    Add to default view


Description of the column
Drop-Down(Yes, No)
Check box
Check box



Yes
Checked
Checked
Person or Group
Additional Column Settings
    Description
    Require Field
    Enforce unique values
    Allow multiple selections
    Allow selection of

    Choose from
    Show field
    Add to all content types
    Add to default view


Description of the column
Yes/No
Yes/No
Yes/No
People only/People & Groups
All Users/SharePoint Group
Drop-Down
Check box
Check box



No
No
No
People only

All Users
Name (with presence)
Checked
Checked
Hyperlink or Picture
Additional Column Settings
    Description
    Require Field
    Format URL as
    Add to all content types
    Add to default view


Description of the column
Yes/No
Drop-Down(Hyperlink, Pic)
Check box
Check box



No
Hyperlink
Checked
Checked
Calculated (calculation based on other columns)
Additional Column Settings
    Description
    Formula
    Return Data type

    Add to all content types
    Add to default view



Description of the column
Formula Input Box
SLT, No, Currency, Date & Time, Yes/No
Check box
Check box




Shows the available columns
SLT

Checked
Checked
External Data
Additional Column Settings
    Description
    Required field
    External Content Type
    Select fields

    Add to all content types
    Add to default view


Description of the column
Yes/No
External Content Type box
Drop-Down

Check box
Check box



No
Look up buttons available
Shows fields from the external content type
Checked
Checked
Managed Metadata
Additional Column Settings
    Description
    Required field
    Enforce unique
    Add to all content types
    Add to default view
Multiple value field
    Allow multiple values
Display format
    Display Value
Term Set Settings
    Use a managed term set
    Customize your term set

Allow Fill-in
    Allow ‘Fill-in’ choices
Default Value
    Default Value


Description of the column
Yes/ No
Yes/No
Check box
Check box

Check box

Term label/Entire path

Input box/ Site Metadata
Input box/ Custom Metadata

Yes/No

Metadata Input box



No
No
Checked
Checked

Unchecked

Term label





Yes




Thanks

No comments:

Post a Comment