Logical Functions

The table below summarizes each logical function, along with issues you may encounter when using them.

Function Overview

Function name	Description
EQ	Checks whether two values are equal.
NE	Checks whether two values are not equal.
AND	Returns true when all specified conditions are met.
OR	Returns true when at least one of the specified conditions is met.
NOT	Reverses the logical value of its argument.
XOR	Performs an exclusive OR operation (a specific logical check used in computer science).
FALSE	Returns the logical value false.
TRUE	Returns the logical value true.
GE	Greater than or equal to.
LE	Less than or equal to.
GT	Greater than.
LT	Less than.
IF	Performs a conditional check.
ISEMPTY	Checks whether a field is empty.
ISNULL	Checks whether a component value in a details table is empty, or whether the value of a multi-select box is empty.
HASEMPTYTEXT	Checks whether the array value submitted by a component in a details table contains an empty string.
TIMECOMPARE	Compares two times. Returns true if Date picker 1 is greater than Date picker 2; otherwise, returns false.
NUMBERCOMPARE	Compares two numbers. Returns true if Numerical component 1 > Numerical component 2; otherwise, returns false.

Introduction to Functions

Logical functions are a category of functions that return either the logical value true or the logical value false.

true: Indicates that the result of the check is true or correct. It can also be represented by 1.
false: Indicates that the result of the check is false or incorrect. It can also be represented by 0.

Common Scenarios

Block Form Submission When a Formula Is Met

Block form submission when the product name equals “Watermelon”. See the following example.

Requisition Quantity Cannot Exceed Stock Quantity

In business scenarios such as inventory management systems and product stock management, you often need to ensure that the requisition quantity does not exceed the stock quantity. See the following example.

Nested IF Functions

Below 60 is Fail; 60 to 89 is Average; 90 and above is Excellent. See the following example.

Getting Started

Quick Start

Form Management

Workflow Design

Report Design

Aggregate Table Design

Portal Design

Custom Pages

Integration & Automation

Cool App

App Management

Platform Management

Internationalization

YiDA Dedicated

Developer Features

Function Overview

Introduction to Functions

Common Scenarios

Block Form Submission When a Formula Is Met

Requisition Quantity Cannot Exceed Stock Quantity

Nested IF Functions

​Function Overview

​Introduction to Functions

​Common Scenarios

​Block Form Submission When a Formula Is Met

​Requisition Quantity Cannot Exceed Stock Quantity

​Nested IF Functions

Function Overview

Introduction to Functions

Common Scenarios

Block Form Submission When a Formula Is Met

Requisition Quantity Cannot Exceed Stock Quantity

Nested IF Functions