Choice fields

A choice field provides several predefined options to choose from, and only one option can be selected.

In SimpleOne interface, choice fields are displayed in two ways:

Drop-down list

Radio buttons

Create a choice field

This column database value can contain all kinds of symbols. If the string length is not set, then it is limited to 80 symbols.

To create a choice column, complete the following steps:

Navigate to the System Settings → All Tables.
Open the table for which you need to create a column.
Scroll down to the Related Lists area and click on the Columns tab.
Click New and fill in the fields.
Click Save or Save and Exit to apply changes.

You can also open the form this way:

Navigate to System Settings → All Columns.
Click New and fill in the fields.
Click Save or Save and Exit to apply changes.

Note that in this case, you will need to fill in the Table field manually.

When creating a Choice column, in addition to the mandatory fields, you need to fill in the following fields:

Field	Mandatory	Description
Column Type	Y	Specify the Choice column type.
Mandatory	N	Select this checkbox to make the field mandatory (appropriate for Choice columns with Choice Type = Dropdown with -- None --).
Type Specification tab
Choice Table	N	Reference to a table.
Choice Type	Y	Define whether the option "None" is applicable for the field. Available options: Dropdown with --None-- Dropdown without --None-- (specify a default value) If the Dropdown without --None-- is chosen, the Default Value tab becomes mandatory.
Choice Field	Y	Reference to a particular column of the table specified in the Choice Table field.
Extra Attributes	N	Enter the text below to apply the radio button style to the choice field: choice_decorator=radio
Default Value tab
Default Value	N	The value of a choice option to be populated automatically by default. Check the value of a field in Choice Options dictionary (sys_choice). The field is mandatory if the Choice Type is Dropdown without --None-- (specify a default value).
Use 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) dictionary, 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. The script must be preliminary created in the Dynamic Default Values (sys_default_value_dynamic) dictionary; otherwise, you will be not able to choose it. You can choose only active scripts (the Active attribute is equal to Yes).

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 current table is a child to another one).
by creating a set of records for this field in the Choice Options dictionary (sys_choice).
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 Overriding of choice options set for child table 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.

Create a choice option

Before creating a set of options for a particular table and column, make sure that this column is already created (navigate to System Settings → All Columns).

To create a choice option for a column table, perform the following steps:

Navigate to the choice column, for which you need to create a set of options.
Scroll down to the Related Lists area and navigate to the Choice tab.
Click New, and fill in the fields.
Click Save or Save and Exit to apply changes.

You can also open the form this way:

Navigate to System Settings → Choice Options.
Click New, and fill in the fields.
Click Save or Save and Exit to apply changes.

Note that in this case, you will need to fill in the Table and Column fields manually.

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 choice 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 choice version as for the original one.
Title	Y	Type the translation of the source field there.
Language	Y	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 (options are arranged in the ascending order).

An easier way to quickly create several options for the same column is to use Make a copy:

After saving a choice option, change the Title, Value, Order fields values.
In the hamburger menu , choose Make a copy. A copy of the current choice option record will be created and saved.

You can also use the following way to create a translation for the choice options:

After saving the record, enter the translation in the Title field and specify the language in the Language field.
Then click Make a copy. A copy of the current choice option for the specified language will be created and saved.

Note that the Value field has to remain unchanged.

Overriding of choice options set for child table

Override allows for changing choice options set for the child tables extended from the base table. For example, the parent table has the following options for a choice column State:

New
Rejected
Processed.

An overriding can change the quantity of these options or their values in the child table. For example, the new set for the State field can be the following:

Draft
New
Assigned
Completed
Rejected.

When creating a choice field, 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 for Incoming, Active, and Failed choice options.

As for task states, it makes sense to make values numeric; this can help with selection construction in code.

addQuery

task.addQuery('state', '>', '2'); // all states after In Progress

To create a new option set, perform the following steps:

Navigate to the column for which you want to create a new set.
Scroll down to the Related Lists area and choose the Choice tab.
Click New and fill in the fields.
Fill in the Table field with the name of the table for which you need to configure a new set of options.
Click Save or Save and Exit to apply changes.

You also can find the form this way:

Navigate to the System Settings → Choice Options.
Click New and fill in the fields.
Click Save or Save and Exit to apply changes.

Please note that in this case, you will need to fill in the Task and Column fields manually.

To learn how to change the column attributes, refer to the Column Overriding article.

Choice list translation

You can provide a set of options for a choice field with localization, which will be displayed in the user's locale.

To localize a choice list, please complete the steps below:

Navigate to System Settings → Choice Options.
Click New and fill in the fields.
Make sure the Value fields of an option in both languages are equal.
Click Save or Save and Exit to apply changes.
Repeat steps 2 – 4 for the rest of the options on the list.

An easier way to quickly localize a set of options for the same column is to use Make a copy.

After saving a choice option, insert the translation in the Title field and specify the language in the Language field.
In the hamburger menu , choose Make a copy. A copy of the current choice option for the specified language will be created and saved.