The Upper function converts any input string into uppercase letters. It helps ensure uniform text formatting for display, comparison, or data storage. When to Use: Use this function when you want to standardize user input or backend values by converting them to uppercase—especially useful in validations, searches, or ID comparisons. Common Use Cases: Concept You… Continue reading Upper
Category: V2
Date Diff Hours
Introduction This function subtracts one date from another date and returns a numeric value in hours, such as 2 hours, 6 hours, 10 hours, or 15 hours. While calculating the difference between two dates, you can provide static dates, or the DATEDIFFHOURS function can dynamically pick dates from attributes and elements. Use Cases You can use the DATEDIFFHOURS function… Continue reading Date Diff Hours
Date Diff Months
Introduction This function subtracts one date from another date and returns a numeric value in months, such as 2 months, 5 months, 15 months, or 36 months. While calculating the difference between two dates, you can provide static dates, or the DATEDIFFMONTHS function can dynamically pick dates from attributes and elements. Use Cases You can… Continue reading Date Diff Months
Date Diff Years
Introduction This function subtracts one date from another date and returns a numeric value in years, such as 2 years, 5 years, 15 years, or 24 years. While calculating the difference between two dates, you can provide static dates, or the DATEDIFFYEARS function can dynamically pick dates from attributes and elements. Use Cases You can use the DATEDIFFYEARS function… Continue reading Date Diff Years
Months Dif From Now
The MonthsDifFromNow function calculates the number of full months between a given date and the current system date. It helps track the duration of time passed in months, especially useful in workflows involving installment plans, tenure-based validation, or reminders. When to Use Use the MonthDifFromNow function when you need to: This is particularly useful in… Continue reading Months Dif From Now
Years Dif From Now
The YearsDifFromNow function calculates the difference in full years between a given date and the current system date. It is commonly used to determine durations such as age, account tenure, or time passed since a particular event. When to Use Use YearsDifFromNow when you need to: This function is ideal for banking and financial workflows… Continue reading Years Dif From Now
Current Date Time
Introduction This function gets the system’s or device’s date and time in a specific format. When you configure this function, you need to define the format of the date and time. Later, you can display the current date and time in the element on the application or store it in the attribute. Examples and Use… Continue reading Current Date Time
Static
The Static function assigns a constant value—such as a number, string, integer, boolean, or other primitive type—to a field within a workflow. Unlike dynamic values that depend on user input or logic, a static value stays the same unless manually changed. It is commonly used to initialize fields with default or predefined values during form… Continue reading Static
List of vDesigner Functions
FUNCTION NAME FUNCTION NAME FUNCTION NAME FUNCTION NAME FUNCTION NAME AVG SUM PRODUCT DIVIDE POW FACTORIAL SORT ISNULLOREMPTY MAX MIN ISALPHANUMERIC DATEDIFFHOURS FLOOR CONCAT SUBSTR HEX CONTAINS UPPER LOWER ISALPHA CURRENTDATETIME CAST ROUNDUP ROUNDDOWN MOD LOG STATIC CEILING TRUNCATE FORMATNUMBERLOCALIZEDPATTERN ADDMINUTES ADDSECONDS HOUR MINUTES SUBHOURS SUBMINUTES SUBSECONDS WEEKDAY LEFT RIGHT ISNUMERIC TRIM MID CONTAINSALL LEN… Continue reading List of vDesigner Functions
Different Selections in Smart Selector
In the smart selector, you can select an item to configure a property, implement a business rule, map an item (for example, an element or entity) for data manipulation, and others. You can select an item in the smart selector as follows: Selecting an Element You can select an element to define a condition in the… Continue reading Different Selections in Smart Selector