Math Operators

These are the math operators that can be used within formulas.

+

plus operator combines two numerical values into a sum

Example: TASK.estimatedCost + 22.45

-

minus operator subtracts one numeric value from another to find their difference 

Example: PROJECT.fixedCost - PROJECT.estimatedCost - 1200

/

divide operator splits a numeric value into a specific number of equal parts to determine the quotient

Example: BOOKING.estimatedDuration / 48.0 

*

multiply operator add a numeric value to itself a specific number of times to calculate the product

Example: STAFF.payAmount * 1.5

%

modulo operator divides one numeric value by another and returns the remainder rather than the quotient

Example: PROJECT.estimatedCost % 1000000

Boolean Operators

These are the boolean operators than can be used within formulas.

eq

is equal to the provided value

Example: PROJECT.STAGE.name eq "Completed"

neq

is not equal to the provided value

Example: LOCATION.name neq "Los Angeles"

lt

is less than provided value

Example: ACTIVITY.startTime lt getDate('now')

lte

is less or equal than provided value

Example: TASK.actualCost lte 1500.00

gt

is greater than provided value

Example: BOOKING.estimatedCost gt 500.00

gte

is greater or equal than provided value

Example: REBATE.rebate gte 25.0

inside 

is greater than the first and less than second provided value

Example: STAFF.payAmount inside [50000.00, 100000.00]

outside

is less than the first or greater than the second provided value

Example: PROJECT.estimatedCost outside [150000.00, 200000.00]

between

is greater than or equal to the first and less than the second provided value

Example: TASK.actualCost between [5000.00, 10000.00]

within

is one of values in the list of provided values

Example: STAFF.visaStatus within ['approved', 'pending', 'expired']

without

is not on the list of provided values, array e.g. "1|2|3"

Example: BOOKING.STAFF.name without ['Jane Doe', 'John Citizen', 'Sally Green']

contains

is string of letters inside the text matching provided value

Example: STAFF.name contains 'Johnston'

!contains

is not string of letters inside the text matching provided value

Example: TASK.name !contains 'Compositing'

containsFuzzy

is one word inside the text similar to the provided value

Example: BOOKING.decription containsFuzzy 'animation'

!containsFuzzy

is not one word inside the text similar to the provided value

Example: TASK.NOTE.text !containsFuzzy 'cost'

containsWord

is one word inside the text matching provided value

Example: PROJECT.description containsWord 'VFX'

!containsWord

is not one word inside the text matching provided value

Example: RESOURCE.description !containsWord 'camera'

containsPhrase

is sequence of words matching provided value

Example: TASK.NOTE.text containsPhrase 'has been approved'

!containsPhrase

is not sequence of words matching provided value

Example: BOOKING.description !containsPhrase 'Los Angeles Office'

containsPrefix

is one word inside the text beginning with provided value

Example: TASK.identifier containsPrefix 'COMP-'

!containsPrefix

is not one word inside the text beginning with provided value

Example: ACTIVITY.identifer !containsPrefix 'TRAINING-'

containsRegex

is one word inside the multiple lines text matching regular expression provided value

Example: TASK.identifier containsRegex '^SH\\d{5}$'

!containsRegex

is not one word inside the multiple lines  matching regular expression provided value

Example: PROJECT.identifier !containsRegex '^VFX-\d{7}$'

ending

is string of letters ending the text matching provided value

Example: PROJECT.NOTE.text ending 'See attached PDF'

!ending

is not string of letters ending the text matching provided value

Example: COMPANY.customPreferredCurrency !ending 'dollars'

fuzzy

is entire text similar to the provided value

Example: TASK.name fuzzy 'concept work'

!fuzzy

is not entire text similar to the provided value

Example: BOOKING.name !fuzzy '3D animation'

prefix

is text beginning with the provided value

Example: STAFF.name prefix 'Sally'

!prefix

is not text beginning with the provided value

Example: PROJECT.name !prefix 'GAMEDEV-'

regex

is text matching regular expression of provided value

Example: BOOKING.description regex '(?i)(compositing|animation)'

!regex

is not text matching regular expression of provided value

Example: PROJECT.description !regex '(?i)(games|vfx|animatio'

is

is entire text matching in insensitive case provided value

Example: STAFF.name is 'sally andrews'

has

is string of letters inside the text matching provided value in insensitive case

Example: PROJECT.name has 'animation'

hasEntry

is aggregated list of quantified entries having provided value, e.g. ,["CONTACT.phones", "hasEntry", "home:123"]

Example: STAFF.phones hasEntry 'home:15602987065'

hasEntry

is aggregated list of entries having provided value, e.g. ,["CONTACT.websites", "hasEntry", "janus"]

Example: CUSTOMER.websites hasEntry 'https://nike.com'