# Add, edit and delete fields

> Add fields to a data table, change their settings and type, reorder them and delete them safely. Lists every field type in the Add Field window.

Source: https://tadabase.com/docs/data/fields-overview  
Status: Verified Nov 17, 2026. Checked against the current product

Fields are the columns of a data table. Each field holds one kind of value, such as a name, a date or a price, and its type decides how the value is entered, checked, shown and calculated.

Add fields in the Data Builder, then change their settings, order and type as your app grows.

## Add a field

1. **Open the table** In the builder, open **Data Builder** and select the table.
2. **Open the Fields tab** Click the **Fields** tab.
3. **Click Add New Field** Click **Add New Field**. The **Add Field** window lists every field type by category, with a description and a preview of the type you select.
4. **Pick a type** Click a field type, for example **Text**, then click **Add and Configure**.
5. **Name and save it** Enter a **Name**, set the options for the type, and click **Save**.

![The Add Field window with the field types grouped under Text, Personal, Number, Date, Option, Equation and Files, and the preview of the selected type on the right](https://tadabase.com/docs-shots/data-fields-add-field-menu.webp)

**Description** is for builders only: app users never see it.

Connection fields are not in the **Add Field** window. Add them from the table's **Connections** tab with **Add New Connection**; see [Connection fields](https://tadabase.com/docs/data/connection-fields).

## Field types

The **Add Field** window groups the field types like this. Each type links to its own page.

| Category | Field types |
| --- | --- |
| Text | [Text, Long Text, Rich Text](https://tadabase.com/docs/data/text-fields), [JSON](https://tadabase.com/docs/data/json-field), [Link](https://tadabase.com/docs/data/link) |
| Personal | [Person Name, Email, Phone Number, Signature](https://tadabase.com/docs/data/personal-fields), [Address](https://tadabase.com/docs/data/address) |
| Number | [Number, Currency, Rating, Slider](https://tadabase.com/docs/data/number-fields) |
| Date | [Date, Time, Date & Time, Date Range](https://tadabase.com/docs/data/date-fields) |
| Option | [Checkbox, Radio, Select, Multi-Select, Decision Box](https://tadabase.com/docs/data/option-fields) |
| Equation | [Date Formula](https://tadabase.com/docs/data/date-formula), [Number Formula](https://tadabase.com/docs/data/number-formula), [Text Formula](https://tadabase.com/docs/data/text-formula), [Equation](https://tadabase.com/docs/data/equation), [Rollup](https://tadabase.com/docs/data/rollup), [Dynamic](https://tadabase.com/docs/data/dynamic-field) |
| Files | [Attachments](https://tadabase.com/docs/data/attachments-files) |

- **Dynamic** appears only when your plan includes Dynamic fields.
- **Count**, **Maximum**, **Minimum**, **Average** and **Sum** are no longer in the menu: they were replaced by [Rollup](https://tadabase.com/docs/data/rollup), which does the same calculations on connected records. Existing fields of those types keep working.
- **File** and **Image** were replaced by [Attachments](https://tadabase.com/docs/data/attachments-files). Existing File fields keep working, but you can no longer add new File or Image fields.
- Every table already has an [Auto Increment](https://tadabase.com/docs/data/auto-increment) record number, so it is not in the menu.

## Edit a field

Open a field's settings in either of these ways:

- On the **Fields** tab, click the field's row.
- On the **Records** tab, double-click the field's column header.

Change the settings and click **Save**. The settings page also shows where the field is used in your app; see [Field Usage](https://tadabase.com/docs/data/field-usage).

## Reorder fields

On the **Fields** tab, drag a field by its handle (**Drag to reorder**) to a new position. The new order is saved when you drop it.

## Change a field's type

On a saved field's settings page, the field type is shown at the top right. When the type can be changed, it opens a list of the types you can switch to. Pick one and confirm with **Change**.

| Current type | Can change to |
| --- | --- |
| Text, Long Text, Rich Text, Email | Any other type in this row |
| Text, Long Text | Also **JSON**, when every stored value is valid JSON |
| JSON | **Long Text** only |
| Number, Currency, Phone Number, Rating, Slider | Any other type in this row |
| Date, Time, Date & Time | Any other type in this row |
| Checkbox, Radio, Select, Multi-Select | Any other type in this row |

Other types, such as Link, Person Name, Address, Signature, Decision Box and the Equation types, cannot be changed. Create a new field instead.

> **Check before you change:** Values that don't fit the new type may be cut short or cleared. For example, Rich Text stores HTML, so changing it to Text shows the HTML tags as text. Before you confirm, the window lists the places in your app that use the field and may stop working.

## Delete a field

1. **Open the field** Open the field's settings from the **Fields** or **Records** tab.
2. **Click Delete** Click **Delete** at the bottom of the settings.
3. **Check what it affects** If the field is used elsewhere, the window groups the uses into **Blocks delete** (fix these first), **Will break** (type the field name to confirm) and **Removed for you** (cleaned up for you).
4. **Confirm** Click **Delete field**, or confirm the delete prompt.

The field and its data move to [Deleted Fields](https://tadabase.com/docs/data/deleted-fields), where you can restore them for 30 days. The message after the delete also has an **Undo** link.

You can't delete a field when:

- It is the display field of a connection from another table. Change the display field in that table first.
- It is the table's only field. Add another field first.

Some built-in fields have no **Delete** button.

## Character limits

Each field type is stored in a database column with a fixed size. These are the limits that matter in practice:

| Field type | Maximum length |
| --- | --- |
| Text | 50, 100 or 255 characters, set by **Max Character Length** |
| Long Text, Rich Text | No limit you will reach in normal use |
| JSON | 256 KB per value |
| Email | 255 characters |
| Phone Number | 50 characters |
| Person Name | Title 10 characters; First, Middle and Last Name 100 characters each |
| Address | Address and Address Line 2: 300 characters each; City 100; State 50; Country 50; Zip 20; Latitude and Longitude 15 each |
