All Functions Alphabetically
ABS
Returns the absolute value of a number.
ACOS
Returns the arccosine of a given number.
ACOSH
Returns the hyperbolic arccosine of a given number.
ACOT
Returns the arccotangent of a given number.
ACOTH
Returns the hyperbolic arccotangent of a given number.
ADD_TO_DATETIME
Add units a datetime. Negative values will do the same as SUBTRACT_FROM_DATETIME.
ARABIC
Converts a roman numeral to an arabic number.
ASIN
Returns the arcsine of a given number.
ASINH
Returns the hyperbolic arcsine of a given number.
ASSET_TO_URI
Returns the asset URI for the given asset.
ATAN
Returns the arctangent of a given number.
ATAN2
Returns the arctangent of a given x and y coordinates.
ATANH
Returns the hyperbolic arctangent of a given number.
BASE
Converts a number to a string with the given radix.
BASE64_DECODE
Decodes a string that contains base64 encoded data returning a decoded string. The encoded data must be text.
BASE64_ENCODE
Encode a string as a base64 encoded string.
CEILING
Returns number rounded up to the nearest significance.
COMBIN
Returns the number of combinations for the given number of items.
COMBINA
Returns the number of combinations for the given number of items, with repetitions
CONCAT
Take an arbitrary number of strings and join them together.
CONTAINS
Returns true if certain value is found in the array, false if not.
COS
Returns the cosine of a given number.
COSH
Returns the hyperbolic cosine of a given number.
COT
Returns the cotangent of a given number.
COTH
Returns the hyperbolic cotangent of a given number.
CSC
Returns the cosecant of a given number.
CSCH
Returns the hyperbolic cosecant of a given number.
CURRENCY
Represents a unit of currency, including the amount and currency code.
DATE
Creates a date.
DATE_DELTA
Returns the number of years, months, days between two dates.
DATE_FROM_DATETIME
Get the date from a dateTime.
DATE_FROM_FORMAT
Given a date string return a date.
DATETIME
Combine a date and time into a datetime.
DATETIME_DELTA
Returns the number of years, months, days, hours, minutes, seconds between two datetimes.
DATETIME_FROM_FORMAT
Given a string and format, produce a datetime
DATETIME_FROM_TIMESTAMP
Convert a timestamp into a datetime object
DAY
Returns the day of the month.
DAYS
Returns the number of days between two dates.
DEGREES
Converts radians into degrees.
EVEN
Rounds a number up to the nearest even integer.
EXP
Returns e raised to the power of number.
FACT
Returns the factorial of a number
FACT_FLOAT
Returns the factorial of a floating point number
FLAT
Takes a list of items, and reduces them to a single level list.
FLOOR
Returns number rounded down to the nearest significance.
FORMAT_PHONE
take in a phone number string and format the output to the corresponding format.
FORMAT_CURRENCY
Take a currency and local format and create a formatted string.
FORMAT_DATE
Produce a formatted string from a date object.
FORMAT_DATETIME
Produce a formatted string from a datetime.
FORMAT_NUMBER
Given a number and a local, produce a correctly formatted number string
FORMAT_TIME
Produce a formatted string from a time.
FROM_JSON
Convert a valid JSON string into an Airscript value.
GCD
Returns the greatest common divisor of two or more numbers.
HOUR
Returns the hour of the datetime or time from 0-23.
IDENTIFIER_FROM_ASSET
Returns the identifier string for the given asset.
IF
Use the IF function to do conditional branching.
ISEMAIL
Determines if the given value is a valid email address.
ISEMPTY
Returns TRUE if the object, string, or list is empty, otherwise returns FALSE.
ISEVEN
Determines if a number is even or not.
ISNOTEMPTY
Returns a true if the object, string, or list is NOT empty.
ISNUMBER
Determines if the given value is a number.
ISO_WEEK
Returns the ISO week number of the year. (1-54)
ISODD
Determines if a number is odd or not.
ISPHONE
Determines if the given value is a valid phone number.
ISSTRING
Determines if the given value is a string.
JOIN
Combine a list of strings.
LATLNGDISTANCE
Compute the distance between two lat / long points.
LCM
Returns the least common multiple of two or more numbers.
LENGTH
Return the count of items in the list or the length of a string.
LN
Returns the natural logarithm of a number.
LOG
Returns the logarithm of a number with the given base.
LOWERCASE
Return a new string by converting all capital letters to lowercase.
MAX
Max of all the elements provided.
MERGE_OBJECTS
Combine objects by adding properties of addtional objects to the combination of the previous objects.
MIN
Min of all the elements provided.
MINUTE
Returns the minute of the datetime or time.
MONTH
Returns the month of the year. (1-12)
MROUND
Returns a number rounded to the given multiple
MULTINOMIAL
Returns the ratio of the factorial of a sum of values to the product of factorials.
NOT
Return the revesed logical value of the input boolean.
NOW
Get the current date and time.
ODD
Rounds a number up to the nearest odd integer.
PADSTRING
Pads a string with a given length, if the given string is longer than the length, the original string is returned.
PARSE_CURRENCY
Take a currency string and generate a Currency primitive
PARSE_NUMBER
Converts a string to a number.
PARSE_PHONE
Converts a string to a phone number.
PI
The mathematical constant PI (3.14159265358979).
POWER
Raise a number to a given power
PRODUCT
Return the product of a list of numbers.
RADIANS
Converts degrees into radians.
RANDOM
Return a random number with optional min, max and shouldFloor parameters.
RANGE
Generates a list from the given start number to the given end number.
REPLACE
Replace part of a string with a replacement string.
REPT
Repeats the given string a given number of times.
ROMAN
Converts a number to Roman numerals
ROUND
Rounds a number to the given number of digits.
ROUNDDOWN
Rounds a number down to the given number of digits.
ROUNDUP
Rounds a number up to the given number of digits.
SEC
Returns the secant of a given number.
SECH
Returns the hyperbolic secant of a given number.
SECOND
Returns the second of the datetime or time.
SHUFFLE
Given a list of objects, return the objects in a random order.
SIGN
Determines the sign of a number.
SIN
Returns the sine of a given number.
SINH
Returns the hyperbolic sine of a given number.
SPLIT
Given a string and a separator, return a list of strings broken by the separator.
SQRT
Returns the square root
SQRTPI
Returns the square root of (number * pi)
STRING_COMPARE
Used to compare strings and return their lexical order.
STRING_FIND
Returns the index or -1 of search string found in the string.
STRIP
Strips out the given characters from the string.
SUBSTITUTE
Replaces all occurences of a given string with another.
SUBSTRING
Get the substring of from a string starting at a given index.
SUBTRACT_FROM_DATETIME
Subtract units from the a datetime object. Negative values will do the same as ADD_TO_DATETIME.
SUM
Sum of all the elments provided.
SUMSQ
Returns the sum of squares of the given numbers
TAN
Returns the tangent of a given number.
TANH
Returns the hyperbolic tangent of a given number.
TIME
Creates a time.
TIME_DELTA
Returns the number of hours, minutes, seconds between two times.
TIME_FROM_DATETIME
Get the time from a datetime.
TIME_FROM_FORMAT
Given a date time string and a format return a time.
TIMESTAMP_FROM_DATETIME
Get the value of a datetime in timestamp format.
TITLECASE
Return a string by converting the first character of each space separated word of the input string to upper case. Capital letters in your base string will stop the capitalization.
TO_JSON
Convert an Airscript value into a JSON string.
TODAY
Returns today as a date.
TRIM
Return the leading and trailing whitespace from a string.
TRUNC
Removes the fractional part of a number
TYPEOF
Determines the type of the given value.
UPDATE_DATE
Modify a datetime to a new date.
UPDATE_DATETIME
Modify an input datetime.
UPDATE_DAY
Modify a datetime or date to a new day.
UPDATE_HOUR
Modify a datetime or time to a new hour.
UPDATE_MILLISECOND
Modify a datetime or time to a new millisecond.
UPDATE_MINUTE
Modify a datetime or time to a new minute.
UPDATE_MONTH
Modify a datetime or date to a new month.
UPDATE_SECOND
Modify a datetime or time to a new second.
UPDATE_TIME
Modify a datetime to a new time.
UPDATE_TIMEZONE
Modify a datetime object to a new timezone.
UPDATE_YEAR
Modify a datetime or date to a new year.
UPPERCASE
Return the lowercase representation of a string.
URI_TO_ASSET
Returns the asset for a given asset URI.
URL_DECODE
Decode a URL
URL_ENCODE
Encode a URL.
VALUES
Get the values from all the object's keys.
WEEK
Returns the week number of the year. (1-54)
WEEKDAY
Returns the day of the week. (1-7)
YEAR
Returns the 4-digit year.