Format Type
You can select any of the following format types.
| Select | To |
|---|---|
| Number | Format a field as a decimal number. |
| Integer | Format a field as a whole number only; rounds up or down as necessary. |
| Date/Time | Format a date/time. |
| Percentage | Format a field as a percentage. Can only be used on floating or double precision fields. |
| Currency | Format a field as dollar value. |
| User Name | Convert a field that contains a USERID into a user name. |
| Phone Number | Format the value of a field into a standard phone number format. |
| Owner | Converts SECCODE into the name of the user or team who owns the record. |
| Boolean | Translates 0, 1, T, and F to True/False. |
| Positive Integer | Format a field as a positive whole number only. |
| PickList Item | Format a field as an item for an Infor CRM pick list. |
| Time Zone | Format a field as a Time Zone. |
