# Field Correlation The use case for this function is leave application. There is two master data as below:\ \ 1\. Leave Type Master Data\ 2\. Leave Balance Master Data In the leave application form, when the applicant selects a leave type (sourced from the leave type master data), the system should automatically populate the applicant's leave balance, which is stored in the leave balance master data, by utilizing the Field Correlation function. Below are the steps to configure Field Correlation: ## 1. Create an action flow

Create a new action flow in the leave manegement application

Choose User-defined Event Triggering

Click input Parameter Settings

Add two parameter 1. applicant and 2. leavetype
Note: The values for these parameters will be taken from the Leave Application form field inputs.

Add a Data Source Query operation to retrieve data from the Leave Balance Master Data.

For Data Source, select the Leave Balance Master Data in Leave Management Application

For Conditions, add two filter
1. Staff Name equal to the first parameter (applicant)
2. Leave Type equal to second parameter (leavetype)

Note: This filter ensures that the system only retrieves data from the Leave Balance Master Data that matches these two conditions.

For Query Field, select Leave Balance and Used

For Operator, select any of the personnel.
Note: Operator refer to who execute this query action. In actual case, HR will be the operator.

Click Output Parameter Settings

Add two parameter 1. leavebalance and 2. used. Then, select dynamic assignment and assign the corresponding query field to each parameter.

Note: The data retrieved from the Leave Balance Master Data is assigned to the leavebalance and used parameters, which will then be input into the corresponding fields in the Leave Application form.

Save and enable the action flow

Give a name for the action flow and save

### 2. Configure field correlation in leave application form

Click field correlation button

Add a new correlation

For Trigger Action, select Leave Type and click on the +Add button.
Note: The Trigger Action refers to the condition that determines when to execute the field correlation. In this case, the field correlation is triggered when the Leave Type value is changed.

For the Query Method, select ESB as the action flow is used to trigger the field correlation. Then, choose the action flow that was created earlier.

For Input Parameter, select form fields and choose the Applicant and Leave Type.
Note: This means that the values of Applicant and Leave Type in the Leave Application form will be assigned to the parameters to execute the action flow, which will search the Leave Balance Master Data for records that match these two conditions.

For Input Parameter, select form fields and choose the Leave Balance and Used.
Note: This means that the values of the parameters (leavebalance and used), retrieved from the Leave Balance Master Data, will be assigned to the Leave Balance and Used fields in the Leave Application form.

Save the settings and form

#### 3. Preview and test

Preview the Leave Application form

Select a Leave Type, the Leave Balance and Used will be automatically populated

--- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://echelp.weaver.com.co/e-builder/field-correlation.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.