🧮 Formula Templates
Formula templates for flavors of the "Formula" type
Sum and number formulas
- abs - Calculate absolute value
- asNumber - Display value as a number
- floor - Rounding a value down to the nearest whole number
- ceil - rounding up to the next whole number
- round - Round a number to a certain precision
- pow - calculates the value of the base to the power of the exponent
Text Formulas
- trim - Remove spaces at the beginning and end
- lower - Convert string to lower case letters
- length - Determine the length of a character string
- startsWith - Check whether a string starts with another string
- endsWith - Check whether a string ends with another string
- replace - Replace text
Date and time formulas
- year - Output the year of a date
- date - date conversion
- shortDate - Creating a Short Date Format
- formatDate – Formatting a date
- toTimestamp - returns the UNIX timestamp for the specified date.
- fromTimestamp - Convert a UNIX timestamp to a date
Button Formulas
- Create an interactive button (createButton)
- OpenURL - Open a URL
- OpenMail - Creation of a mail window
- SetProcessMessage - Display message in process dialog
- Control state of the button (0/1) with if conditions
- JSONPackage - Creating a JSON object
Variable and Data Manipulation
- shortenGUID - removes all hyphens from a specified GUID
- workflowStatus - Output GUID of a workflow status
- encodeURI - URI encoding of strings
- getUserName - Determine the user name
- getUserNamedEMail - Determination of user name and e-mail
- fromParent - Query values of higher-level tasks