The Datalexing system is a powerful system for managing and organizing data, relying on organizing data into tables containing rows and columns. The column is considered an essential part of this structure, as it is used to store a set of values of the same data type. Columns can be configured in multiple ways to suit your project's needs.

Each table in the applications consists of many table cells, which are parts of the information.

These table cells are arranged in columns and rows. Rows represent records. Here, information about a specific entity (such as a customer, order, etc.) is retained. Columns represent fields. The field corresponds to specific data such as ID, color, postal code.

What is a Column?

The table consists of rows and columns, which are displayed in table view.

In the table, the column is a set of values of the same data type; each column is a data structure holding a specific data type.

Columns are used to maintain table relationships. You can take a column from one table and merge it into any other table. This is because the table is not just a means of storing your data; it is an object that can contain other objects, each of which can collect data.

In Datalexing, each column can be configured to suit your needs. You can sort, filter, and hide columns in a specific view without affecting other views in the table.

Column Types

A column can store many different types of data, but the important thing is that it can store only one type of information, not a mixture. Columns feature different data types, such as text, numbers, dates, binary values (true/false), participants, choice, link, email, file, and more:

Column Type	Description
✏️ Single Line Text	The single-line text field allows entry of short, unique pieces of text into the table.
🗒️ Long Text	The long text field can contain long paragraphs or multiple lines of text.
🔌 Link to Table	The linked table field creates a link between two existing tables by linking data across associated rows.
#️⃣ Number	The number field is a type of field that contains numeric values.
⭐ Rating	The rating field is used to evaluate your rows for classification or quality assessment.
✅ Boolean	The boolean value represents information in true/false format.
📆 Date	The date field allows entry or update of a date and time in a cell.
✍🏻 Last Modified	The "Last Modified" field type returns the date and time of the last modification for the row.
💾 Created At	The "Created At" field type automatically displays the date and time a row was created by the user.
🔗 Link	The link field holds a single link.
✉️ Email	The email field type allows entry of a single email address in a cell in the correct format.
📁 File	The file field allows you to easily upload one or more files from your device or from a URL.
1️⃣ Single Select	The single-Select field type has specific options to choose only one option from a set of options.
🔢 Multiple Select	The multiple-select field contains a list of choices to choose multiple options from a set of options.
☎️ Phone Number	The phone number field formats a string of numbers as a phone number, in the form (XXX) XXX-XXXX.
➗ Formula	A value can be calculated in each row using a formula based on values in cells in the same row.
👥 Collaborator	Assign participants by selecting names from a list of workspace members.
🧮 Count	The count field automatically counts the number of rows associated
🔦 Search	You can search for a specific field in an associated row using the search field.
📦 Collect	Aggregate data and gain valuable insights from linked tables.
✨ Artificial Intelligence	With the help of artificial intelligence, you can generate new values based on values from other columns. Such as translation, language and spelling correction, paraphrasing, text shortening, text lengthening, summarization, sentiment analysis.

To learn more about Column Settings Click here

Footer Aggregation

Aggregations in the footer play a crucial role in calculating values derived from a specific column within a table.

You can calculate the value of the aggregation in the footer by looking at all the rows in the tables. These resulting values are displayed in footer cells for easy reference. This allows for quick assessment and summarization of column values across a range of rows, except for the search column.

Please note that these aggregated values cannot be referenced. The aggregation in the footer provides a summary of the column by default, with the footer summary for each column being empty.

To get a specific summary for a particular column, follow these steps:

In any table, click on the footer bar at the bottom of the table to select the aggregation function.
Select from the various available functions for the selected column. Once an aggregation is created, the results will be displayed for each column in the footer area.

General Functions

The column type will determine the types of footer summaries available.

Some summary functions will appear in columns like Creation At, Single Select, Single Line, Phone Number, Email, File, Multiple Select, Formula, Linked Table, Long Text, URL, Last Modified, and which are:

Empty
Filled
Percentage of Empty
Percentage of Filled
Unique

(Except for Linked Table, File, Created At, and Multiple Choice columns)

Date Column Functions

In addition to general functions, some functions will only appear in Date, Last Modified, and Creation At columns:

Oldest Date

Newest Date

Logical Data Columns Functions

The aggregation function for Logical Data columns allows you to see the count or percentage of selected and unselected cells.

Selected
Unselected
Percentage of Selected
Percentage of Unselected

Numeric and Rating Columns Functions

In addition to general functions, you can use the footer aggregation for the Number column to calculate the sum, minimum, or maximum of numeric data in columns. For numeric and rating columns:

Minimum
Maximum
Sum
Average
Median
Standard Deviation
Variance