> For the complete documentation index, see [llms.txt](https://docs.fabricplan.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/configure-column-properties/general.md).
# General
The **General** section allows you to configure the data type, validation rules, constraints, and default values for a column.
### Configure general properties
To configure the general properties:
1. Select **Setup** > **Columns**.
2. The column configuration window opens. Select the pencil icon next to the column name or double-click the column name.
3. Select the **General** tab in the side panel.
You can configure the following properties:
* [Input type](#input-type)
* [Constraints](#constraints)
* [Default value](#default-value)
### Input type
Use the **Input Type** property to specify how data is entered, stored, and displayed in a column.
Powertable sheet supports a wide range of input types. The available input types are determined by the underlying SQL data type assigned to the column.
For example:
* Numeric data types such as **INT**, **BIGINT**, **FLOAT**, and **DECIMAL** support input types such as **Number**, **Single Select**, **Decimal**, **Currency**, **Percent**, **Percent Complete**, and **Rating**.
* Date and time data types support input types such as **Date Time** and **Single Select**.
* Text-based data types such as **VARCHAR** and **NVARCHAR** support input types such as **Text**, **Email**, **URL**, **Phone Number**, **Person** (name or email), **Image** (URL-based), **Single Select**, and **Check Box**.
* Boolean data types support input types such as **Check Box**.
Depending on the input type you have chosen, you can set additional properties. For example, you can set minimum and maximum values for numeric input types and a list of selectable values for single-select columns.
For a complete list of supported column types and their details, see [Supported column types](/documentation/plan/powertable-sheets/reference/supported-column-types.md).
### Constraints
Use the **Constraints** section to limit input values and configure field validation.
#### Minimum and maximum
Use **Minimum** and **Maximum** to define the allowed range of values for a column. Values outside the configured range are not accepted.
These constraints are available for the input types of **Number**, **Currency** and **Date Time**.
Existing table values remain unchanged. When you enter values outside the configured range, powertable sheet displays a message indicating the permitted limits.
{% hint style="info" %}
#### Note
You can configure either a minimum value, a maximum value, or both.
{% endhint %}
For **Date** and **Date Time** columns, you can define a valid date range or a date-time range. Values outside the configured range are not accepted.
#### Field validation
Use **Field Validation** to control the type of values that users can enter in a **text** column.
The following validation options are available:
* **Any value**
* **Numeric**
* **Alphanumeric**
* **Non Numeric**
* **Regex**
When **Regex** is selected, specify a regular expression pattern to validate user input. Values that do not match the configured validation rule are rejected.
#### Other number properties
For decimal input type, you can configure the default number of decimal places to be displayed.
Select **Allow Negative Numbers** to allow negative entries in the column.
### Default value
Use **Default Value** to automatically populate a column when new rows are created. This helps ensure that new records already contain a valid initial value and reduces manual data entry. The column values in the existing records remain unchanged.
Default values can be set using a **manual** static value or a **formula**.
#### Manual value
To configure a static default value:
1. Select **Manual**.
2. Enter the required value.
In the following example, **NA** is configured as the default value for the **Product Description** column.
When a new row is inserted, the configured default value is automatically populated, and you can later modify it when required.
#### **Reset to default on update**
Enable **Reset to Default on Update** to automatically reset the column to its configured default value whenever the record is updated.
When this option is enabled:
* Existing values remain unchanged until the record is updated.
* The value is reset to the configured default when you modify other fields in the same record.
In this example, changing the product name automatically resets the product description to the default value NA.
Additional default value options are available for specific input types:
* **Person** - Use a user's name or email address as the default value.
* **Single Select** - Select a default value from the configured list of options.
* **Check Box** - Configure default values such as True/False, 1/0, Yes/No, or any custom text by selecting **Checked** or **Unchecked** values.
#### Formula
Use **Formula** to calculate default values dynamically by using formulas.
Powertable sheet supports formulas and functions for generating default values. These values are automatically recalculated based on the underlying reference data.
Formula-based default values are supported for the following input types:
* Number
* Decimal
* Text
* Date Time
* Person
* Email
#### **Recalculate data on update**
Enable **Recalculate data on update** to have the column automatically reset to its calculated default value whenever the record is updated.
When this option is enabled:
* Existing values remain unchanged until the record is updated.
* When you modify another field in the same record, the value is reset to the formula-derived default.
In this example, changing the product size calculates the default value and resets the product price to it.
---
# 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 dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:
```
GET https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/configure-column-properties/general.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.
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.