¶ 1. Overview
Its main functionality is the ability to link a data table to another data table.
For example: to detail the expenses of a trip that should be reimbursed, we can create one table for the spent amounts and another for detailing the values.
¶ 1.1. Prerequisites
To be able to create and configure this functionality within T6, the following requirements must be met:
- The user must have the Manager functionality: Create and View Data Entry Forms enabled;
- The user must have the Manager functionality: Manage the Structure of Data Tables enabled;
- The user must be added to a Global Group, with the Manager functionality: Manage Explorer enabled;
¶ 2. Configuration
To use the functionality, we first need to create 2 data tables.
¶ 2.1. Data Tables
-
In the first table, we will create and add 2 columns, one called description of type text, and another called value of type value;
-
In the second table, we will create and add 3 columns, one called reimbursements of type data table (we will select the Data Table created earlier), one called description of type text, and another called value of type value.
In Data Tables, a column of type data table is a workaround to facilitate creation without the need to create a link.
¶ 2.2. Data Forms
After creating the 2 Data Tables, we will create 2 Data Forms.
- The first form will be the place where we enter the input values;
- The second form will be the place where we enter the value details.
¶ 2.2.1. Data Form - Input Values
When creating the Data Form for input values:
- In Data Tables, click on the dropdown and select the first data table we created, which contains the description and value columns;
- Select the 3 displayed options (identifier, description, and value) and add them to Columns;
- Click on
to save the changes.
¶ 2.2.2. Data Form - Value Details
When creating the Data Form for value details:
- In Data Tables, click on the dropdown and select the second data table we created, which contains the data table, description, and value columns;
- In the layout step, select description and value and add them to Columns;
- Still in the layout step, select Identifier (DT Reimbursements) and add it to Pages;
- Select Identifier (DT Reimbursements) that was added to pages and click on
;
- A new window will open, select the Description option and click on
to add it to the right, then click OK; - Click on to save the changes.
¶ 3. Usage
Access the first Data Form created (input values) and add data. Doing so will create a new page in the second Data Form created (value details) for each added row.
- Select the first Data Form (input values) and click edit;
- Select the Value column and click on
;
- A new window will open, where we will click on the dropdown and select the Data Form (value details), then click OK;
- Click on to save the changes.
After doing this, when accessing the first Data Form (input values), there will be a button next to each row
, which, when clicked, will display the details according to the Data Form (value details) without the need to switch tabs.
→
To return to the first form, just click on
.