¶ 1. Overview
The Data Table Creation feature lets you structure and store data that will be used in forms, analysis, and integrations inside T6. This tool is flexible and adaptable to different use cases, allowing everything from manual column creation to SQL queries and existing database tables.
The creation process is guided by steps that include defining table properties, configuring columns, and optionally creating relationships with other data sources. The selected creation type (Create, Table, or Query) determines the configuration flow and the resources available for the object.
To use the new Data Table creation mode, you must enable New Edit Data Table in the Preview panel, under Settings in the T6 main menu.
¶ 1.1. Prerequisites
To create, edit, and view data tables, the user must have the following Manager Feature enabled in Permissions:
The user must also be associated with a global group with the following Manager Features enabled:
¶ 2. Features
Main Data Table capabilities in T6 include:
- Creating Data Tables using three types: Create, Table, or Query.
- Manually adding columns with different data types (Text, Date, Decimal, User, etc.).
- Configuring relationships with other Data Tables, Dimensions, or Users.
- Option to use an existing Data Table as a template.
- Defining properties such as name, description, creation type, storage, and auditing.
- Guided, step-based interface for easier setup.
- Database and SQL query integration (for the Query type).
¶ 3. Usability
To switch Data Table creation to the new user interface, open the T6 main menu and, in Settings, select Preview.
With the Preview panel open, enable New Edit Data Table. Then close the panel and refresh the page.
1. Open Explorer and select where the Data Table will be created;
2. In the ribbon, select New Item and, under Data Entry, click Data Table;
3. Select the created object and open it by double-clicking or, in the ribbon, by clicking Open;
- After opening the object, a side panel appears where the Data Table creation settings are configured.
Fields marked with * are required.
Data Table creation is divided into multiple steps. The first one, Properties, contains these fields:
- Base template: Through a dropdown, select an existing Data Table in the system to use as a base;
- Name*: Name defined for the object;
- Description: Optional field to describe the object;
- Creation Type*: Dropdown with Create, Table, and Query;
- Audit: Switch button. When enabled, object auditing is turned on;
- Storage: Dropdown with available storage options. (For more information, see: Storage)
- Storage folder: If a name is provided, a new folder is created inside the Azure Portal container to store uploaded files. If blank, files are saved directly in the container.
The selected Creation Type determines the next Data Table configuration steps.
¶ 3.1. Creation Type: Create
1. After completing Properties, click Next;
- When you click Next, you are taken to Configure Columns;
In Configure Columns, only the Identity column appears at first. To add columns, click Add Column. The fields are:
- Column name*: Name of the column to create and display in the header;
- Allow null values: Switch button. When enabled, forms using this column can be saved even if no value is entered;
- Column type*: Dropdown with the following options:
Column Type
| Option | Description |
|---|---|
| Date | Cells of this type show a dropdown with a date-picker. The date can be chosen in the component or entered manually using day/month/year separated by /; |
| Decimal | Accepts numeric values with mandatory decimal places. You can define how many decimal places to use. Ideal for monetary values and precision calculations; |
| Integer | Accepts whole numbers (positive, negative, and zero), without decimals; |
| Text | Accepts text values with a maximum character limit. Supports special characters (@, #, &...), accents, and line breaks; |
| Percentage | Accepts numeric values with decimals and a fixed percentage operator. Automatically displays % after the value. Entered values are interpreted as percentages (e.g., 25 = 25%); |
| File | Allows upload of files in these formats: .gif, .jpeg, .jpg, .png, .xml, .pdf, .doc, .docx, .txt, .csv, .xls, .xlsx. Integrates with configured storage. Shows file name and allows download; |
| Calculated | Accepts values from calculations. Requires the Expression* field. Supports arithmetic operators (+, -, *, /) and allows Functions; |
| Dimension | Allows selecting members from a dimension. Requires Application* and Dimension*. Displays available members in a hierarchical tree, limited by user permissions; |
| Data Table | Allows selecting another existing Data Table. Cells of this type show a dropdown to select one of the columns from the selected Data Table; |
| User | Shows a dropdown to select a system user based on the users table in the database; |
| Real | Accepts floating-point numeric values without requiring fixed decimal places; |
| Formatting | Lets you change spreadsheet properties: Number, Alignment, Font, Border, Background, Size, Order, Level, and Indent. |
After filling the column name and type, click Apply. The column is added to the list and you can repeat the process for as many columns as needed.
2. After adding columns, click Next.
In the previous step, if you added a Data Table, Dimension, or User column, the relationship is already created and shown in Configure Relationships.
3. Click Confirm to add the link.
4. Finish by clicking Complete.
¶ 3.2. Creation Type: Table
1. After completing Properties, click Next;
- You are taken to Configure Columns;
In this step:
- No columns are displayed initially;
- Use the Select a Table dropdown to choose a table directly from the database;
- Use the Distinct Values switch if needed;
Distinct Values: When enabled, a given value appears only once in the table being created, hiding duplicate values from the related table. A unique value is defined by the combination of all columns; therefore, if one column has unique values, such as
ID, the "Distinct Values" flag will not have effect.
- Add columns individually by clicking Add Column. Required fields: Column*, Alias* (header display name), and Type*;
Column Type
| Option | Description | Example |
|---|---|---|
| Display | Shows values exactly as stored in the selected data table; |  ↓  |
| Minimum | Shows only the lowest numeric value for a given context, hiding the rest; | ↓  |
| Maximum | Shows only the highest numeric value for a given context, hiding the rest; | ↓  |
| Sum | Performs the sum of all numeric values in a given context and shows only the total; | ↓  |
| Average | Calculates all numeric values in a given context and shows only the average; | ↓  |
| Count | Checks existing contexts in the table and shows the total number of records for each context; |  ↓  |
Except for Display, the column types above only apply to Decimal, Integer, Percentage, and Real columns;
If preferred, click Add all Columns to import all columns from the selected table, then edit or remove them.
When clicking Add all columns, the default column type is Display.
2. After selecting columns, click Next.
In the previous step, if you added a Data Table, Dimension, or User column, the relationship is already created and shown in Configure Relationships.
3. Click Confirm to add the link.
4. Finish by clicking Complete.
¶ 3.3. Creation Type: Query
1. After completing Properties, click Next;
- You are taken to Configure Columns;
In this step:
- No columns are shown initially;
- Add columns through Define Query, writing an SQL instruction directly in the database;
- You can add columns individually with Add Column (fields: Column*, Alias*, and Type*);
- Or import all columns returned by the query with Add all Columns, then edit as needed.
2. Click Next after configuring the columns.
In the previous step, if you added a Data Table, Dimension, or User column, the relationship is already created and shown in Configure Relationships.
3. Click Confirm to add the link.
4. Finish by clicking Complete.
The selected columns displayed through a Data Table are shown through the relationship between a Data Form and the created Data Table.
¶ 4. Relationship Configuration
This step displays a table with 2 columns: Object and Mapping.
-
Object: Displays the object name where the data is stored and links it to the Data Table column used for display. This field identifies the reference source used in the relationship, which can be an existing data table, an OLAP dimension, or the system users list.
-
Mapping: Displays the name defined for the Data Table column and shows it next to the related object. It represents the foreign key in the current table that connects to the corresponding record in the target table.
Each row in this table represents an existing relationship inside this Data Table.
3. Click Add to manually create a new link.
A modal opens requesting the Type* of relationship. Select one of the three available options: Data Table, Dimension, or Users.
Each type provides different configuration and mapping options, with specific characteristics.
¶ Data Table
This relationship type connects the current table to another existing data table in the system.
When Data Table is selected, a dropdown is displayed listing all available data tables in the system. Choose the table that will be used as the relationship data source.
Self-Referential Relationships: If you need to relate a column to the same table (for example, to create hierarchies where a record has a "parent" in the same table), save the data table without the relationship first. Then reopen the object for editing, go to relationship configuration, and select the same data table.
¶ Dimension
This type connects the table to application dimensions, enabling integration with hierarchical structures already defined in the system.
When Dimension is selected, two additional fields become required:
- Application: Dropdown with all applications available in the system
- Dimension: Dropdown dynamically populated with dimensions from the selected application
¶ Users
This type links table records to specific system users.
The Users relationship requires no additional fields because it automatically uses the system users table as the data source.
¶ 4.1. Column Mapping
After selecting and confirming the relationship type, click Add. A new row is created in the Data Table Links table, showing two fields for mapping configuration:
¶ Mapping Configuration:
-
Column: Dropdown to select the column in the current Data Table that acts as the foreign key. This column stores the related record identifier.
-
Column in Object: Dropdown to select the corresponding column in the related table, dimension, or users source that acts as the primary key.
4. Click Confirm to add the link.
After confirmation, the relationship is listed in the main table.
5. To finish relationship configuration, click Complete.
¶ 5. Q&A
Frequently Asked Questions
1. How do I enable the new Data Table creation mode in T6?
To enable the new Data Table creation mode, follow these steps:
- Open the T6 main menu;
- Go to Settings;
- Select Preview;
- Enable New Edit Data Table;
- Close the panel and refresh the page.
2. Which permissions are required to work with data tables?
To work with data tables in T6, the user must have the manager feature Manage the structure of data tables enabled and be in a global group with Manage Explorer and Manage Data Tables enabled.
3. When creating a data table, what is the difference between "Create", "Table", and "Query"?
The difference is:
Create: Lets you add columns manually with different data types;
Table: Uses an existing database table as the source;
Query: Uses custom SQL instructions to define the data.
4. When should I use each creation type when creating a new data table?
When creating a new data table in T6, use:
Create for custom structures;
Table to reuse existing database data;
Query for more complex needs that require custom SQL commands.
5. Which column types are available in the "Create" type for Data Tables?
The available column types in Create are:
Date;
Decimal;
Integer;
Text;
Percentage;
File;
Calculated;
Dimension;
Data Table;
User;
Real;
Formatting.
6. What does the "Distinct Values" option do in the "Table" creation type?
The Distinct Values option in Table creation removes duplicate values based on the combination of all columns.
Note: it does not work if there is a column with unique values, such as ID.
7. Which file formats are accepted in "File" type columns in a data table?
By default, the following file formats are accepted:
.gif;
.jpeg;
.jpg;
.png;
.xml;
.pdf;
.doc;
.docx;
.txt;
.csv;
.xls;
.xlsx.
Users can restrict these formats through system parameters.
8. How do aggregation types (Minimum, Maximum, Sum, etc.) work in "Table" type data tables?
Aggregation types work as follows:
Display: Shows values as they are stored;
Minimum/Maximum: Shows only the lowest/highest numeric value;
Sum: Totals all numeric values;
Average: Calculates the average value;
Count: Counts records by context.
9. In data table creation, how do I create relationships between tables?
After configuring Properties, in Configure Relationships, click Add and choose the type: Data Table, Dimension, or Users. Then map the corresponding columns.
10. In "Configure Relationships", can I relate a table to itself?
Yes, but you must save the data table first.
After saving, reopen it in edit mode and configure the relationship to the same table.
11. What is a "Base template" in data tables?
A Base template is an existing Data Table that can be used as a model to create a new one by copying its structure.
12. What is the "Audit" option used for in data tables?
The Audit option, when enabled, allows tracking changes and access to the data table (for more information, see: Audit).
13. How do "Storage" and "Storage folder" work in data tables?
The Storage and Storage folder options define where files are saved in Azure. If a folder is specified, it is created inside the container; if left blank, files are saved directly in the container (for more information, see: Storage).