Versions Compared

Key

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

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:

  • by defining inheriting values from a table and its columns as a sourceparent 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 first case, the choice field inherits the values from a parent table. To second case, you may need to create a different set of choices , you need to make another set using 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:

Image Added


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.

...

Tip

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 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.

...

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 Column Override Choice tab.
  3. Click New and fill 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 → Column Overrides 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 Base Table 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

FieldMandatoryDescription
Base TableY
The parent table. This field is populated automatically

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

TableY
The table this override is created
In this dictionary field, you can select the child table that will be affected by overriding.
ColumnY
The column this override is created. This field is populated automatically
In this dictionary field, you can select a column to be overridden.
Display by Ref OverrideNSelect this checkbox if you need to override
the 
the Display by Ref
 setting
setting which is responsible
for what
for what column will be displayed instead of reference IDs.

Default Value Override

N

Select this checkbox to display

the 

the Default Value

 field

 field, which overrides the default value for the field on the extended table.

After selecting this checkbox,

the 

the Default Value

 field

field appears.

 Enter

 Enter the default value that will override the original one. 

Reference Qualifier OverrideN

Select the checkbox to display

the 

the Reference Qualifiers fieldset, which overrides

the reference qualifier for

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 
  • it Simple
 or 
  • or Dynamic.
  • Reference Qualifier Condition
 
  • - build a reference filter that will fit the necessary conditions.
  • Dynamic Reference
Qualifier 
  • Qualifier - if you have chosen
the 
  • the Dynamic
 type
  • type from the choice menu above, then select the appropriate one from the dictionary.
Mandatory OverrideNSelect the checkbox to display
the 
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 

the Read Only

 field

 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.


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.

Image Added Image Added


Translation Translated choice option form fields

...