...
If a field is able to be bound the field binding dialog button will be available in the property:
Clicking this button will open the Field Binding Dialog:
Formatting the Bound Field
...
Text - Format used for text. Options here can have the spaces trimmed from leading or trailing spaces. Also allows for text to be right justified and have zero or blanks fill the field.
Number - Used to format numbers. Options here can use Thousands(1000) Separator or show zero balance of the field. And, also allows zero or blank fill for the field. No extra spaces causes an input field to behave as in keyboard shift Y. The number of characters that can be keyed into the field is equal to the length of the field. When no extra spaces option is unchecked, extra characters can be typed for the sign, decimal, and thousands separators.
In the example below you can see the differences between all options. The length of data is 10 and 2 decimals.
...
- Edit Word - Used to format a numeric field with an editing pattern you specify.
In the example above the source data '000000123' would appear as '****123.00' in the output.
...
In the example below the edit mask used in conjunction with the edit word property allows the '/' characters to not be removed when backspace or the delete key are used.
- Currency Symbol - Used to place a character or string representing currency to precede the data. For example '$', '€', or 'Dollars: '.
...
- Units - The units dropdown can preset the value of the field with a suffix from the following list:
Indicator -
Date - This is used to format the value of the field to display as a date.
Time - This format sets the value to display as a time. This can be set for 12 hour or 24 hour display.
Time Stamp - Formats the field with a date and time stamp in the selected format.
Special - These are presets formats designed for different scenarios, such as zip code, social security number, or phone number formats.
Custom - The custom format can be used to specify your own formatting that may not be included in the preset format selections. You can set the selection with custom JavaScript or a custom date/time pattern.
Custom JavaScript Function Example:
Here you can see how to use the custom JavaScript function. This is used to produce custom formatting along with JavaScript code from a separate JavaScript file placed in the userdata/custom/js folder on the IFS.
In this example the function determines if the value is greater than 50 it will append '19' to the front of the year, and '20' if not.
...
Custom Date/Time Pattern Example:
In the example you can see the pattern M - D - Y / g:i A would return the following format.
