Page History

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

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

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

When creating a

Choice column,

1. Navigate to the System Definition → All Tables.
2. Open the table for which you want to create a column.
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.

You can also open the form this way:

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.

in addition to the mandatory fields, you need to fill in the

following fields:

choice_decorator=radio

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 to of another one);.
• by creating a set of records for this field in the Choice Options dictionary (sys_choice) ;table.
• by defining a source table and its column in 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 tableColumn 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

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

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

Choice option form fields

Overriding of choice options set for child table

When creating a choice field option, it is recommended to set text values in the 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.

Regarding As for task states, it makes sense to make values numericalnumeric; this can help with selection construction (see the code sample below).

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

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

1. Navigate to the column for which you want to create a new set.
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 Table field with the name of the table for which you need to configure a new options set.
5. Click Save or Save and Exit to apply changes.

To learn how to change the column attributes, please see 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 user locale.

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

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

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

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

Image Removed

1. copy of the current choice option for the specified language will be created and saved. 

Image Modified

Image Modified

Peculiarities of choice option values

Choice option values have some peculiarities when displayed within:

• Server-Side Scripts
• Client Scripts.

Server-Side Script peculiarities

If choice option values are float or integer numbers, you can use an argument as a string or a number:

const record = new SimpleRecord('field_type_example');
record.get('c_type', '1.5');
// OR record.get('c_type', 1.5);
ss.info(record.sys_id);
ss.info(typeof record.c_type);
// Info: 164027421215882293
// Info: number

const record = new SimpleRecord('field_type_example');
record.addQuery('c_type', '1.5');
// OR record.addQuery('c_type', 1.5);
record.query();
record.next();
ss.info(record.sys_id);
ss.info(typeof record.c_type);
// Info: 164027421215882293
// Info: number

If choice option values are number or string type, values in a choice field will be of the same type:

const record = new SimpleRecord('field_type_example');
record.get('c_type', '1.5');
ss.info(record.sys_id);
ss.info(typeof record.c_type);
ss.info(typeof record.getValue('c_type'));
// Info: 164027421215882293
// Info: number
// Info: number

Client Script peculiarities

Regardless of the type of choice option values, in client scripts, values returned by the s_form.getValue() and window.currentCell.value methods will contain the string:

console.log(typeof s_form.getValue('state'));
// string

When comparing values in a choice field, they should be the same type. If they are not, use loose equality (==):

if (String(current.state) === '-2') {...}
// OR
if (current.state == '-2') {...}

To check values in a choice field for equality to one of the values, use the following construction:

if ([-2, 0, 2].includes(+current.state)) {...}
// OR
if (['-2','0','2'].includes(String(current.state))) {...}