Column Advanced Settings: Multiple Selections

Overview¶

This setting allows you to select multiple options for class column.

Limitations¶

1. If multiple selection is enabled in the parent table and there is a class column with a link setting, the sort function for the class column of the parent table displayed in the link list on the child table editing screen will not work.

Operation Procedure¶

Open the Editor tab from Manage Table in the Manage menu.
Select the class column for which you want to use the multiple selection function from the Enabled column and click the Advanced Settings button.

Check "Multiple Selections" on the Advanced Settings screen and click the Change button. Return to the Editor screen and click the Update button.

Usage¶

For class column for which multiple selection is enabled, a check box will be displayed at the beginning of the line of options, allowing multiple selections, as shown below.

If the search function is enabled, multiple selections can be made in the search dialog. Hold down the Ctrl key (Windows) or Command key (Macintosh) while clicking the columns you want to select. Range selection with the Shift key is also possible. After selecting the columns, click the "To enable" or "To disable" button. Clicking the "To enable all" or "To disable all" button enables or disables all columns.

In the list screen, multiple selected columns will be displayed side by side as shown below.

Setting the Default Value¶

For a class column with multiple selections enabled, the default value must be registered in array format as follows.

["山田太郎","鈴木鈴子","佐藤里美"]

Export¶

Class column with multiple selection enabled will be exported as follows.

["Ishida Shokichi"]
["Yamada Taro", "Suzuki Suzuko", "Sato Satomi"]

Set Export¶

Class column with multiple selection enabled can be exported as follows, with or without checks for each column. Open the Export tab from the Manage Table in the Manage menu, select the column with multiple selection enabled, and click Advanced Settings.

Check the Output Class column check box in the dialog and click Change. When you return to the export screen, click Update.

Selections will be output as individual columns, with 1 written for selected columns.

Import¶

Similar to the export, columns with 1 written in the columns will be imported as selected.

Supported Versions¶

Related Information¶

• Manage Table: Editor
• Manage Table: Export
• Import CSV Data to Pleasanter