(7)-a. Overview

Layout name

Picture

Detail

DataTable

Place fields of related objects (parent-child or lookup) as a DataTable / related list.
Columns can be tied to fields of a related object.
If the DataTable is placed in a pageblock, you can select to display as a page block table or a DataTable.
If the DataTable is placed outside of a pageblock, it will appear as a DataTable.


After placing the component on the layout, the below dialog will appear to select several options.

 

Setting name

Detail

Basic setting  Relation

Select Data Table which is either related or not related to the present layout of the Main object
 Related:Display data which is related to the Main Object
 Not Related:Display data which is not related to the Main Object

ObjectSet relational object for Main object
Show AllIf checked, all objects are shown in the 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”
ColumnsSet the number of columns in table.
Selectable from 1 to 40.

Viewing Configuration

Add Row

Set to show or hide the button to add new records.

Delete Row

Set to show or hide the button to delete records.

Bulk Clone

Copy record data from within the table

Bulk Edit / Delete

Allow user to edit and 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

It is also possible to change the number of columns after the table is placed on the layout.
Click on the DataTable to bring up the dialog to change the columns.


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

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

Delete the selected column and all fields placed within.


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