Adding Columns - Overview

With growing business requirements, the need to add new columns to your table can arise more often than not. PowerTable allows you to add new columns to an existing table on the fly to accommodate your changing needs.

A new column can be added to a table in two scenarios:

1. While creating a new table:

The Add Column option comes in handy during the initial table configuration step, using which you can add and configure a new column in addition to the imported columns.

1. While working with an existing table that you have already created or connected to:

You can add a column at any time after creating or connecting to a table using one of the options highlighted below.

In the next sections, we will go over how to add a visual column, a formula column, and a database column to your existing table.

• Visual column: These are columns that are added on the visual level and are available only in the PowerTable item. These include multi-select relationship columns, reference columns, relation columns, and button-type columns.

• Formula column: These are calculated columns that you can include in the table. PowerTable supports a wide range of Excel-like formulas and functions, which you can use to create the calculated columns.

• Database column: These are columns that are directly added to the source database via PowerTable.