Default value, description and format

Double-click an existing Field or press the edit button to assign a default value, a description or a format to a Field.

Description

A description for the field can be set.

Default value

The default value will be used if the Field is used in a Text Block and no other value has been assigned to it yet. Default values of Fields are not shown for Fields used in model documents, Forms, or Content Wizards.

Format

The selected format determines how the content of the Field is presented (formatted) when that Field is used in a Text Block. The selected format will not be applied to Fields used in model documents, Forms, or Content Wizards, but only to Fields used in Text Blocks.

The following formats can be selected:

none

No formatting will be applied to the content of the Field. The content is presented as is.

date

The content of the Field is presented as a date. The day and the year will be presented by numbers and the month by its name. The Field should contain a numerical date value in the ITP date format, e.g. 20110621. The actual result depends on the output language. Example results: English US: June 21 2011, English UK: 21 June 2011, Dutch: 21 juni 2011.

amount

This format rounds a number in the content of the Field to two decimals and puts in thousand-separators when appropriate. Use this format if the numerical content of the Field should be represented as money amounts. Note that no currency signs or other additions will be added. The Field should contain a numerical value, e.g. 1234.56. Example result: 1,234.56

numerals
without format

The numerical content of the Field is rounded off to zero decimal positions. No thousand-separators are added. The Field should contain a numerical value, e.g. 1234.56. Example result: 1234

uppercase

This format will represent the whole text content of the Field as uppercase characters. Example result: NEW YORK.

lowercase

This format will represent the whole text content of the Field as lowercase characters Example result: new york.

The result of the applied format is language dependent. This applies for instance to the thousand-separators and the date representation.

Note

The formats that expect the field content to be a number (amount, numerals without format, and date) will only output the content up to the first non-numerical character. This means for instance that if the field contains the text '12.99 euro', the result after applying the amount format will be '12.99' only.

The format you select here is linked to build-in functions of the ITP Model language. To learn more of these function refer to the ITP Model language Help. These linked functions cannot be overridden by user defined functions.

Format

Corresponding ITP Model language function

date

date

amount

amount

numerals
without format

numerals

uppercase

uppercase_of_characters

lowercase

lowercase_of_characters

Note

Selecting a format does not change the content of a Field. It only determines how the content of a field is presented when that field is used in a text block. This means that the selected format does not affect e.g. conditions used Forms or Content Wizards.

Combine Default value and Format

If both a default value and a format are specified on a field and the default is used in the Text Block, then the Format is applied to the specified default. This means that the default value should be specified unformatted. In other words, the default value should be correct input for the applied format. For instance, the default for a Field that represents a date and therefore has the Date format set, should be specified in the ITP date format YYYYMMDD, e.g. 20110621. When that default is then presented in a Text Block, it will be shown as e.g. June 21 2011.