> For the complete documentation index, see [llms.txt](https://docs.powertable.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.powertable.com/explore-powertable/working-with-powertable/column-setup/adding-columns-overview.md).

# 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&amp;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&amp;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:**](/explore-powertable/working-with-powertable/column-setup/add-visual-column.md) These are columns that are added on the visual level and are available only in the PowerTable item. These include [multi-select relationship columns](/explore-powertable/working-with-powertable/column-setup/add-visual-column/multi-select-relationship-column.md), [reference columns](/explore-powertable/working-with-powertable/column-setup/add-visual-column/reference-column.md), [relation columns](/explore-powertable/working-with-powertable/column-setup/add-visual-column/relation-column.md), and button-type columns.
* [**Formula column:**](/explore-powertable/working-with-powertable/column-setup/add-formula-column.md) 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:**](/explore-powertable/working-with-powertable/column-setup/add-database-column.md) These are columns that are directly added to the source database via PowerTable.&#x20;


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

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

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

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

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

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.