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
Blog
Seconds Dif From Now
The SecondsDifFromNow function calculates the difference in seconds between a given date-time and the current system date-time. It is useful for precise, second-level time comparisons in real-time operations, validations, or monitoring workflows. When to Use Use SecondsDifFromNow when you need to: It is ideal for scenarios where even minor time gaps matter, such as banking… Continue reading Seconds Dif From Now
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
General Settings
The General Settings menu is a central place in vDesigner 2.0 where users manage core app configurations. It’s divided into two main sections: Basic Section This section handles all foundational settings related to the application. Its key features include: Use this section to configure all high-level app settings. This is how Basic Section may look… Continue reading General Settings
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
Attributes and Attribute IDs
What is an Attribute? An attribute represents a specific piece of data associated with an entity in Data Modeler. It defines the type of information an entity holds, such as text, numbers, images, or colors. Example: Consider an entity called Employee with the following attributes: {“Decimal Tech” :[ { “EmployeeID”: “E001”, “Name”: “John Doe”, “Age”:… Continue reading Attributes and Attribute IDs
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