GUI Localization

GUI Localization is maintained in System Setup > Users & Groups > Users on the System Settings tab.

In the workbench when viewing and maintaining Numbers and Dates, by default, they will be maintained and viewed using the English - en/en locale. A number like 1,234.56 will appear with a dot to indicate the decimal. When editing and saving numbers and dates in the database, only an English - en/en locale is used.

In the System Settings tab, the User editor includes an option to select a specific locale for a user. This locale changes the workbench behavior to match the selected locale for the user. This option is helpful for users working in outside the United States and allows them to view and maintain workbench values with a different locale than English - en/en.

Important: A locale applied by a user only changes the view of numbers and dates according to the locale in the workbench and it changes dialogs to allow saving numbers and dates based on the locale. A number can be saved, e.g., with a comma as a decimal separator using a German - de/de locale. Behind the scenes it remains the English - en/en locale that is used to save numbers and dates into the database.

For example, 'buyer2' is using German - de/de locale:

In this example 'buyer2' is logged on the workbench. The user is set up to use a German - DE locale for numbers and dates. A comma displays in single and multi valued attributes and LOVs. 'buyer2' can only use a comma as a decimal separator for numbers. When 'buyer2' saves a number into the database, the English - en/en locale will be used to save the number. So if 'buyer2' enters a number: 123,45 into a value field, the value is saved in the database as 123.45.

For example, 'buyer1' is using English - en/en locale:

In this example 'buyer1' is logged on the workbench. The user is setup to use a English - en/en locale for numbers. A dot appears in single and multi valued attributes and LOVs. 'buyer1' will only be allowed to use a dot as a decimal separator for numbers.

Setting up a GUI Localization for a User

GUI Localization is maintained in System Setup: Users & Groups > Users in the System Settings tab.

  1. In Locale for values, click field to open a locale selector dialog. In this example a German - de/de locale is selected for 'buyer2' .

  1. Click OK to apply the German - de/de locale.

Note: Users without any locale applied will as default use the English - en/en locale to enter values or viewing values in the workbench editors.

  1. In Localize numbers using thousand delimiter, select 'Y' to localize numbers using a thousand delimiter. In this example a German - de/de locale is selected for 'buyer2', which will enable a dot to be shown as a thousand delimiter for Number and Integer validated values. For 'buyer2', values like 1000 or 1000.10 will be shown as 1.000 and 1.000,10.

Note: The thousand delimiter is only a display setting for values shown in the workbench. Saving numbers and integers will not be saved in the database with a dot as a thousand delimiter.

  1. In Localize dates, select 'Y' to localize dates in the workbench. In this example a German - de/de locale is selected for 'buyer2'. For 'buyer2', isodates will be shown as 13.05.2009 and 'ISO Date and Time' will be shown as 13.05.2009 19:10:48 according to the ISO 8601 (pre-2019) format.