Formula Functions¶
The format of function usage: groupName\functionName(argument1, argument2, ..., argumentN).
Out-of-the-box functions are listed below.
Functions:
General¶
String¶
- string\concatenate
- string\substring
- string\contains
- string\pos
- string\test
- string\length
- string\trim
- string\lowerCase
- string\upperCase
- string\pad
- string\match
- string\matchAll
- string\matchExtract
- string\replace
- string\split
Datetime¶
- datetime\today
- datetime\now
- datetime\format
- datetime\date
- datetime\month
- datetime\year
- datetime\hour
- datetime\minute
- datetime\dayOfWeek
- datetime\diff
- datetime\addMinutes
- datetime\addHours
- datetime\addDays
- datetime\addWeeks
- datetime\addMonths
- datetime\addYears
- datetime\closest
Number¶
- number\format
- number\abs
- number\power
- number\round
- number\floor
- number\ceil
- number\randomInt
- number\parseInt
- number\parseFloat
Entity¶
- entity\isNew
- entity\isAttributeChanged
- entity\isAttributeNotChanged
- entity\attribute
- entity\setAttribute
- entity\clearAttribute
- entity\attributeFetched
- entity\addLinkMultipleId
- entity\hasLinkMultipleId
- entity\removeLinkMultipleId
- entity\setLinkMultipleColumn
- entity\isRelated
- entity\sumRelated
- entity\countRelated
- entity\getLinkColumn
Record¶
- record\exists
- record\count
- record\findOne
- record\findMany
- record\findRelatedOne
- record\findRelatedMany
- record\attribute
- record\fetch
- record\relate
- record\unrelate
- record\create
- record\update
- record\delete
- record\relationColumn
- record\updateRelationColumn
Env¶
Password¶
Array¶
- array\includes
- array\push
- array\length
- array\at
- array\join
- array\indexOf
- array\removeAt
- array\unique
Object¶
Language¶
Json¶
Ext¶
- ext\account\findByEmailAddress
- ext\currency\convert
- ext\email\send
- ext\email\applyTemplate
- ext\markdown\transform
- ext\sms\send
- ext\pdf\generate
- ext\user\sendAccessInfo
- ext\calendar\userIsBusy
- ext\acl\checkEntity
- ext\acl\checkScope
- ext\acl\getLevel
- ext\acl\getPermissionLevel
- ext\oauth\getAccessToken