-
Notifications
You must be signed in to change notification settings - Fork 20
Data Types
There are multiple data types available for defining the columns of your Form and List,each with distinguishing characteristics. These provide you with a wide range of inputand display controls that will enhance the presentation of your data. To gain the mostvalue from the Form and List, carefully select the appropriate data type for each column.
Text
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.
Integer
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
Decimal
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
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
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
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
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.
True/False
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.
Rich Text (HTML)
Stores and displays formated HTML text, presenting the user with a Rich Text editor.
Email
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 [email protected], 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.
URL
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.
Image
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.
Download
To present files for download, choose the Download data type. Download supports external and internal litemnks to unsecured and secured file system areas as well as access to files and folders that are securely stored in the DotNetNuke database.
Link to User's Profile
Enter a username to create a link to user's profile page.
Calculated Column
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.
Look Up
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 Available Token Help
Created by
This internal column holds the user name if the user who created this record.
Changed by
This internal column holds the user name if the user who changed this record at last.
Created at
This internal column holds date and time of record creation
Changed at
This internal colum holds date and time of the last update of this record.
UserDefinedRowID
This column holds the Id of the current record. By default it is not visible.