Overview

A field is an essential component within a table, designed to store specific types of data. Each field represents a single piece of information, such as text, numbers, dates, or other formats. Fields help organize and structure the data, making it easier to input, manage, and retrieve information. By defining appropriate field types and settings, user can ensure data accuracy and optimize how users application handles and displays the stored content.

Create

Press the "+" sign button next to the "#" sign. A pop-up with 18 different fields will appear. Choose the field you need to use.

1 - “+” button to add column (fields). 2 - Field list

After selecting a field, an additional pop-up will appear where you can enter information. This includes naming the column (field), choosing the type of field, and setting the format for the selected field.

1 - Label 2 - Type of the Field 3 - Type of the Format 4 - “Add column” button

When users interact with the drop-down button next to a field label, they can make changes specific to that field without affecting others. This feature is often used in table or form views where multiple fields are displayed, and users need quick access to field-specific options. The drop-down button, typically represented by a blue button, helps streamline the interaction by allowing users to configure fields directly from the interface.

The drop-down button’s menu provides a simple way to manage field-level actions with minimal disruption to the user’s workflow. Below is a more detailed explanation of how each feature interacts with the field and the broader interface.

This blue button menu next to the field label provides a powerful and flexible way for users to interact with individual fields in the table.By providing these options, the system empowers users to tailor their data views, focus on relevant information, and keep the interface organized to suit their workflow needs.

Below is link with more descriptions for options inside blue button:


Edit field

The “Edit Field” function allows users to modify the attributes of a specific field. When you click this option:

• A form or modal will appear with the details of the selected field (such as field name, type, default value, etc.).

• Users can change these properties, including renaming the field, updating its data type, or modifying validation rules.

• After editing, the changes are saved and reflected immediately across the system wherever the field is used.


Sort A -> Z

The “Sort A -> Z” function allows the user to sort the values of the selected field in ascending order.

• This works for fields containing text or numbers.

• After pressing this option, the system will reorder the data according to the alphabetical or numerical value of the field.

For example: if it’s applied to a “Name” field, the system will sort names from A to Z.


Add Summary

The “Add Summary” function provides a quick statistical summary for the selected field. This include:

Sum: For numerical fields, the total sum of the field’s values.

Average: The average value of a numerical field.

This option is particularly useful in table views where fields may have numerical data (such as sales, costs, or quantities), giving the user insights at a glance.


Fix Column

The “Fix Column” function allows users to lock (or fix) the selected field’s column to the left side of the view in a table, keeping it visible while scrolling through other data.

• Once fixed, the selected column remains visible as the user scrolls horizontally across the rest of the table. This is particularly useful for large datasets where a key field (such as “ID” or “Name”) needs to stay visible.


Hide field

The “Hide Field” function allows users to temporarily remove specific fields from table for a cleaner interface. When you click this option:

  • Fields like “Client” or “Client type” can be hidden, reducing visual clutter in areas where they are not needed for daily operations.

  • The fields are only removed from the current view or user session, not deleted from the database.

  • Users can later restore hidden fields by adjusting the view settings or preferences, ensuring flexibility in managing the interface according to their needs.


Delete field

• Deleting fields should be done carefully as it may result in the loss of critical data. Some systems provide warnings or require administrator confirmation before allowing deletion. In more robust systems, there may be options to back up or archive the data before deletion.

Last updated