Formatting Tab

Some Controls support Formatting; this means you can specify valid data formats for the Field, and when editing the value of the Field has been completed this format will be imposed on the value. Formatting is frequently mixed with Validation to ensure that data has been recorded in a valid state, although unlike Validation it has no additional requirement for another Field to trigger its action.

There are six kinds of formatting available in Scripting:

Formatting Type	Description
Alpha Only	Removes any non-alphabet characters.
Lower Case	Makes all characters lower case
Monetary Value	Takes the number value of the Field, and formats it with exactly two decimal places. Non-numeric characters other than a decimal (.) will return NaN.
Number Only	Removes any non-number characters from the field. Addition, subtraction, and decimal (+, -, .) characters are also removed.
Proper Case	Capitalises the first letter of every word, makes every other character lower case.
Title Case	Capitalises the first letter of a sentence, leaves every other character unchanged.
Upper Case	Makes all characters upper case.

Additional Formatting types can be added on request, please contact Professional Services with your requirements.