Visual columns are inserted only within the powertable sheet. These are not added to the source database.
To add a visual column, select Insert Column > Visual Column and then choose the required column type to be inserted. There are six column types available:
| Column type | Summary | Typical use case |
|---|---|---|
| Multi-select Relationship | Multi-select column that selects values from a lookup table for each record in the primary table, based on the relationship table. You can also select values from the displayed list, retrieved from the lookup table. | Assign multiple sales representatives to a product, multiple skills to an employee, or multiple tags to a task. |
| Reference | References and displays read-only values from another table based on matching keys. | Display a customer's region, department name, or manager name without duplicating data. |
| Relation | Each record provides a navigation link to related child records in another table (master-detail relationship). | Open all order records for a selected customer or view all tasks related to a project. |
| Rollup | Aggregates values from related records and displays a summarized result, such as a sum, count, average, minimum, or maximum value. | Show total project cost, total hours worked, or the number of open tickets for a customer. |
| Button | Adds an action button that opens a URL or triggers an automation. | Open a URL, launch an automation, or start a workflow. |
| Attachment | Stores and manages files associated with a record. | Attach contracts, invoices, images, or supporting documents. |
