Using formula fields

A formula field is a field type in AI Table — use rich function expressions for flexible data calculations.

Create a formula field

Click the + icon to the right of the AI Table header bar, pick Formula as the field type.

Edit formula

Click Edit formula — the formula editor opens.

Edit the formula directly in the top input box. In the Formula edit tab, reference fields or pick functions by category. In the AI generate formula tab, generate a formula from natural language — details: Generate formulas with AI.

Concepts

Term	Meaning
Field	The value of a column at a given row, used in formula computation
Whole-column field	The collection of values for an entire column, used in formula computation
Brackets	Used in formulas to reference AI Table tables or fields
Operator	Logical or arithmetic symbol used in a formula
Function	Produces an expected output via a specific computation rule
Argument	Number or text that participates in formula computation
String	A sequence of text used in formula computation
Array	A collection of values

Common operators

Type	Operator	Meaning
Arithmetic	`+`	Add two values
	`-`	Subtract two values
	`*`	Multiply two values
	`/`	Divide two values
Text concat	`&`	Concatenate two strings; concat number with text when one is numeric
Logical	`>`	Greater than
	`>=`	Greater than or equal
	`<`	Less than
	`<=`	Less than or equal
	`=`	Equal
	`!=`	Not equal
	`&&`	AND
	`	`	OR

Formula function reference Generate formulas with AI

FAQ

Formula FAQ Formula error codes

View component Formula function reference

Getting Started

AI Table basic operations

Working with fields

Working with forms

Working with views

Working with dashboards

Automation workflows

More

Application mode

Formulas

Advanced permissions

Plugins

Scenarios

Create a formula field

Edit formula

Concepts

Common operators

Read more

FAQ

​Create a formula field

​Edit formula

​Concepts

​Common operators

​Read more

​FAQ

Create a formula field

Edit formula

Concepts

Common operators

Read more

FAQ