Tables

Editable Table

The Editable Table is a dynamic interface for displaying and modifying structured data stored in a SQL-compatible database (e.g. SQLite, MySQL, MSSQL). It supports interactive frontend editing, allowing users to add, update, and delete records through the UI. All changes are applied directly to the connected database.

Like all table types in PLCVisu, the Editable Table supports a granular permission model to control access. Permissions are assigned per user or role, and can be granted for:

• Read – view records
• Insert – add new entries
• Update – modify existing data
• Delete – remove records

This mechanism ensures that only authorized users can interact with the data based on their operational responsibilities. For example, an operator may only be allowed to insert new data, while a manager has full editing rights.

Editable Tables are ideal for workflows that require user-managed records, such as:

• Shift and operation logs
• Manual batch inputs
• Configurable production parameters
• Editable recipes or runtime settings

Additional functionality includes pagination, sorting, validation rules per field, and optional styling configurations. Columns can be customized in structure and format, including dynamic elements such as icons or colored rows.

---

Key Features

• Frontend editing – add, update, and delete data directly
• Shared permission model – like all tables, supports Read, Insert, Update, Delete per user or role
• SQL database connection – works with relational backends (SQLite, MySQL, MSSQL, etc.)
• Secure data handling – ensures only authorized modifications
• Validation logic – define rules per input column
• Pagination and sorting – for efficient navigation of large datasets
• Customizable columns – structure, label, type, visibility
• Styling support – row formatting, icons, alignment, conditional formats