A choice field provides several predefined options to choose from, and only one option can be selected.
In the SimpleOne interface, choice fields are displayed in two ways:
| Section | ||||
|---|---|---|---|---|
|
Create a choice field
This column database value
https://home.simpleone.ru/record/safe_story/160520607613610616
СОРС:
| Widget Connector | ||
|---|---|---|
|
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:
- by defining a table and its columns as a source
- by creating a set of records for this field in the Choice Options dictionary.
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
...
...
...
...
/ есть другой способ попасть туда → через Related Lists в форме создания колонки типа Choice /
...
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.
...
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.
...
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.
...
...
...
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.
...
...
...
...
...
...
...
...
| N | Enter the text below to apply the radio button style to the choice field:
| |||||||
| Default Value tab | ||||||||
| Default | ||||||||
...
...
...
...
...
| dynamic default | N | Select this checkbox if you need the value to generate dynamically. | ||
| Dynamic default | N | Select the script from the Dynamic Default Values (sys_default_value_dynamic) table, so its execution result will be automatically calculated and entered into this field. This value will be the default value for the column specified. This field appears only when the Use dynamic default checkbox is selected.
|
Sources for choice options
There are three ways to define a set of choices for the drop-down lists:
- by inheriting values from a parent table (if the current table is a child of another one).
- by creating a set of records for this field in the Choice Options (sys_choice) table.
- by defining a source table and its column in the Type Specification tab.
In the second case, you may need to create a different set of choices if the column is inherited and has predefined options. See Column Override to learn more.
In the third case, the available options are taken from a particular column of a source table. In the example below, the choice table Role contains a column Name and some records where Name is not empty. The choice options will be values of the Name column in this table.
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
| Tip |
|---|
A quick way to create several options for the same column is to use Make a copy:
|
| Tip |
|---|
/ можно сразу создать перевод для опций с помощью Insert and Stay, изменяя поля Title, Language, оставляя без изменений поле Value / |
Inheritance
...
...
...
...
...
...
...
...
...
...
...
addQuery
...
task.addQuery('state', '>', '2'); // all states after In Progress
...
...
...
...
...
...
Translated choice option form fields
...
Field
...
Mandatory
...
Description
...
Specify the table to which this choice option is related.
Select the same table for the translated version as for the original one.
...
Specify the column to which this choice option is related.
Select the same column for the translated version as for the original one.
...
- Open the option for which you need to create a translation.
- Enter the translation in the Title field and specify the language in the Language field.
- Click Make a copy. A copy of the current choice option for the specified language will be created and saved.
| Note |
|---|
Note that the Value field has to remain unchanged. |
| Info |
|---|
If some choice options are not localized, the |
Repeat this step for the rest of the options on the list.
...
...
To avoid this, please be careful when adding options to your choice lists.
...