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
| 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 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
- by defining a source table and its columns 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. To do this, please use the Column Override in the Related Lists area.
In the third case, the available options are taken from a particular column of a source table, as represented below:
Create a choice column
...
...
- Navigate to System Definition → All Columns.
- Click New, and fill in the fields.
- Click Save or Save and Exit to apply changes.
...
You also can find the form this way:
- Navigate to the System Definition → All Tables.
- Open the table you want to create a column for.
- 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.
...
...
...
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 a 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 | ||||||||
...
...
...
...
...
...
...
...
...
...
|
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.
Create a choice option
| Note |
|---|
Before creating a set of options for a particular table and column, |
...
...
...
...
...
...
...
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.
...
...
...
...
...
...
...
...
...
...
Defining an override for choice fields
Override allows to override column value and attributes in the child tables extended from the base table. For example, the parent table has the following options for a choice column State: Registered, Rejected, Processed. A column override changes these values to Draft, New, Assigned, Completed in the child table.
To create an override, please perform the following steps:
- Navigate to the column you want to create an override for.
- Scroll down to the Related Lists area and choose the Choice tab.
- Click New and fill in the fields.
- Fill in the field Table with the name of the table you need to make an override for.
- Click Save or Save and Exit to apply changes.
| Info |
|---|
You also can find the form this way:
Please note that in this case, you will need to fill in the Task and Column fields manually. |
If changing of the column attributes is needed, please perform the following steps:
- Navigate to the column you want to create an override for.
- Scroll down to the Related Lists area and choose the Column Override tab.
- Click New and fill in the fields.
- Click Save or Save and Exit to apply changes.
Column Override form fields
...
In this dictionary field, you can select the uppermost (in terms of inheritance) table containing the field to override.
...
Default Value Override
...
Select this checkbox to display the Default Value field, which overrides the default value for the field on the extended table.
After selecting this checkbox, the Default Value field appears. Enter the default value that will override the original one.
...
Select the checkbox to display the Reference Qualifiers fieldset, which overrides the reference qualifier for the field on the extended table.
- Reference - in this field, select a table to which the overriding column is referenced to.
- Reference Qualifier Type - choose your reference qualifier type, is it Simple or Dynamic.
- Reference Qualifier Condition - build a reference filter that will fit the necessary conditions.
- Dynamic Reference Qualifier - if you have chosen the Dynamic type from the choice menu above, then select the appropriate one from the dictionary.
...
Select this checkbox to display the Read Only field, which overrides whether a user can change the field value on the extended table.
...
Select this checkbox to display the Dependent on Column field, which overrides the field on which the current field depends.
| list. Options are arranged in ascending order. |
| Tip |
|---|
A quick way to create several options for the same column is to use Make a copy:
|
When creating a choice field option, 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, respectively.
As for task states, it makes sense to make values numeric; this can help with selection construction in code.
Choice list translation
To create a translation for the choice options, complete the following steps:
- Navigate to System Settings → Choice Options.
- 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 |
Choice list translation
To localize a choice list, please complete the steps below:
- Navigate to System Definition → Choice Options.
- Click New and fill in the field.
- Make sure the Value fields of an option in both languages are equal.
- Click Save or Save and Exit to apply changes.
| Tip |
|---|
An easier way to quickly translate 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. Enter the translation in the Title field and specify the two-symbol name of the language in the Language field. Please note that the Value field has to remain unchanged. |
Translation 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.
...
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.
...