Actions on Field

This article explains how to perform various actions on a field- like rename, change field type, default, field width, record height, show/hide.

สั่งงานด้วย NocoAI

• Rename [old field name] to [new field name]
• Change [field name] to a [date] field
• Delete the [field name] field
• Change [Amount] to a currency field in [euros]

Fields context menu

Fields context menu can be accessed by clicking on the dropdown icon (🔽) next to the field name.\

Edit

Rename field

1. Open the field context menu
2. Click on Edit option.
3. Enter new field name as required in the Field Name field.
4. Click on Save Field button.

Change field type

1. Open the field context menu
2. Click on Edit option.
3. Select new field type from the Field Type dropdown.
4. Click on Save Field button.

Change default value

1. Open the field context menu
2. Click on Edit option.
3. Enter new default value in the Default Value field. To disable, click on x icon.
4. Click on Save Field button.

Change field width

To adjust the width of the field, hover over the field edge and drag to adjust the width.

Hide field

1. Open the field context menu
2. Click on Hide Field option

หมายเหตุ: * Hidden fields are not visible in the table view, but will still be accessible for Formulas, Sort, Filter, etc.

• To un hide a field, use Toolbar > Fields menu
• Fields can also be marked as hidden from Toolbar > Fields menu

Set as Display value

1. Open the field context menu
2. Click on Set as Display Value option.

Refer to Display Value for more details.

Sort Ascending

1. Open the field context menu
2. Click on Sort Ascending option.

Sort Descending

1. Open the field context menu
2. Click on Sort Descending option.

Duplicate field

1. Open the field context menu
2. Click on Duplicate option.

Duplicated field sans the data will be created with suffix _copy in its name & will be placed to the right of the original field.

Insert after a field

1. Open the field context menu
2. Click on Insert after option.

New field will be created to the right of the original field.

Insert before a field

1. Open the field context menu
2. Click on Insert before option.

New field will be created to the left of the original field.

Delete field

หมายเหตุ: This action cannot be undone

To delete a field, follow the steps below:

1. Open the field context menu by clicking on dropdown icon (🔽) .
2. Click on Delete .
3. Confirm the deletion by clicking on Delete Field on the confirmation modal.

Add / edit field description

Field description can be added by clicking on the Add Description button on the field creation modal or by clicking on the Edit Description button from the field context menu.

Description for a field will be visible as a tooltip when hovering over the info icon next to the field name.

The same info icon also appears next to the field name in the expanded record and in the New record form. Hover over it to read the field description. The description is visible to viewers as well, and it appears on public and shared views, making it a convenient way to give people filling in a record additional context about a field.

Set field as unique

To set a field as unique, follow the steps below:

1. Open the field context menu by clicking on dropdown icon (🔽) .
2. Click on Edit field .
3. Toggle on the Unique values only option.
4. Click on Save Field button.

Note that, this feature is only available for certain field types like Single line text, Email, Number, etc. Find more details on setting a field as unique in Unique Fields article.

Related pages

• Primary Key : This article explains what a primary key is and how it is used in NocoDB.
• Display Value : This article explains how to set the display value for a table and its significance.
• Multi-Field Editor : Understanding use of multi-field editor in NocoDB!
• Field Summary : Understanding the field summary bar in NocoDB!