Add Virtual Column

Virtual fields (columns) can be added to the data table for display. These virtual fields do not exist in the actual database but combine or calculate values from existing fields to present new information. For instance, you can create a 'Full Name' column by combining 'First Name' and 'Last Name,' or generate a 'Total Amount' column by multiplying 'Quantity' and 'Unit Price.' This feature allows users to flexibly display and analyze necessary information without altering the original data.

---

🔸 Steps to Add a Virtual Column

1. Click the Add Virtual button.

   

   Datatable Setup
2. Configure the virtual column’s Label, Column Align, and Column Width.

   

   Edit a Virtual Column
3. Select the Virtual Type for the column. The available types are Text, Number, and Currency, with each type offering different editing options depending on its characteristics.

   Learn more about editing virtual column types >

4. Click the Save button to save the settings and verify the newly added virtual column.

Added Virtual Column