Choice is .... It is used for... In SimpleOne interface, it is displayed as a drop-down list.
There are two ways to define a set of choices for the drop-down lists:
In the first case, the choice field inherits the values from a parent table. To create a different set of choices, you need to make another set using the Choice Options dictionary.
Create a choice column
This field can contain all kinds of symbols. If the string length is not set then it is limited to 80 symbols.
/ есть другой способ попасть туда → через Related Lists в форме создания колонки типа Choice /
| Field | Mandatory | Description |
|---|---|---|
| Table | Y | Specify the table name that will be a parent for this column. This mandatory field is a reference to the Tables dictionary (sys_db_table). |
| Column Type | Y | Specify a column type. The column type specifies the type of the data stored, also, depending on the type selected, additional tabs or fields may appear on the form (see below). For more information, see the Field Types article. |
| Title | Y | A column title displayed on the form. It is preferred to be sensible and human-readable. This field is mandatory. Latin, Cyrillic, [0..9] numbers, and the underscore symbol ( _ ) are allowed. |
| Column Name | Y | A system column name. It is preferred to be human-readable and keep the kind of stored data. Latin letters, [0..9] numbers, and the underscore symbol ( _ ) are allowed. |
| Active | N | Select this checkbox, and customizing of this field displayed on the form and list will be possible. If unselected, then such field will be not available for choosing in Form Layout or List layout. |
| Read Only | N | Select this checkbox to make the field read-only. |
| Mandatory | N | Select this checkbox to make the field mandatory. |
| Full Text Search | N | Set this attribute equal to TRUE to make it possible to perform a Global Search against the current column. |
| Display by Ref | N | When a record references to another record and the table or column containing this record has the attribute Display by Ref equal to TRUE, then the column value will be displayed. By default, this attribute is set equal to TRUE for the sys_id column (this column contains unique IDs). If a table contains a field that has Display by Ref = TRUE, the value of this field will be displayed when referencing this table in the Reference field of the referencing table. |
| Unique | N | When turned on, no way to add a record with a value of this field, if a record with the same value already exists. |
| Comments | N | Write a comment with the additional information to a problem. |
| Type Specification tab | ||
| Choice Table | N | Reference to a table. |
| Choice Type | Y | Available options:
If the Dropdown without --None-- is chosen, the Dafault value tab becomes mandatory. |
| Choice Field | Y | Reference to the specified field of the table. Its values will be available for the Choice field. |
| Default Value tab | ||
| Default Value | N | The field is not mandatory if the Choice Type is Dropdown with --None--. |
| Use Dynamic Default | N | Check this box for the Dynamic Default field to appear. |
| Dynamic Default | N | |
Before creating a set of options for a particular table and column, please make sure that this column is already created (navigate to System Definition → All Columns). |
To create a choice option for a column table, please perform the following steps:
An easier way to quickly create a set of options for the same column is to use Insert and Stay. In the burger menu, choose Insert and Stay. A copy of the current choice option record will be created. Change the Title, Value, and Order fields. |
Choice option form fields
| Field | Mandatory | Description |
|---|---|---|
| Table | Y | Specify the table to which this choice option is related. Select the same table for the translated version as for the original one. |
| Column | Y | Specify the column to which this choice option is related. Select the same column for the translated version as for the original one. |
| Title | Y | Type the translation of the source field there. |
| Language | Y | In there, specify the two-symbol name of the language (ru, en, and so on). Generally, references to languages are stored in the Languages (sys_language) table. |
| Value | Y | Type the same value as specified for the source field. |
| Order | Y | Enter the number to define the option order in the choice list. |
| Hint | N | Text hint. This field is not mandatory. |
/ можно сразу создать перевод для опций с помощью Insert and Stay, изменяя поля Title, Language, оставляя без изменений поле Value / |
Inheritance
When creating a choice-like field (for example, Choice), it is recommended to set text values in the Value field to increase code readability. For example, it can be Incoming, or Active, or Failed values.
Regarding task states, it makes sense to make values numerical; this can help with selection construction (see the code sample below).
addQuery
|
To localize a choice list, please complete the steps below:
Translated choice option form fields
Field | Mandatory | Description |
|---|---|---|
| Table | Y | Specify the table to which this choice option is related. Select the same table for the translated version as for the original one. |
| Column | Y | Specify the column to which this choice option is related. Select the same column for the translated version as for the original one. |
| Title | Y | Type the translation of the source field there. |
| Language | Y | In there, specify the two-symbol name of the language (ru, en, and so on). Generally, references to languages are stored in the Languages (sys_language) table. |
| Value | Y | Type the same value as specified for the source field. |
| Order | Y | Enter the number to define the option order in the choice list. |
| Hint | N | Text hint. |
Repeat this step for the rest of the options on the list.
If some of the choice options were not localized (for example, some added choice options in English but didn't add their translations), then in user locale other than English, choice lists containing untranslated options will display them in English by default, regardless of the current user locale. To avoid this, please be careful when adding options to your choice lists. |