Formula Overview

The following tables organize these formulas by category, such as text, time, array, logical, math, and user functions, so you can quickly find the right one for forms, reports, or data preparation.

Text Functions

Function name	Description	Form	Report	Data preparation
ARRAYGET	Returns the value at the specified position in a dataset.	✅	❌	❌
CONCATENATE	Joins multiple text strings into a single text string.	✅	❌	❌
LEFT	Returns the specified number of characters starting from the first character of a text string. If the text is shorter than the specified count, returns the original text.	✅	✅	✅
RIGHT	Returns the specified number of characters starting from the last character of a text string.	✅	✅	✅
LEN	Returns the number of characters in a text string.	✅	❌	❌
LOWER	Converts all uppercase letters in a text string to lowercase.	✅	✅	✅
UPPER	Converts all lowercase letters in a text string to uppercase.	✅	✅	✅
MID	Returns the specified number of characters from a text string, starting at the specified position.	✅	✅	✅
PINYINHEADCHAR	Returns the first letter of the Pinyin for each Chinese character in a string, in uppercase.	✅	❌	❌
REPLACE	Replaces part of a text string with a different text string, based on the specified number of characters.	✅	✅	✅
REPT	Repeats a text a specified number of times.	✅	❌	❌
RMBFORMAT	Formats a number as RMB currency.	✅	❌	❌
SEARCH	Returns the starting position of text1 within text2.	✅	✅ (similar to POS)	✅ (similar to POS)
SPLIT	Splits text into an array using the specified delimiter. Use with ARRAYGET to retrieve a character at a specific position.	✅	❌	❌
TEXT	Formats a value as text.	✅	❌	❌
TRIM	Removes leading and trailing spaces from a string, while preserving single spaces between words.	✅	❌	❌
UUID	Generates a unique string and assigns it to a single-line input field.	✅	❌	❌
VALUE	Converts text into a number. Typically used when data has already been entered and needs to be recalculated.	✅	✅ (similar to VAL)	✅ (similar to VAL)
STRINGTONUMBER	Converts a text-type number into a Numerical type.	❌	✅	❌
LEFTTRIM	Removes leading spaces from <Field> and returns the result.	❌	✅	✅
RIGHTTRIM	Removes trailing spaces from <Field> and returns the result.	❌	✅	✅
CONCAT	Concatenates multiple fields into a single string.	❌	✅	✅
SPLITPART	Splits a string by the specified delimiter into N substrings (N equals the number of delimiters + 1).	❌	✅	✅
NUMBERTOSTRING	Converts Numerical data into a string.	❌	✅	✅

Time Functions

Function name	Description	Form	Report	Data preparation
CASCADEDATEINTERVAL	Calculates the number of days between the start and end dates in a date range picker.	✅	❌	❌
CASCADEDATEINTERVALV2	Returns the number of days between the two dates in a date range.	✅	❌	❌
DATE	Converts a Unix timestamp into a Date object.	✅	❌	❌
DATEDELTA	Adds or subtracts a specified number of days from a given date.	✅	❌	❌
DAY	Returns the day of a date.	✅	❌	❌
DAYBEGIN	Returns the Unix timestamp of the specified date component with hours, minutes, and seconds set to zero.	✅	❌	❌
DAYEND	Returns the Unix timestamp of the specified date component with hours, minutes, and seconds set to the maximum.	✅	❌	❌
DAYS	Returns the number of days between two dates.	✅	❌	❌
DAYS360	Returns the number of days between two dates based on a 360-day year.	✅	❌	❌
HOUR	Returns the hour of a date.	✅	❌	❌
ISOWEEKNUM	Returns the week number of a specified date within its year.	✅	❌	❌
MINUTE	Returns the minute of a date.	✅	❌	❌
MONTH	Returns the month of a date.	✅	❌	❌
NETWORKDAYS	Calculates the number of workdays between two specified dates.	✅	❌	❌
NOW	Returns the current time. Same as the TODAY function.	✅	✅	✅
SECOND	Returns the second of a date.	✅	❌	❌
SYSTIME	Returns the current server time.	✅	❌	❌
TIME	Returns the decimal number of a specific time.	✅	❌	❌
TIMESTAMP	Converts a Date object into a Unix timestamp. Typically used to convert the Date object returned by a date formula into a Unix timestamp for assigning to a Date component.	✅	❌	❌
TODAY	Returns today’s date.	✅	❌	❌
WEEKNUM	Returns the week number of a specific date.	✅	✅ (similar to WEEK)	✅ (similar to WEEK)
WORKDAY	Returns the date that is N workdays away from a specific date. Weekends are excluded by default, and workdays can be further defined using holidays.	✅	❌	❌
YEAR	Returns the year of a date.	✅	❌	❌
YEARBEGIN	Returns the first date of the year for a given date.	✅	❌	❌
YEAREND	Returns the last date of the year for a given date.	✅	❌	❌
DATEFORMAT	Formats a date as a string.	❌	✅	✅
STRINGTODATE	Converts a text-type value into a date.	❌	✅	✅
DATEDIFF	Returns the difference between Time Field 1 and Time Field 2 at the specified time granularity.	❌	✅	✅
DATEADD	Adds <offset> at <time granularity> to <Time Field>.	❌	✅	✅
QUARTER	Returns the quarter of the year for a date. Fiscal year: 1 = fiscal year (starting April), 0 = calendar year.	❌	✅	✅
FROMUNIXTIME	Converts a Unix timestamp (unixtime) into a date value.	❌	✅	✅

Array Functions

Function name	Description	Form	Report	Data preparation
ArrayToString	Converts an array into a string.	❌	✅	✅
StringToArray	Parses a string into an array.	❌	✅	✅
ArrayLength	Returns the length of an array.	❌	✅	✅
ArrayCat\|	Returns the concatenation of multiple arrays.	❌	✅	✅

Logical Functions

Function name	Description	Form	Report	Data preparation
EQ	Tests for equality.	✅	❌	❌
NE	Tests for inequality.	✅	❌	❌
AND	Returns true when all conditions are met.	✅	❌	❌
OR	Returns true when any one of the conditions is met.	✅	❌	❌
NOT	Negates a condition.	✅	❌	❌
XOR	Exclusive OR (a specific logical evaluation in computer science).	✅	❌	❌
FALSE	Returns the boolean value false.	✅	❌	❌
TRUE	Returns the boolean value true.	✅	❌	❌
GE	Greater than or equal to.	✅	❌	❌
LE	Less than or equal to.	✅	❌	❌
GT	Greater than.	✅	❌	❌
LT	Less than.	✅	❌	❌
IF	Conditional evaluation.	✅	❌	❌
ISEMPTY	Checks whether a field is empty.	✅	❌	❌
ISNULL	Checks whether the value of a component within a subform is empty, or whether the value of a multi-select field is empty.	✅	❌	❌
HASEMPTYTEXT	Checks whether the array value submitted by a component within a subform contains an empty string.	✅	❌	❌
TIMECOMPARE	Compares two times. Returns true if Date Picker 1 is later than Date Picker 2, otherwise false.	✅	❌	❌
NUMBERCOMPARE	Compares two numbers. Returns true if Numerical Component 1 > Numerical Component 2, otherwise false.	✅	❌	❌
CASEWHEN	Similar to the CASE WHEN syntax in SQL.	❌	✅	✅

Math Functions

Function name	Description	Form	Report	Data preparation
COUNT	Returns the total number of records submitted for a specified form.	✅	✅	❌
ADD	Sums the values of multiple fields.	✅	❌	❌
AVERAGE	Returns the arithmetic mean of a set of numbers.	✅	✅ (AVG)	❌
MAX	Returns the largest value in a set of numbers.	✅	✅	❌
MIN	Returns the smallest value in a set of numbers.	✅	✅	❌
ABS	Returns the absolute value of a negative number.	✅	❌	❌
ROUND	Rounds a decimal number to the specified number of digits.	✅	❌	✅
CEILING	Rounds a number up, away from zero, to the nearest multiple of significance.	✅	❌	❌
FLOOR	Rounds a number down, toward zero, to the nearest multiple of significance.	✅	❌	❌
INT	Rounds a number down to the nearest integer.	✅	❌	❌
LOG	Returns the logarithm of a number to a specified base.	✅	❌	❌
MOD	Returns the remainder after dividing two Numerical components.	✅	❌	✅
POWER	Returns the result of a Numerical component raised to a power.	✅	❌	❌
FIXED	Rounds a number to the specified number of decimal places, formats it in decimal notation, and returns the result as a string.	✅	❌	❌
SQRT	Returns the positive square root of the value of a Numerical component.	✅	❌	❌
SUM	Adds all numbers passed as arguments and returns the sum.	✅	✅	❌
PRODUCT	Returns the product as a double-precision floating-point value.	✅	❌	❌
SUMPRODUCT	Multiplies corresponding elements in the given arrays and returns the sum of those products.	✅	❌	❌
LARGE	Returns the k-th largest value in a dataset.	✅	❌	❌
SMALL	Returns the k-th smallest value in a dataset.	✅	❌	❌
COUNTDISTINCT	Returns the count unique values result for <Field>. [Excluded fields] are not involved in the cross calculation.	❌	✅	❌
ParseDouble	Casts a string or integer to a float.	❌	❌	✅
Parseint	Casts a string or float to an integer.	❌	❌	✅

Set Functions

Function name	Description	Form	Report	Data preparation
DIFFERENCESET	Returns the difference of two sets.	✅	❌	❌
INTERSECTIONSET	Returns the intersection of two sets.	✅	❌	❌
SUBSET	Checks whether the second set is a subset of the first.	✅	❌	❌
UNIONSET	Returns the union of two sets.	✅	❌	❌

Validation Functions

Function name	Description	Form	Report	Data preparation
ARRAYREPEATED	Checks whether an array contains duplicates.	✅	❌	❌
EXIST	Checks whether a value exists in a given set.	✅	❌	❌
EXACT	Compares two strings and returns whether they are exactly the same (case-sensitive).	✅	❌	❌

User Functions

Function name	Description	Form	Report	Data preparation
USER	No-argument mode: User() returns the currently signed-in user. With argument: User(level) returns the manager of the currently signed-in user; level indicates the manager level.	✅	❌	❌
USERFIELD	Auto-fills basic information based on a User search field.	✅	❌	❌
DIRECTOR	Returns the name of the manager of the currently signed-in user.	✅	❌	❌
EMPLOYEE	Returns the corresponding array of User information objects (the underlying value of the User component).	✅	❌	❌
GETUSERNAME	Returns the name of the currently signed-in user.	✅	❌	❌
LOGINUSER	Signed-in user.	✅	❌	❌
LOGINUSERWORKNO	Returns the unique employee ID (employee UserID) of the currently signed-in user.	✅	❌	❌
DEPTNAME	Returns the department information of the specified user by userId.	✅	❌	❌

Advanced Formula Functions

Function name	Description	Form	Report	Data preparation
DELETE	Deletes data from the target form.	✅	❌	❌
INSERT	Inserts data from the current form into the target form.	✅	❌	❌
UPDATE	Updates records in the target form that match the specified conditions.	✅	❌	❌
UPSERT	Inserts or updates data in the target form.	✅	❌	❌

FAQs About Formulas

1. In an EQ condition, the component used for comparison in the target form must be the first argument of EQ. EQ is used as a comparison condition. The component used for comparison in the target form must be placed as the first argument of EQ. 2. In an EQ condition, the component used for comparison in the target form cannot be wrapped in another formula. Note: EQ must be followed by the component being compared, not by a formula directly. If needed, add a formula after the component used for comparison. 3. Commas, parentheses, and other punctuation must be in English. 4. Only supported components can be used as comparison conditions. Components that can be used as evaluation conditions: Single-line text, Multi-line text, Select, Dropdown select, and Date. Other components are not supported at this time. 5. Values cannot be assigned to unsupported components. Components that support assignment: Only components of the same type can be assigned to each other. Supported components include Single-line text, Multi-line text, Numerical, Select, Dropdown select, Checkbox, Dropdown checkbox, Cascading select, Date, Date range, Image upload, Attachment, User, and Address. Other components are not supported at this time. 6. Components of different types cannot be assigned to each other. Note: Only components of the same type can be assigned to each other. For example, a Numerical component cannot assign a value to an Image upload component. See the table below for details:

Source Component/Formula	Components that can be assigned
Single-line text	Single-line text
Multi-line text	Multi-line text
Numerical	Single-line text Multi-line text Numerical
Select	Select Dropdown select
Dropdown select	Select Dropdown select
Checkbox	Checkbox
Dropdown checkbox	Dropdown checkbox
Cascading select	Cascading select
Date	Date
Date range	Date range
Image upload	Image upload
Attachment	Attachment
User	User
Address	Address
Text function	Single-line text Multi-line text

7. Use AND for the (and) logic in comparison conditions. The (or) logic is not supported at this time. 8. Business association formulas do not currently support string comparisons in conditions. Use the IF formula to evaluate first, then apply the business association formula. 9. Why does a business rule using an IF condition not take effect? When configuring a business association formula, if you use the IF formula for evaluation first, the IF condition must reference a main-table field. Note: The IF must be placed as the outermost evaluation; otherwise, it will not take effect. 10. “App configuration error, please contact the Admin” After configuring a business association formula, if the error “App configuration error, please contact the Admin” appears when submitting data, it means the target columns used for comparison and for value population have not been added as search fields. Add the target or comparison field to the search fields on the data management page of the target form. 10.1 Steps: 10.1.1 Locate the query condition settings on the data management page of the target form. 10.1.2 Check whether the target form fields are included in the search. If not, add them via the participating search fields settings. 10.1.3 On the settings page, add the target column as a search field under fuzzy search, then click Execute now. 11. Main condition configuration error This error occurs when the sub-condition is placed incorrectly. You must first match on a field from the main table. 12. Sub-condition configuration error. Only one detail record can be updated at a time. If the data matched in the target form is main-table data, place it in the main condition and connect it with AND. 13. When the target column in the matching condition is subform data, the error “The target column is not in the details being updated” appears after configuring the formula. Change the target column to a main-table field. 14. Parameter format mismatch When configuring a business association rule formula, the “Parameter format mismatch” prompt appears. Check whether the component title has been modified via code to include a line break. If the component title contains a line break, the field will display on multiple lines when configuring the formula and will trigger an error. 15. Issues related to the execution order of business association rules and integration & automation 15.1 How is execution ordered when business association rules and integration & automation are used together? Currently, business association rules and integration & automation follow independent execution logic. Each runs in its own execution order, and the overall order is not controllable. If mixed, the same target form may be updated by two task scheduling systems in an unexpected order, leading to incorrect business results — especially for complex processes such as inventory management with both increases and decreases. We recommend using YiDA’s integration & automation for syncing between business processes. 15.2 How is execution ordered when an integration & automation node contains multiple business association rules? Business association rules currently support multiple rule entries, but due to product limitations, the execution order between rules cannot be selected. To control the execution order, use Create, Update, Delete, and other [data nodes] in integration & automation instead. These nodes support ordering and let you view execution records in [Run logs]. Refer to the screenshots below for detailed settings. 16. What is the difference between the pre-edit value and the post-edit value of a form? When you configure a business association rule for a form in edit state, both a pre-edit value and a post-edit value are available. The difference is as follows: If the value of Form Field A is [Watermelon] and you change it to [Peach], the pre-edit value is [Watermelon] and the post-edit value is [Peach]. This is typically used when you need to modify the original target form value after editing. 17. What are the usage limits for advanced functions? YiDA business rule functions currently support the following usage limits:

Core function	Purpose	Usage limit
INSERT	Inserts data from the current Form into the target Form.	1. When batch import triggers a business association rule that inserts into a target form (the main table), there is no per-field record limit (we recommend importing no more than 1,000 records at a time, as larger imports may run slowly). Batch import has a file size limit of 20 MB. 2. Subform insert into main table.
UPDATE	Updates records in the target Form that match the specified conditions.	1. When the target is a main-table field, up to 100 records can be updated per operation. Exceeding this limit causes a submission failure. 2. Target is subform data.
UPSERT	Inserts or updates data in the target Form.	1. When the target is main-form data, up to 100 records can be updated per operation. Exceeding this limit causes a submission failure. 2. Target is subform data.
DELETE	Deletes data from the target Form.	1. When the target is main-form data, up to 100 records can be deleted per operation. 2. Target is subform data.

18. Why does a business rule not execute after a new field is added to the form? When a new field is added to the target form, existing historical records do not yet contain the new field, so they cannot be updated. Edit and save each historical record so the new field is loaded, then it can be updated normally. Batch import or update can also resolve this. 19. Why does a formula fail to run when a Date component is used as the evaluation condition? Using a Date component as an evaluation condition is not recommended. The current value returned is a Unix timestamp, which is inaccurate for use as an evaluation condition. You can assign the value of the Date component to a Single-line text field and use that Single-line text as the evaluation condition instead. 20. When are business rules triggered? Data created by integration & automation does not currently trigger business rules.

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

Text Functions

Time Functions

Array Functions

Logical Functions

Math Functions

Set Functions

Validation Functions

User Functions

Advanced Formula Functions

FAQs About Formulas

​Text Functions

​Time Functions

​Array Functions

​Logical Functions

​Math Functions

​Set Functions

​Validation Functions

​User Functions

​Advanced Formula Functions

​FAQs About Formulas

Text Functions

Time Functions

Array Functions

Logical Functions

Math Functions

Set Functions

Validation Functions

User Functions

Advanced Formula Functions

FAQs About Formulas