Tables

Advanced Table

The Advanced Table builds upon the functionality of the Editable Table, inheriting its ability to connect to SQL-compatible databases and support full frontend editing. In addition, it introduces advanced visual logic, enabling rich, context-aware presentations of the data.

At its core, the Advanced Table allows you to display dynamic content per cell — such as images, colors, or icons — based on rules written in JSON format. These rules evaluate the content of each cell and map it to a specific output.

This is especially useful in situations where visual cues can improve usability and data interpretation. For example:

  • Show a battery icon that changes with charge level
  • Use colored status indicators based on machine state
  • Display warning symbols when thresholds are exceeded

Visual rules can be applied per column and configured to react to specific value ranges, boolean states, or even combined conditions.

Just like all other table types, the Advanced Table integrates with the permission model (Read, Insert, Update, Delete) and supports all standard features of Editable Tables:

  • SQL database integration
  • User/role-based access control
  • Frontend editing (if permissions allow)
  • Pagination, sorting, column configuration
  • Validation and styling

Key Features

  • All Editable Table features – live connection, editing, pagination, sorting, validation
  • Visual rule engine – map values to images, colors, icons using JSON logic
  • Per-cell rendering – conditionally display different visual content per row/column
  • Ideal for dashboards and operator displays – intuitive status visualization
  • Compatible with permission system – restrict edit access by user/role
Delete
Update
Insert
Read