# 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.

<figure><img src="https://1781349671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKyXRCFh0c08ryiUFvyMV%2Fuploads%2FJlIeF2qJefrYmD3Bhg10%2Fimage.png?alt=media&#x26;token=9b24dd10-5d15-47a8-b038-e01c732ba352" alt=""><figcaption></figcaption></figure>

2. **While working with an existing table that you have already created or connected to:**&#x20;

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

<figure><img src="https://1781349671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKyXRCFh0c08ryiUFvyMV%2Fuploads%2FNAYFAwCz44bcl9uUGKpF%2Fimage.png?alt=media&#x26;token=165b9326-52f1-438a-8405-ecc33dae6088" alt=""><figcaption></figcaption></figure>

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.&#x20;

* [**Visual column:**](https://docs.powertable.com/explore-powertable/working-with-powertable/column-setup/add-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](https://docs.powertable.com/explore-powertable/working-with-powertable/column-setup/add-visual-column/multi-select-relationship-column), [reference columns](https://docs.powertable.com/explore-powertable/working-with-powertable/column-setup/add-visual-column/reference-column), [relation columns](https://docs.powertable.com/explore-powertable/working-with-powertable/column-setup/add-visual-column/relation-column), and button-type columns.
* [**Formula column:**](https://docs.powertable.com/explore-powertable/working-with-powertable/column-setup/add-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:**](https://docs.powertable.com/explore-powertable/working-with-powertable/column-setup/add-database-column) These are columns that are directly added to the source database via PowerTable.&#x20;


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.powertable.com/explore-powertable/working-with-powertable/column-setup/adding-columns-overview.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.