Versions Compared

Old Version 9

changes.mady.by.user Anna Kryzhanovskaya

Saved on

compared with

New Version Current

changes.mady.by.user Dina Baksheeva

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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


Column

Drop-down list

Image Added


Column

Radio buttons

Image Added


Create a choice field

This column database value

Choice is .... It is used for... In SimpleOne interface, it is displayed as a drop-down list.

Image Removed

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. See Defining an override for choice fields to learn more.

In the third case, the available options are taken from a particular column of a source table, as represented below:

Image Removed

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.

  1. Navigate to System Definition → All Columns.
  2. Click New, and fill in the fields.
  3. Click Save or Save and Exit to apply changes.
Info

You can also find the form this way:

  1. Navigate to the System Definition → All Tables.
  2. Open the table you want to create a column for.
  3. Scroll down to the Related Lists area and click on the Columns tab.
  4. Click New and fill in the fields.
  5. Click Save or Save and Exit to apply changes.
Please note that in this case, you will

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

 Table field manually.Column form fields

following fields:

FieldMandatoryDescription
TableRead OnlyNSelect this checkbox to make the field read-only.
Column typeY

Specify the

table name that will be a parent for this column. This field is a reference to the Tables dictionary (sys_db_table).Column TypeY

Specify a column type. The column type specifies the type of the data stored. Depending on the type selected, additional tabs or fields may appear on the form. For more information, see the Field Types article.

TitleYA 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 NameY

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.

ActiveN

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.

Choice column type.

MandatoryNSelect this checkbox to make the field mandatory
.Full Text SearchNSet this attribute equal to TRUE to make it possible to perform a Global Search against the current column.Display by RefN

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.

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.

UniqueNWhen turned on, no way to add a record with a value of this field, if a record with the same value already exists.CommentsNWrite a comment with the additional information to a problem.Type Specification tabChoice TableNReference to a table.Choice TypeY
(applicable for Choice columns with Choice type = Dropdown with -- None --).
Type Specification tab
Choice tableNSpecify a table that has a column with choice options.
Choice fieldYSpecify a particular column of the Choice table that contains choice options.
Choice typeY

Define whether the option None is applicable for the field. Available options:

  • Dropdown with --None--
  • Dropdown without --None-- (
must
  • specify a default value)
.

If the Dropdown without --None-- is

chosen

selected, the

Dafault value

Default Value tab becomes mandatory.

Choice Field
Extra attributes
YReference to the specified field of the table. Its values will be available for the Choice field.
N

Enter the text below to apply the radio button style to the choice field:

Code Block
languagejs
themeEclipse
choice_decorator=radio

Image Added

Default Value tab
Default
Value
valueN

The value of a choice option to be populated automatically by default. Check the value of a field

is not

in the Choice options (sys_choice) table.

The field is mandatory if the Choice

Type

type is Dropdown

with

without --None-- (specify a default value).

Use
Dynamic Default
dynamic defaultN
Check this box to display the Dynamic Default field.
Select this checkbox if you need the value to generate dynamically. 
Dynamic defaultN
Dynamic DefaultNThis field appears only when the Use Dynamic Default attribute is set to TRUE.

Select the script from the Dynamic Default Values (sys_default_value_dynamic) 

dictionary

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.

Note
  1. The script must be
preliminary
  1. preliminarily created in the Dynamic Default Values (sys_default_value_dynamic) 
dictionary
  1. table; otherwise, you will be not able to choose it.
  2. You can
choose
  1. select 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 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.

Image Added

Create a choice option

Note

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 → Settings → All Columns).

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

  1. Navigate to the choice column, for which you need to create a set of options.
  2. In the Related Lists area, select the Choice tab to System Definition → Choice Options.
  3. Click New, and  and fill in the fields.
  4. Click Save or Save and Exit to exit to apply the changes.
Info

You can also open the form the following way:

  1. Navigate to System Settings → Choice Options.
  2. Click New and fill in the fields.
  3. Click Save or Save and exit to apply the changes.

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

Tip

An easier way to quickly create a set of options for the same column is to use Insert and Stay:

  1. In the burger menu, choose Insert and Stay. A copy of the current choice option record will be created.
  2. Change the Title, Value, and Order fields.
  3. Click Save or Save and Exit to apply changes.
You can also use this way to create a translation for the choice options. After saving the record, click Insert and Stay, 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.

Choice option form fields

FieldMandatoryDescription
TableY

Specify the table to which this choice option is related.

Select the same table for the translated choice version as for the original one.

ColumnY

Specify the column to which this choice option is related.

Select the same column for the translated choice version as for the original one.

TitleYType the translation title of the source field thereoption. 
LanguageYIn there, specify Specify the two-symbol name of the language (ru, en,  and and so on). Generally, references to languages are stored in the Languages (sys_language) table.
ValueYType Specify the same value as specified for the source fieldof the option.
OrderYEnter the number to define the option order in the choice list.
HintNText hint. This field is not mandatory.

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:

  1. Navigate to the column you want to create an override for.
  2. Scroll down to the Related Lists area and choose the Choice tab.
  3. Click New and fill in the fields.
  4. Fill in the field Table with the name of the table you need to make an override for.
  5. Click Save or Save and Exit to apply changes.
Info

You also can find the form this way:

  1. Navigate to the System Definition → Choice Options.
  2. Click New and fill in the fields.
  3. 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.

If changing of the column attributes is needed, please perform the following steps:

  1. Navigate to the column you want to create an override for.
  2. Scroll down to the Related Lists area and choose the Column Override tab.
  3. Click New and fill in the fields.
  4. Click Save or Save and Exit to apply changes.

Column Override form fields

FieldMandatoryDescriptionBase TableY

In this dictionary field, you can select the uppermost (in terms of inheritance) table containing the field to override.

TableYIn this dictionary field, you can select the child table that will be affected by overriding.ColumnYIn this dictionary field, you can select a column to be overridden.Display by Ref OverrideNSelect this checkbox if you need to override the Display by Ref setting which is responsible for what column will be displayed instead of reference IDs.

Default Value Override

N

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. 

Reference Qualifier OverrideN

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.
Mandatory OverrideNSelect the checkbox to display the Mandatory field, which overrides whether the field on the extended table must contain a value to save a record.Read Only OverrideN

Select this checkbox to display the Read Only field, which overrides whether a user can change the field value on the extended table.

Dependent on Column ID OverrideN

Select this checkbox to display the Dependent on Column field, which overrides the field on which the current field depends.

Choice list translation

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

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

An easier way to quickly localize a set of options for the same column is to use Insert and Stay.

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:

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

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:

  1. Navigate to System Settings → Choice Options.
  2. Open the option for which you need to create a translation.
  3. Enter the translation in the Title field and specify the language in the Language field.
  4. Click Make a copy
In the burger menu, choose Insert and Stay
  1. . A copy of the current choice option
record
  1. for the specified language will be created and saved. 
Note

Note

.
  • Enter the translation in the Title field.
  • Specify the two-symbol name of the language in the Language field.
  • Click Save or Save and Exit to apply changes.

    • Please note that the Value field has to remain unchanged. 

    Image Removed


    Image Modified


    Image Added


    Infotip

    If some of the choice options were are not localized (for example, some added choice options in English but didn't add their translations), then in user locale other than English, choice the 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.  


    Table of Contents
    absoluteUrltrue