(8)-a. Overview

Layout name

Picture

Detail

MultipleRow DataTable

The MultipleRow DataTable allows you to place relative object fields like the DataTable component.
The major difference of the MultipleRow DataTable is that you can place up to 5 fields in one column in the DataTable.
You can also merge two or more columns.


After added the MultipleRow DataTable to the layout, the below configuration dialog appears.

Setting name

Detail

Basic setting

Object

Set child object that this table will represent.

Object Set child object that this table will represent.

Show All

Show all objects in the Object list. For more details, refer to < (1)-a. New >

Search (Filter)

Only selected/filtered objects will display in Combo box when a character string is input in the filter,
*Available when the Relation setting with the Main Object is set as “Not Related”

Row

Set the number of header rows to show in the table between 2 and 5.
(Attention)
The Row count multiplied by the Column count cannot exceed 40

Column

Set the number of header columns to show in the table between 1 and 40.
(Attention)
The Row count multiplied by the Column count cannot exceed 40

Viewing Configuration

 

 

 

Add Row

Allow the user to add new records directly from the table.

Delete Row

Allow the user to delete records directly from the table.

Clone Row

Allow the user to clone records directly from the table.

Bulk Delete

Allow the user to delete multiple records at once from the table.

Remove Required

By making the required fields optional at input time you can copy multiple rows
and input data afterwards whereas if required fields are required at
input time you must fill out an entire record before copying it.

Paging

Allow the user to page through many results
We recommend to use paging for DataTables with very large numbers of records.

Paging Count

When paging is active, select the number of records to show in one page from below.
5,10,25,50,100
This property is only available when paging is active.

Client-side Filter

Add search text box to a table which will allow users to search for partial match.
Refer < (5) Search box for Table > for more details on settings

 

Click on the component to bring up the MultiRow DataTable popup dialog.
There are two modes of editing the MultipleRow DataTable. By default, the component is set to be in single select mode.
Single Select Mode restricts a user to moving or adjusting a single cell at a time.
The other mode, Range Select Mode, is used to combine columns and cells.

【MultiRow DataTable popup dialog】

Insert a new column to the left of the selected column.

Insert a new column to the right of the selected column.

Delete the selected column and its contents.

Insert a new row above the selected row.

Insert a new row below the selected row.

Delete the selected row and its contents.


【Single select mode】


【Range select mode】


【Combine Cells】
Upon selecting several cells with the Range Select Mode, you will be prompted if you would like to join the selected cells.

【Cell Join Release】
Select a joined cell and click the release button to bring it back to how it was previously.


You can change the number of columns and rows on the table even after it has been placed on the layout.
Click on the show header button to bring up the table headers.


Click on a specific column or row to enable the insert column, insert row, add column, add row and delete column and delete row buttons.

If any components or fields exist within the column to be deleted, a confirmation dialog warning will appear.