Fields

Actions on a NocoDB field: rename it, change its type, default value and width, hide it, sort by it, duplicate, insert, delete and describe it.

The display value is the field that identifies each record in a NocoDB table; learn what it does and how to set it.

The NocoDB field summary shows calculations such as sum, average, minimum and maximum for a field in the footer of a grid view.

Learn about fields in NocoDB tables: field types, default values, descriptions, unique fields, and field actions.

Use the multi-field editor in NocoDB to add, edit, delete, reorder, and hide many fields of a table at one time.

Learn what a primary key is and how NocoDB sets and uses the primary key of a table.

The QR Code field in NocoDB creates a QR code from the value of another field; learn how to create it and which source fields it supports.

Create an Attachment field in NocoDB, upload files to it, and manage the files in the expand modal.

The Barcode field in NocoDB creates a barcode from the value of another field; learn how to create it and which barcode types it supports.

The Button field in NocoDB adds a button to each record that opens a URL, runs a webhook or runs a script, with optional visibility conditions.

The Checkbox field in NocoDB stores boolean values such as yes/no or true/false; learn how to create it and set its icon and color.

The Colour field in NocoDB stores color values as hex codes and shows a color swatch with a built-in color picker.

The GeoData field in NocoDB stores latitude and longitude for a record, with a map editor, place search and Map View support.

Create a Geometry field in NocoDB to store geometric data in a table.

The Rating field in NocoDB shows ratings on a visual scale with a configurable icon, color and maximum value.

Create a Specific DB Type field in NocoDB to use a data type of an external database, with attributes such as Not Null and Primary Key.

The Created Time field in NocoDB shows when each record was created; learn how to show it and how it works.

The Date Time field in NocoDB stores a date and a time in one field; learn how to create it and which date and time formats it supports.

The Date field in NocoDB stores date values; learn how to create it and which date formats it supports, including Jalali formats.

The Duration field in NocoDB stores a length of time; learn how to create it and which duration formats it supports.

The Last Modified Time field in NocoDB shows when a record last changed, for the whole record or for specific fields only.

The Time field in NocoDB stores a time value in a 12-hour format; learn how to create it.

Create and use an Auto Number field in NocoDB to give each record a unique sequential number.

Create and use a UUID field in NocoDB to give each record a unique identifier.

Array functions for NocoDB formula fields: ARRAYSORT, ARRAYUNIQUE, ARRAYCOMPACT and ARRAYSLICE, with syntax and samples.

Conditional expressions for NocoDB formula fields: IF, SWITCH, AND and OR, with syntax and samples.

Date functions for NocoDB formula fields, such as DATETIME_DIFF, DATEADD, NOW, WEEKDAY and DATETIME_FORMAT, with syntax and samples.

Format the result of a NocoDB formula field as a number, date, text or boolean value, with the options for each result type.

The Formula field in NocoDB calculates a read-only value from other fields; learn how to create it and which functions it supports.

System functions and miscellaneous functions for NocoDB formula fields, such as RECORD_ID, with syntax and samples.

JSON functions for NocoDB formula fields, such as JSON_EXTRACT, with syntax and samples.

Numeric functions that you can use in NocoDB formula fields, with syntax and samples.

Numeric, logical and string operators that you can use in NocoDB formula fields.

String functions that you can use in NocoDB formula fields, with syntax and samples.

Create and use a Link to Another Record field in NocoDB to link records in one table to records in another table.

Create and use the deprecated Links field in NocoDB to link records in one table to records in another table.

Create and use a Lookup field in NocoDB to show field values from a linked table in the current table.

Create and use a Rollup field in NocoDB to aggregate field values from linked records.

Create and use a Currency field in NocoDB to store monetary values with a locale and currency symbol.

Create and use a Decimal field in NocoDB to store decimal values with a set precision.

Create and use a Number field in NocoDB to store integer values.

Create and use a Percent field in NocoDB to store percentage values and show them as a progress bar.

Create and use a Multi select field in NocoDB to select multiple options from a predefined list.

Create and use a Single select field in NocoDB to select one option from a predefined list.

Create and use an Email field in NocoDB to store email addresses as clickable links.

Create and use a Long text field in NocoDB to store multiple lines of text.

Create and use a Phone number field in NocoDB to store phone numbers with optional validation.

Create and use a Rich text field in NocoDB to format long text with Markdown.

Create and use a Single line text field in NocoDB to store short text values.

Create and use a Smart text field in NocoDB to give each cell a document-style editor.

Create and use a URL field in NocoDB to store web addresses as clickable links.

Create and use a Created By field in NocoDB to show the user who created a record.

Create and use a Last Modified By field in NocoDB to show the user who last modified a record.

Create and use a User field in NocoDB to assign one or more workspace users to a record.