Plain Data
Text data type stores and displays a sequence of characters (a string), which may include letters, numbers, diacritics (accent marks) and other special characters. By default, text is displayed “as-is” with no formatting applied.
Data type Integer displays data in numerical format. Intgers are typically used to represent numbers and can be positive, negative or zero in the limits of +- 231
The Decimal data type stores numeric data with decimal fractions, e.g. 3.142 or 124.75. Values can be positive, negative or zero. Math operations may include rounding differences. The character used to represent the decimal point depends on the web browser’s local settings.
Currency contains monetary amounts, in the currency format defined by default in Portal Settings. Note: changing the DotNetNuke portal currency will change the display format, but it will not recalculate the entered values!
Date and Time stores both the date and the time specified. You can select the date from the popup calendar. Date and Time are formatted based on the specified settings of the current locale.
Date stores the date specified. You can select the date from the popup calendar. Date is formatted based on the specified settings of the current locale.
Time stores the time of day specified. You can select the date from the popup calendar. Time is formatted based on the specified settings of thecurrent locale.
With True/False, the user is presented with a check box, which can be selected (enabled) or unselected (disabled). This allows for “yes or no”, “on or off” choices. An unchecked or disabled value equals “no or off”; there are no null values.
Stores and displays formated HTML text, presenting the user with a Rich Text editor.
Stores data in the format of an Email address. Data of this Type will by default be displayed as a clickable link. If the user has entered a valid “mailto:” address such as info@dotnetnuke.com, clicking the link opens the default Email client.
Note that email addresses are not returned literally but instead the address is cloaked to protect against spam spiders. Also, you cannot use this format to launch to an IM (instant messaging) client.
To store a website address for a page that is either in or outside of your portal, use URL. This data type will display to the user the DotNetNuke URL control. The user selects the appropriate link type (URL, Page or File) and depending on the link type, has the option to either enter data or select it from a list.
Use the Image type to display an image in this column, a unique image for each record. The user will be prompted to provide a link to an external URL, or select an image stored in a non-secure folder of the portal where the user has access. The user will be presented with non-secure folder access regardless of the user’s permissions.
To present files for download, choose the Download data type. Download supports external and internal links to unsecured and secured file system areas as well as access to files and folders that are securely stored in the DotNetNuke database.
Enter a username to create a link to user's profile page.
To display the results of a calculated expression consisting of constants, functions, other UDT column values and mathematical operators, use the Calculated Column data type. Calculated Column expression examples are found in Chapter 5 section: “Expression”. Some expressions are made possible by the use of Hidden Columns, described below.
This data type doesn't store any data, instead it looks up additional properties from other fields which points either to files (Download, URL, Image) or users (Link to User's Profile, Created by, Changed by).
See also this example page
This internal column holds the user name if the user who created this record.
This internal column holds the user name if the user who changed this record at last.
This internal column holds date and time of record creation
This internal colum holds date and time of the last update of this record.
This column holds the Id of the current record. By default it is not visible.