Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

Applies To Version(s): 3, 3.5 & 3.7

There are 12 possible custom column types. Selecting a column type reveals new column settings.


Default Value of Columns 

This setting is used for all column types. It sets the default value for the column. For example, a choice column may have a default value of No. This value will automatically be applied to the column unless modified by the user filling in the form.


Column Types


Single Line of Text

Expand
titleClick to expand

Image Modified

Multiple Lines of Text

Expand
titleClick to expand

Image Modified

Choice (Menu to Choose From)

Expand
titleClick to expand

Image Modified

Number (1, 1.0, 100)

Expand
titleClick to expand

Image Modified

Currency ($, ¥, €)

Expand
titleClick to expand

Image Modified

Date and Time

Expand
titleClick to expand

Image Modified

Lookup (Information Already on this Site)

Expand
titleClick to expand

Image Modified

Yes/No (Check Box)

Expand
titleClick to expand

Image Modified

Person or Group

Expand
titleClick to expand

The Person or Group column is a special type of lookup column that retrieves information only from lists of people or lists of security groups.

Image Modified

Show field asks you to specify which field in the source list the information should be retrieved from.

Image Modified

Hyperlink or Picture

Expand
titleClick to expand

Image Modified

Pictures are now added using the ArtfulBits Image Upload column.

Calculated (Calculation Based on Other Columns)

Expand
titleClick to expand

Image Modified

Calculated fields can be based on a mathematical  formula to calculate a numeric value, such as a date; or, they can be text based, applying a technical formula to return a specified result. For example, it might take data from 2 separate columns, like City and Province, and apply formatting to them to create a name, like Vancouver, BC.

ArtfulBits Image Upload

Expand
titleClick to expand

Image Modified

Include this column if you want to add an image to each record. See Display/change/remove photos for Individuals, programs and residences.

Bamboo Linked Selector

Expand
titleClick to expand

Look up to a SharePoint column in another site, like your Board site.

Bamboo Selector

Expand
titleClick to expand

See Bamboo Linked Selector

Filtered Lookup

Expand
titleClick to expand

Lookup to another list and filter its column contents.

Image Modified

Not all lists can be filtered. Reopen the Get information from menu and select another list.  Additional fields appear for lists that can be filtered.

Image Modified

Panel
bgColorWhiteSmoke

Filter by label (Content by label)
showLabelsfalse
showSpacefalse
titleRelated Articles
cqllabel

= "links"

in ("column","types","type")

Page Properties
hiddentrue
Related issues