Article: AN0001611Updated:
This type is used for storing date and time.
Properties
| Name |
Description |
| Format of display |
It defines format of a value display. E.g. {0:N2} display an number with two decimal digits. |
| Display summary in the list |
It defines, wheather there shall be a sum row beĺow the list of records. |
| Display format of the Sum row |
It defines format of value display in the summary row. |
| Link format |
Link format (see hereinafter). |
| Format of display |
It defines format of display (Date and time, Date and time incl. seconds, Date, Time, Time incl. seconds, Day and month). |
| Default value |
The default value of the column filled in when creating a new record. |
| Minimal value |
The minimal value that can be stored in the column. |
| Maximal value |
The maximal value that can be stored in the column. |
| Use as a reference |
It defines wheather the value of attribute shall be interpreted as html link. |
| Link format |
It enables to define the way of link composition from the column value. |
| Name of window for the link |
The link is opened to the same window by default, in which current page is displayed. When filling in this value, the link will be opened into another window. |
| Enable opening the link in a list |
After setting text in the list of records will work as a link. |
Link format
It determines, wheather values in the column will be interpreted as a whole link and its part only.
Example:
'{#}' - value from the column represents the whole link
'http://www.company.com/index.aspx?text={#}' - value from the column represents part of the link only
Text {#} is replaced by the value from the column.
Value in the column is an expression. Therefore, functions like e.g. Column can be used and also values from other columns can be inserted in the link. This behaviour is suitable especially in queries, where you can create URL for navigation to another page.
Name of window for the link
You can use whatever text or standard names (HTML definition) as a name:
| Name |
Description |
| _blank |
new window or a new tab |
| _top |
highest frame window |
| _parent |
superior frame |
| _self |
same frame |
Format for time selection and alignment
In certain scenarios it is not appropriate for user selecting the whole value for date and time. E.g. we may want the user to select date but not time for DATE FROM since we want the time to set to 00:00:00. For DATE TO we may want to select just date but set time to 23:59:59.
In these case we utilize Selection format, that defines what the user can select and setting Time alignment, that determines how to set the part that the user is not selecting.