Input Masks

Input masks (or Display masks) allow you to fix the format for the data values that are either entered, selected, or generated automatically by the system. Data values that do not conform to the mask will not be accepted.

Input masks can be of the following types:

Numerical

This mask type is used to format numbers of the type: Integer, Decimal and Double. The components of a numerical mask can be of the type:

• "#" - Display the digit only if there is a significant digit in that location of the number
• "0" - Always show the digit entered in this location
• "."- The position of the decimal point in the number.

e.g. A mask of ###.00 would allow an input up to 999.99 and would force the number to be displayed to 2 decimal places

Example Input	Masked Input
2.5	2.50
123.45	123.45
25.345	25.34

Simple

This mask type is best suited for entering strings of limited length, such as phone numbers, post codes, social security numbers, etc. The mask is specified using a sequence of characters. Some characters serve as placeholders for digits or letters, while others are literals used to separate value portions.

Mask	Example Input	Masked Input
(999)000-00-00	9991234567	(999)123-45-67
00/00/00	120312	12/03/12

Date/Time

This mask is of the type Date/Time and can be any of the standard date time formats when chosen from a calendar. Three example input mask options are provided; however, you can define a Date/Time input mask of your own in the box provided.

Examples are:

Mask	Masked Input
dd-mm-yy	21-10-12
dd-mmmm-yyyy	21-October-2012
dd-mm-yyyy hh:mm:ss	21-10-2012 07:34:56

The Date/Time input mask you define here will determine the date format used when dates are exported as CSV.