EXIST

The EXIST function checks whether currently submitted data duplicates existing historical records.

Supported Product Scenarios

The EXIST function is supported in the following YiDA scenarios.

EXIST does not support duplicate checking for components inside a subform.
When EXIST performs a duplicate check, every component must have a value. If any component is empty, the system does not treat the record as a duplicate.
Components currently supported by EXIST: Single-line text, Multi-line text, Numerical, Select, Dropdown select, Checkbox, Dropdown checkbox, Cascading select, Date, Date range, User, Country, and Department.

EXIST(value1,value2···value5)

Attribute	Required	Description
value1	Yes	The component field to check. Supports checking values across multiple components. Separate the components with commas. Up to five components are supported.

Return value type	Description
Boolean	The comparison result. • true: Duplicate. • false: Not a duplicate.

Use the EXIST() function to check whether a field value already exists, as shown below.

Check whether a field value or a combined field value already exists in the database.