call (855) 387-8288
Trackdrive

Formulas

Formulas allow for expanded functionality with leads. Formulas can be nested (one formula within another) to create complex calculations.

Formula Example

substring(value, start, length)

string

A substring is a range of characters within an existing string.

Argument Required Info
value Required The text that will be modified
start Required The position where to start the extraction. First character is at index 0.
length Required The number of characters to extract. Pass -1 to extract the rest of the string.
SUBSTRING("hello world", 6, -1)
=> "world"

strip(value)

string

Returns a copy of the receiver with leading and trailing whitespace removed.

Whitespace is defined as any of the following characters: null, horizontal tab, line feed, vertical tab, form feed, carriage return, space.

Argument Required Info
value Required
STRIP("    hello world   ")
=> "hello world"

split(value, pattern, index)

string

Divides value into substrings based on a delimiter, returning the substring at index.

Argument Required Info
value Required The text that will be modified.
pattern Required The pattern is a String. Its contents are used as the delimiter when splitting str. If pattern is a single space, str is split on whitespace, with leading and trailing whitespace and runs of contiguous whitespace characters ignored.
index Required Index is the index of the split substrings that will be returned. Examples:

SPLIT("John Andrew Smith", ' ', 0) would return "John"
SPLIT("John Andrew Smith", ' ', 1) would return "Andrew"
SPLIT("John Andrew Smith", ' ', 2) would return "Smith"
SPLIT("2019-01-12", '-', 1) would return "01"
SPLIT("John Smith", " ", 1)
=> "Smith"

min(*values)

numeric

Get the smallest numeric value from the set of passed arguments.

Argument Required Info
*values Required This function accepts an unlimited number of numeric values.
MIN(1,2,3,4)
=> 1

max(*values)

numeric

Get the largest numeric value from the set of passed arguments.

Argument Required Info
*values Required This function accepts an unlimited number of numeric values.
MAX(1,2,3,4)
=> 4

sum(*values)

numeric

Get the sum of the numeric values.

Argument Required Info
*values Required This function accepts an unlimited number of numeric values.
SUM(1,2,3,4)
=> 10

avg(*values)

numeric

Get the average of the passed numeric values.

Argument Required Info
*values Required This function accepts an unlimited number of numeric values.
AVG(1,2,3,4)
=> 2.5

count(*values)

numeric

Count the passed values.

Argument Required Info
*values Required This function accepts an unlimited number of numeric values.
COUNT(1,2,3,4)
=> 4

round(value, precision)

numeric

Returns float rounded to the nearest value.

Argument Required Info
value Required The value to be rounded. EG:
ROUND(8.8) => 9
ROUND(8.2) => 8
precision Optional The precision to be used. EG:
ROUND(8.75, 1) => 8.8
ROUND(8.2)
=> 8

rounddown(value, precision)

numeric

Returns float rounded down to the nearest value.

Argument Required Info
value Required The value to be rounded. EG:
ROUND(8.8) => 8
precision Optional The precision to be used. EG:
ROUND(1.234, 2) => 1.23
ROUNDDOWN(1.234)
=> 1

roundup(value, precision)

numeric

Returns float rounded up to the nearest value.

Argument Required Info
value Required The value to be rounded. EG:
ROUND(8.8) => 9
precision Optional The precision to be used. EG:
ROUND(1.234, 2) => 1.24
ROUNDUP(1.234)
=> 2
Waves
Contact TrackDrive

Questions ?

We’re here to help. Call us and speak with a Voice Marketing Cloud Specialist.

Call : (855) 387-8288
Request A Demo

Request A Demo.

See how you can improve your marketing and the customer experience with the Voice Marketing Cloud.

Request a demo