-
Notifications
You must be signed in to change notification settings - Fork 20
Hidden Columns
In addition to column Types available from the Type dropdown list, depending on the column type you define, addditional hidden columns are created. Thes hidden columns allor for data formatting, conditional testing, localization and XSL rendering.
Shown in the following table, columns beginning with "+" are hidden column name you may use in Filter Statements, calculated formulas, XSL style sheets, etc. Subtitute the + with the Title (name) of your user defined column, for example, "myColumnName_UDT_Original" or "myColumnName_UDT_Url".
A hyphen "-" in this table means a hidden column is not available for this column Type.
Link values are either "TabID=n", "FileID=n" or URL.
| Type | ColumnName (Rendered) | +_UDT_Original | +_UDT_Caption | +_UDT_Value | +_UDT_Ticks | +_UDT_Url |
|---|---|---|---|---|---|---|
| Changed at | Date | - | - | Localized Date | DateTime in Ticks | - |
| Changed by | Display Name/ Link to Profile | User Name | Display Name | - | - | Profile URL |
| Created at | Date | - | - | Localized Date | DateTime in Ticks | - |
| Created by | Display Name/ Link to Profile | User Name | Display Name | - | - | Profile URL |
| Calculated Column | Result of Expression | - | - | - | - | - |
| Currency | Value | - | - | - | - | - |
| Date | Date | - | - | Localized Date | DateTime in Ticks | - |
| Date and Time | DateTime | - | - | Localized Date | DateTime in Ticks | - |
| Decimal | Value | - | - | - | - | - |
| Download | HTML Link | FileID= | Filename | - | - | File URL |
| HTML Link | Value | Caption | - | - | - | |
| Image | HTML Image | FileID= | Caption (Alt) | - | - | Image URL |
| Integer | Value | - | - | - | - | - |
| Link to User Profile | Link to Profile | Value | Display Name | - | - | Profile URL |
| Look-Up | Result of Look Up | - | - | - | - | - |
| Rich Text/HTML | Value | - | - | - | - | - |
| Separator | - | - | - | - | - | - |
| Text | Value | - | - | - | - | - |
| Time | Value | - | - | - | DateTime in Ticks | - |
| True/False | Image (un)checked.gif | [true|false] | [true|false] | [1|0] | - | - |
| URL | HTML Link | Value | Caption | - | - | URL |
Example 1:
When a column named “WebSite” of Type URL is added to Form and List, there are three additional hidden columns created:
- WebSite_UDT_Original
- WebSite_UDT_Caption
- WebSite_UDT_Url
Entering www.example.net as “WebSite”, the hidden fields yield these values:
| Column Name | Content |
|---|---|
| WebSite | <a href="http://www.example.net" target="_blank">Web Site</a> |
| WebSite_UDT_Original | www.example.net |
| WebSite_UDT_Caption | Web Site |
| WebSite_UDT_URL | http://www.example.net |
Pointing URL to an internal portal page, WebSite_UDT_Original may be “32” (TabID), and WebSite_UDT_URL would be /home.aspx, for example.
Example 2:
When a column named “Available” of Type True/False is added to Form and List, there is also a hidden columns created with the following names:
- Available_UDT_Original
- Available_UDT_Caption
- Available_UDT_Value
Testing on Available_UDT_Original is useful for filtering purposes. For example, you can set a Filter Statement such as: [Available_UDT_Original] = ‘true’ to display only records where the ‘Available’ column is enabled.
Example 3:
By default, the built-in column named “Created by” will render the user’s Display Name. However, if you reference the hidden column:
- [Created by_UDT_Caption]
… will display the user’s Username.