📄️ Formula Overview
A formula is an operational expression composed of functions, operators, and values.You can use a formula to reference the fields to be calculated and get expected output values.
📄️ Formula Writing Tips
📄️ Summary of Formula Functions and Operators
📄️ Introduction to the Operators
Operators are an important part of formulas that represent the rules of operations between data.
📄️ Numeric Functions
A numeric operation function is a type of function in a formula that can operate on data of a numeric type.
📄️ Text Functions
A text function is a type of function in a formula that can operate on data of text type.
📄️ Logical Functions
A logical function is a type of function in a formula that performs logical operations on data.
📄️ Date Functions
Date function is a type of function in a formula that can operate on date-type data.
📄️ Arrays and Other Functions
The array function is a function type in a formula that can operate on data of the array type.
📄️ Time Unit Descriptors Supported by Date Functions
📄️ DATETIME_FORMAT() Supported Date Formats
Formats the date as the specified string.
📄️ SET_LOCAL() Supported Language Descriptions
📄️ Do Basic Math with Formulas
When we design a datasheet, we need to use basic addition, subtraction, multiplication and division operations in many cases. How to make two fields of data perform simple operations in the AITable?How to perform mixed operations on multi-field data?This article will describe in detail.
📄️ Use Formulas for Basic Logical Judgment
When we design tables, we need to use logic in many cases. Is "income" greater than "expenditure"? Is "age" less than "18"? Does "progress" equal "100%"? ...