https://home.simpleone.ru/record/safe_story/160520607613610616

СОРС: 


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 Column Override in the Related Lists area.


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.


You also can 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 need to fill in the Table field manually.


Column form fields

FieldMandatoryDescription
TableY

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 TypeY

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.

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.

Read OnlyNSelect this checkbox to make the field read-only.
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.

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.

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 tab
Choice TableNReference to a table.
Choice TypeY

Available options:

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

If the Dropdown without --None-- is chosen, the Dafault value tab becomes mandatory.

Choice FieldYReference to the specified field of the table. Its values will be available for the Choice field.
Default Value tab
Default ValueNThe field is not mandatory if the Choice Type is Dropdown with --None--.
Use Dynamic DefaultNCheck this box for the Dynamic Default field to appear.
Dynamic DefaultN

This 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, so its execution result will be automatically calculated and entered into this field. This value will be the default value for the column specified.

  1. 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.
  2. You can choose only active scripts (the Active attribute is equal to Yes).



Create a choice option

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:

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


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.

You can also 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 version as for the original one.

ColumnY

Specify the column to which this choice option is related.

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

TitleYType the translation of the source field there.
LanguageYIn 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.
ValueYType the same value as specified for the source field.
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

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 Column Override tab.
  3. Click New and fill in the fields.
  4. Click Save or Save and Exit to apply changes.


You also can find the form this way:

  1. Navigate to the System Definition → Column Overrides.
  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 Base Table and Column fields manually.


FieldMandatoryDescription
Base TableYThe parent table. This field is populated automatically.
TableYThe table this override is created.
ColumnYThe column this override is created. This field is populated automatically.
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 OverrideN

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 OverrideNSelect this checkbox to display the Read Only field, which overrides whether a user can change the field value on the extended table.


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. Click Save or Save and Exit to apply changes.

Translated choice option form fields

Field

Mandatory

Description

TableY

Specify the table to which this choice option is related.

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

ColumnY

Specify the column to which this choice option is related.

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

TitleYType the translation of the source field there.
LanguageYIn 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.
ValueYType the same value as specified for the source field.
OrderYEnter the number to define the option order in the choice list.
HintNText 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.  


Choice option order