Number formulas

In Ruby, Fixnum refers to integers, e.g. 9, 10, 11, while Float refers to decimals, e.g. 1.75.

AppConnect supports a variety of number formulas. Formulas in AppConnect are whitelisted Ruby methods, and therefore not all Ruby methods are supported. You can always reach out to us to add additional formulas to the whitelist. Syntax and functionality for these formulas are generally unchanged. Take note that most formulas will return an error and stop the job if it tries to operate on nulls (expressed as nil in Ruby), except for present?, presence and blank?.

Arithmetic operations

In the cases of arithmetic operations, whether the values are of integer types or decimal (float) types are important. Formulas will alway stick to the types given as input, and the returned result will be of the most precise type.

For example:

• If integer values are provided, an integer value will be returned.

• If float values are provided, a float value will be returned.

• If both float and integer values are provided, a float value will be returned, as that is more precise.

The add (+) operator

This operator allows the addition of operands on either side. This section talks about number arithmetics. Date arithmetics is possible as well.

Sample Usage

The subtract (-) operator

This operator subtracts the right hand operand from the left hand operand. This section talks about number arithmetics. Date arithmetics is possible as well.

Sample Usage

The multiply (*) operator

This operator multiplies the operands on either side.

Sample Usage

The divide (/) operator

Divides left hand operand by right hand operand.

Sample Usage

The exponential (**) operator

Left hand operand to the power of the right hand operand.

Sample Usage

The modulo (%) operator

Divides left hand operand by right hand operand and returns the remainder.

Sample Usage

Other number formulas

abs

Returns the absolute (positive) value of a number.

Syntax

number.abs

• number - An input integer or float.

Sample usage

round

Rounds off a numerical value. This formula returns a value with a specified number of decimal places.

Syntax

number.round(offset)

• number - An input integer or float.

• offset - (optional) The number of decimal places to return, you can provide negative values. If not specified, this formula will return the number with no decimal places.

Sample usage

Conditionals

blank?

This formula checks the input and returns true if it is non a value number or if it is null.

Syntax

Input.blank?

• Input - An input datapill. It can be a string, number, date, or datetime datatype.

Sample usage

How it works

If the input is null or an empty string, the formula will return false. For any other data, it returns true.

even?

Checks the integer input and returns true if it is an even number.

Syntax

integer.even?

• integer - An input integer.

Sample usage

odd?

Checks the integer input and returns true if it is an odd number.

Syntax

integer.odd?

• integer - An input integer.

Sample usage

is_not_true?

Converts a value to boolean and returns true if the value is not truthy.

Syntax

Input.is_not_true?

• Input - An input number or a string.

Sample usage

How it works

Converts the input into a boolean and returns true if the value is not truthy.

truthy vs falsey

false, nil, 0 and empty strings ("") are falsey, all other numbers and string values are truthy.

is_true?

Converts a value to boolean and returns true if the value is truthy.

Syntax

Input.is_true?

• Input - An input number or a string.

Sample usage

How it works

Converts the input into a boolean and returns true if the value is truthy.

truthy vs falsey

false, nil, 0 and empty strings ("") are falsey, all other numbers and string values are truthy.

present?

This formula will check the input and if there is a value present, it will return true. If the input is nil, an empty string or an empty list, the function will return false.

Syntax

Input.present?

• Input - An input datapill. It can be a string, number, date, or list datatype.

Sample usage

How it works

If the input is null, an empty string or an empty list, the formula will return false. For any other data, it returns true.

Evaluating a list with nil values

• Only an empty list will return false.

[].present? returns false.

• A list with nil and empty string will return true.

[nil,""].present? returns true.

presence

Returns the data if it exists, returns nil if it does not.

Syntax

Input.presence

• Input - An input datapill. It can be a string, number, date, or datetime datatype.

Sample usage

How it works

If the input is null or an empty string, the formula will return nil. For any other data, it returns the orignal input data.

Conversions

ceil

Rounds the input number to the next greater integer or float. You can specify the precision of the decimal digits.

Syntax

number.ceil(precision)

• number - An input integer or float.

• precision - (optional) The number of decimal places to return, you can provide negative values. If not specified, this formula will return the number with no decimal places.

Sample usage

floor

Rounds the input number to the next smaller integer or float. You can specify the precision of the decimal digits.

Syntax

number.floor(precision)

• number - An input integer or float.

• precision - (optional) The number of decimal places to return, you can provide negative values. If not specified, this formula will return the number with no decimal places.

Sample usage

to_f

Converts data to a float (number) datatype.

Syntax

Input.to_f

• Input - An number input data. You can use a string datatype or a integer datatype.

Sample usage

How it works

This formula checks whether the input contains any numbers, if no numbers are found, it returns 0. If the number does not have a decimal point, .0 will be added the number.

to_i

Converts data to an integer (whole number) datatype.

Syntax

Input.to_i

• Input - An number input data. You can use a string datatype or a float datatype.

Sample usage

How it works

This formula checks whether the input contains any numbers, if no numbers are found, it returns 0. If the number has a decimal point, everything after the decimal will be omitted.

Check for integers

You can use this formula to check if a string contains an integer. If the input does not contain any numbers, the formula will return 0.

to_s

Converts data to a string (text) datatype.

Syntax

Input.to_s

• Input - Any input data. You can use number, array, object, or datetime datatypes.

Sample usage

How it works

This formula returns a string representation of the input data.

Quicktip: Output is a string datatype.

A string representation of a list cannot be used in a repeat step.

to_currency

Formats integers/numbers to a currency-style.

Syntax

Input.to_currency

• Input - Any input string.

Sample usage

Advance sample usage

Learn more about advance usage for the to_currency formula. A comma-separated combination of these may be used to achieve the desired currency format. For example:

to_phone

Converts string or number to a formatted phone number (user-defined).

Syntax

Input.to_phone

• Input - Any input string or number.

Sample usage