Skip to main content
Version: Next

Column Configuration

The Columns tab of the view designer allows you to precisely define the behavior and appearance of each field displayed in the list.

A view can contain different types of columns, each having specific parameters to adapt to the data being processed.

1. Common Parameters​

Regardless of the chosen column type, the following parameters are always available:

  • Title: The label that will be displayed in the column header on the Web.
  • Column: The technical field from the SQL query (or advanced mode).
  • Width (pixel): Fixed width of the column.
  • Auto expand: If checked, the column adapts to occupy the remaining space in the browser.
  • Visible: Allows hiding a column while keeping it in the query (useful for sorting or hidden calculations).
  • Exportable: Defines whether the column should appear in Excel/PDF exports.
  • Categorize / Sort: Allows defining a default grouping or sorting when opening the view (with a priority index if multiple columns are involved).
  • Default column filter: Defines the search operator offered to the user in the header (Contains, Starts with, Equals, etc.).

2. Description of Column Types​

A. Text​

This is the most common type. It allows displaying simple textual data.

Column type - Text

  • Format: Allows applying an input mask or specific formatting (e.g., converting to uppercase).

B. Number​

Used for columns containing numeric or monetary values.

Column type - Number

  • Format: Several predefined formats are available:
    • C (Currency): Uses the selected currency.
    • N (Number): With thousands separator.
    • P (Percentage): Multiplies by 100 and adds the % sign.
  • Currency: Monetary symbol to display (e.g., €, $).

C. Date​

For date or time type fields.

  • Format: Allows choosing between short date (d), long date (D), or only month and year (y).

Allows transforming a value into a clickable link to an external URL or internal resource.

Column type - HyperText Link

  • Text field: The field that serves as the link label.
  • URL format: The target address. You can use {0} to dynamically inject the value of the "Column" field into the URL.
  • Text if value is null: Substitute label if the data is empty.

E. Open document​

Specialized type that creates a link that directly opens the linked record (form record).

Column type - Open document

  • Text field: The link label (e.g., Reference Number).
  • Column: Must point to the record ID (GUID) to enable opening.

F. Advanced mode (Generic)​

Allows using advanced Web components or completely customizing the HTML rendering of the cell.

Column type - Advanced mode

Three models are frequently used via the template button:

  • Image: To display an icon based on the value (e.g., a status traffic light).
  • ProgressBar: To display a graphical progress bar.
  • HyperLink: For complex links with associated JavaScript scripts.

G. Other specific types​

  • Attachment (OpenFileColumn): Displays a paperclip icon allowing direct download of the main file associated with the record.
  • Favorites (FavoriteColumn): Displays a star allowing the user to mark the record as favorite.

See also: