Left Tree Right Table Linkage

This function allows users to select nodes in the left tree structure, and the corresponding node data will be displayed in the right table. Taking the organizational structure tree on the left as an example, when a node is clicked, the right table will filter and display the member information under that department.

Function Description

The left tree right table linkage function consists of the following parts:

Department Table

Field Name	Identifier	Type	Description
Number	code	Number	Automatically generated number based on the expression SZZX${String.lpad(seq,5,'0')}
Organization Name	name	Single Line Text
Sub-department	children	Sub-object	Build tree structure through this field

Member Table

Field Name	Identifier	Type	Description
Name	name	Single Line Text
Department	dept	Associated Record	Associated with Department Table for filtering member information
Position	post	Single Line Text	Ledger field, only stores ledger information, not involved in business logic
Entry Date	entryDate	Date	Ledger field, only stores ledger information, not involved in business logic

Interaction Instructions

• Left Tree Structure: Use the Sidebar module to load the Department Table module and build the organizational structure tree.
• Right Data Table: Directly use the Member Table module.
• Linkage Effect: When the user clicks a department on the left, an automation is triggered through the Click Record type Table Event listener added to the Department Table, setting the filter conditions for the Member Table module, achieving the function of clicking a record and displaying the corresponding department member data in the right table.

Effect

Department Table Event Listening - Click Record

1. Pass in parameter ${clickRecord}
2. Set up automation to set user filter conditions, the specific automation definition is as follows

Department Table Event Listening Automation

Input parameters:

Parameter	Type	Required
record	Record	Yes

1. Add step [Set Data Table Filter]

   Parameter	Value
   Data Table Module	Member Table
   Filter	Department equals ${record.id}

2. Refresh module, module is Member Table