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.
