Conga Product Documentation

Welcome to the new doc site. Some of your old bookmarks will no longer work. Please use the search bar to find your desired topic.

download

Formula Functions

The following options are available from the Functions drop-down list in the Saved Formulas window:

Date

Function

Javascript Notation

Definition

Add X Days

(new Date(…)).addDays(…)

Add a specified number of days to a date/time field.

Add X Hours

(new Date(…)).addHours(…)

Add a specified number of hours to a date/time field.

Add X Minutes

(new Date(…)).addMinutes(…)

Add a specified number of minutes to a date/time field.

Add X Months

(new Date(…)).addMonths(…)

Add a specified number of months to a date/time field.

Add X Weeks

(new Date(…)).addWeeks(…)

Add a specified number of weeks to a date/time field.

Add X Years

(new Date(…)).addYears(…)

Add a specified number of years to a date/time field.

Day of Month (1-31)

… .getDate()

Returns the day of month for the specified date.

Day of Week (0-6)

… .getDay()

Returns the zero-based day of the week (0=Sunday, 6=Saturday).

Hour of Day (0-23)

… .getHours()

Returns the zero-based hour for the specified date.

Is After

… .isAfter(…)

Returns true if the first date occurs after the second date. If a second date is not specified, Now is used.

Is Before

… .isBefore(…)

Returns true if the first date occurs before the second date. If a second date is not specified, Now is used.

Is Between

… .between(…,…)

Returns true if the specified date is between or equal to the specified start and end dates.

Is Blank

… == null

Checks if a reference is to an empty grid cell. It returns true or false.

Is Equal To

… === …

Checks if a numeric argument is equal in value to a second numeric argument. If so, it returns true.

Is In Next X

….inNext(…numberOf…,"…DaysWeeksMonthsOrYears…")

Returns true if the date occurs within the next specified number of days, weeks, months, or years of the current date.

Is In Previous X

….inLast(…numberOf…,"…DaysWeeksMonthsOrYears…")

Returns true if the date occurs within the prior specified number of days, weeks, months, or years of the current date.

Is Not Blank

… != null

Checks if a reference is to a populated grid cell. It returns true or false.

Is Not Equal To

… !== …

Checks if a numeric argument is not equal in value to a second numeric argument. If so, it returns true.

Is Today

(…).between(Date.today(), Date.parse("tomorrow"))

Returns true if date value is todays date.

Is Weekday

… .isWeekday()

Returns true if the date is a weekday (Monday-Friday).

Minutes (0-59)

… .getMinutes()

Returns the zero-based number of minutes past the hour, for the specified date.

Month (0-11)

… .getMonth()

Returns the zero-based month (0=January, 11=December) of the specified date.

Now

(new Date())

Returns the current date and time.

Today

(Date.today())

Returns the current date.

Value

(new Date(…year…,…month…, …day…,…hour…,…minutes…))

Creates a new date with the specified year, month, day, hours and minutes.

Year

… .getFullYear()

Returns the year of the specified date.

For additional information see: https://github.com/datejs/Datejs

Format

Function

Javascript Notation

Definition

As Currency

kendo.format("{0:c}", …)

Formats a numeric value as currency with a dollar sign, for example: $1234.56.

As Date

kendo.format("{0:d}", …)

Formats a numeric value as a date in the form m/d/yyyy.

As DateTime

kendo.format("{0:g}", …)

Formats a numeric value as a date and time in the form M/d/yyyy h:mm tt.

As Decimal

kendo.format("{0:n}", …)

Formats a numeric value as a floating-point number, for example: 1234.56.

As Number

kendo.format("{0:n0}", …)

Formats a numeric value as an integer, for example: 1234.

As Time

kendo.format("{0:hh:mm tt}", …)

Formats a numeric value as time in the form hh:mm tt.

Logic

Function

Javascript Notation

Definition

And

… && …

Checks whether all arguments are true. If so, it returns true.

Group Selected

(…)

Logically groups a statement for order of operations.

If

(…if…) ? (…then…) : (…else…)

Checks whether a condition is met. It returns one value if true and another value if false.

Is Blank

… == null

Checks if a reference is to an empty grid cell. It returns true or false.

Is Equal To

… === …

Checks if a numeric argument is equal in value to a second numeric argument. If so, it returns true.

Is Greater Than

… > …

Checks if a numeric argument is greater than a second numeric argument. If so, it returns true.

Is Less Than

… < …

Checks if a numeric argument is less than a second numeric argument. If so, it returns true.

Is Not Blank

… != null

Checks if a reference is to a populated grid cell. It returns true or false.

Is Not Equal To

… !== …

Checks if a numeric argument is not equal in value to a second numeric argument. If so, it returns true.

Not

!(…)

Checks whether a condition is not met. If so, it returns true.

Or

… || …

Checks whether any of the arguments are true. If so, it returns true. If all arguments are false, it returns false.

Number

Function

Javascript Notation

Definition

Multiply

… * …

Multiplies two numeric values.

Add

… + …

Adds two numeric values.

Subtract

… - …

Subtracts two numeric values.

Divide

… / …

Divides two numeric values.

Absolute Value

Math.abs(…)

Returns the absolute value of a number (the number without its sign).

Is Blank

… == null

Checks if a reference is to an empty grid cell. It returns true or false.

Is Equal To

… === …

Checks if a numeric argument is equal in value to a second numeric argument. If so, it returns true.

Is Greater Than

… > …

Checks if a numeric argument is greater than a second numeric argument. If so, it returns true.

Is Less Than

… < …

Checks if a numeric argument is less than a second numeric argument. If so, it returns true.

Is Not Blank

… != null

Checks if a reference is to a grid cell that is populated. It returns true or false.

Is Not Equal To

… !== …

Checks if a numeric argument is not equal in value to a second numeric argument. If so, it returns true.

Max

Math.max(…1…,…2…,…)

Returns the maximum value in a set of values.

Min

Math.min(…1…,…2…,…)

Returns the minimum value in a set of values.

Random (0-1)

Math.random()

Returns a random number greater than or equal to 0 and less than 1, evenly distributed.

Round

Math.round(…)

Rounds a number to a specified number of digits.

Round Down

Math.floor(…)

Rounds a number down, to the nearest integer or to the nearest multiple of significance.

Round Up

Math.ceil(…)

Rounds a number up, to the nearest integer or to the nearest multiple of significance.

Exponent

Math.pow(…base…,…exp…)

Returns the result of a number raised to a power.

Square Root

Math.sqrt(…)

Returns the square root of a number.

Text

Function

Javascript Notation

Definition

Append

… + …

Appends two text strings.

Contains

(… .indexOf(…) > 0)

Returns true if a string contains a specified value.

Index Of

…indexOf(…substring…)

Returns the index if a string appears in the value, or -1 if the value does not contain the string.

Is Blank

… == null

Checks if a reference is to an empty grid cell. It returns true or false.

Is Equal To

… === …

Checks if a text string is equal in value to a second text string. If so, it returns true.

Is Not Blank

… != null

Checks if a reference is to a grid cell that is populated. It returns true or false.

Is Not Equal To

… !== …

Checks if a text string is not equal in value to a second text string. If so, it returns true.

Replace

… .replace(…find…,…replace…)

Replaces part of a text string with a different text string.

Substring

… .substr(…startIndex…,…length…)

Returns a substring of the value starting at a specified index and with a specified length.

Value

"…"

A specified text value.

Advanced

Function

Javascript Notation

For Each

Object.each(…list…, function(item){ // Use item });

Function (required)

function(){ // comments return …; }()

If

if (…test…) { …then… } else { …else… }

Regular expression

/…regex…/.test(…string…)

Variable

var …x… = …y…;