Formula

📄️ 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.

📄️ Summary of Formula Functions and Operators

Classification

📄️ 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

Introduction

📄️ DATETIME_FORMAT() Supported Date Formats

Formats the date as the specified string.

📄️ SET_LOCAL() Supported Language Descriptions

SET_LOCALE()

📄️ 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%"? ...