logologo
Get Started
Guide
Development
Plugins
API
English
简体中文
Get Started
Guide
Development
Plugins
API
English
简体中文
logologo
Overview

Data sources

Data source manager
Main data source

External data sources (Databases)

Overview
External MySQL
External MariaDB
External PostgreSQL
External MSSQL
External Oracle
Main vs External Databases
REST API data source
KingbaseES data source

Collections

Overview
General collection
Inheritance collection
File collection
Tree collection
Calendar collection
Comment collection
Expression collection
SQL collection
View collection

Collection fields

Overview
Field Validation

Basic

Single text
Long text
Phone
Email
URL
Integer
Number
Percent
Password
Color
Icon

Choices

Checkbox
Select
Multiple select
Radio group
Checkbox group

Media

Markdown
Markdown (Vditor)
Rich text
Attachment (Relationship)
Attachment (URL)

Date & Time

Overview
Date & time (with timezone)
Date & time (without timezone)
Unix timestamp
Date (without time)
Time

Geometry

Point
Line
Circle
Polygon

Advanced

UUID
Nano ID
Sort
Formula
Sequence
JSON
Collection select
Encryption

System info

Created at
Updated at
Created by
Last updated by
Space
Table OID

Associations

Overview
One to one
One to many
Many to one
Many to many
Many to many (array)

Development

Overview
Previous PageOverview
Next PageSingle text

#Field Validation

To ensure data accuracy, security, and consistency in collections, NocoBase provides field validation functionality. This feature consists of two main parts: rule configuration and rule application.

#Rule Configuration

20250819181342

NocoBase system fields integrate Joi rules, with support as follows:

#String

Joi string types correspond to the following NocoBase field types: Single Line Text, Long Text, Phone, Email, URL, Password, and UUID.

#Common Rules

  • Min length
  • Max length
  • Length
  • Pattern
  • Required

#Email

20250819192011

View more options

#URL

20250819192409

View more options

#UUID

20250819192731

View more options

#Number

Joi number types correspond to the following NocoBase field types: Integer, Number, and Percentage.

#Common Rules

  • Greater than
  • Less than
  • Max value
  • Min value
  • Multiple

#Integer

In addition to common rules, integer fields additionally support integer validation and unsafe integer validation.

20250819193758

#Number & Percentage

In addition to common rules, number and percentage fields additionally support precision validation.

20250819193954

#Date

Joi date types correspond to the following NocoBase field types: Date (with timezone), Date (without timezone), Date only, and Unix timestamp.

Supported validation rules:

  • Greater than
  • Less than
  • Max value
  • Min value
  • Timestamp
  • Required

#Association Fields

Association fields only support required validation. Note that required validation for association fields is currently not supported in sub-form or sub-table scenarios.

20250819184344

#Applying Validation Rules

After configuring field rules, the corresponding validation rules will be triggered when adding or modifying data.

20250819201027

Validation rules also apply to sub-table and sub-form components:

20250819202514

20250819202357

Note that in sub-form or sub-table scenarios, required validation for association fields does not take effect.

20250819203016

#Differences from Client-Side Field Validation

Client-side and server-side field validation are applied in different scenarios, with significant differences in implementation and rule trigger timing, so they need to be managed separately.

#Configuration Method Differences

  • Client-side validation: Configure rules in edit forms (as shown in the figure below)
  • Server-side field validation: Set field rules in Data Source → Collection Configuration

20250819203836

20250819203845

#Validation Trigger Timing Differences

  • Client-side validation: Triggers validation in real-time as users fill in fields, displaying error messages immediately.
  • Server-side field validation: Validates on the server side before data entry after data submission, with error messages returned through API responses.
  • Application scope: Server-side field validation takes effect not only during form submission but also triggers in all scenarios involving data addition or modification, such as workflows and data imports.
  • Error messages: Client-side validation supports custom error messages, while server-side validation does not currently support custom error messages.