Below is a complete list of expressions in the Tulip platform and the areas that each is available for.
Click on the expression name to navigate to its documentation.
| Function | Description | Available in |
|---|---|---|
| ABS() | Returns the absolute value of the input | Apps, Automations |
| ADD_TIME() | Adds a given duration unit to a given time. If a tz identifier is provided, uses that time zone instead of the local time zone. | Apps, Automations |
| ARRAY_AVG() | Returns the average of a given numeric list | Apps, Automations |
| ARRAY_CONCAT() | Concatenates any number of lists of a single type into a single list of that type | Apps, Automations |
| ARRAY_INDEX_OF() | Returns the index of the first occurrence of the given value in the given list. If not found, returns -1. | Apps, Automations |
| ARRAY_MAX() | Returns the maximum of a given numeric list | Apps, Automations |
| ARRAY_MIN() | Returns the minimum of a given numeric list | Apps, Automations |
| ARRAY_STDEV_POPULATION() | Returns the standard deviation of the population of a given numeric list | Apps, Automations |
| ARRAY_STDEV_SAMPLE() | Returns the standard deviation of the sample of a given numeric list | Apps, Automations |
| ARRAY_VALUE_AT_INDEX() | Returns the value at the given index in the given list. If the index is out of bounds, returns null. | Apps, Automations |
| ARRAYCONTAINS() | Returns true if the given value is in the given list, false otherwise | Apps, Automations |
| AVERAGE() | Returns the average of its argument | Analysis |
| AVERAGEFILTERED() | Returns the average of its argument, filtered to completions matching the given condition | Analysis |
| AVG() | Returns the average of its argument | Analysis |
| AVGFILTERED() | Returns the average of its argument, filtered to completions matching the given condition | Analysis |
| BADGE_ID_TO_USER() | Converts a badge id to a user object | Apps |
| CEIL() | Rounds up to the nearest integer | Apps, Automations, Analysis |
| CONTAINS() | Returns whether or not a string contains a given substring | Apps, Automations |
| COS() | Returns the cosine of the given input in radians | Apps, Automations |
| COUNT() | Returns the number of completions matching the given condition | Analysis |
| COUNTOFCOMPLETIONS() | Returns the total number of completions. | Analysis |
| COUNTUNIQUE() | Returns the number of unique results for the given value | Analysis |
| CURRENTDATEANDTIME() | Returns the current timestamp as a Datetime value. Note: CURRENTDATEANDTIME() is only supported in analyses set to My timezone. |
Analysis |
| DATETIMETOTEXT() | Formats a date to a string. If a tz identifier is provided, uses that time zone instead of the local time zone. | Apps, Automations, Analysis |
| ENCODE_URI_COMPONENT() | Returns a URL-encoded string version of a URI component. | Apps, Automations |
| ENCODE_URI() | Returns a URL-encoded string version of a URI. | Apps, Automations |
| FILETOTEXT() | Converts File into text | Apps, Automations |
| FIND() | Finds the starting index of the given substring inside the given string | Apps, Automations, Analysis |
| FLOOR() | Rounds down to the nearest integer | Apps, Automations, Analysis |
| GETDECIMALPLACES() | Returns the number of decimal places in a given number | Apps |
| HEX_TO_INT() | Returns the numeric representation of the given hexadecimal string | Apps, Automations |
| IF() | Returns the second argument if the first argument is true, or the third argument if the first argument is false | Apps, Automations, Analysis |
| INT_TO_HEX() | Returns the hexadecimal representation of the given number | Apps, Automations |
| INTERVAL_TO_SECONDS() | Returns the length of an interval in seconds | Apps, Automations, Analysis |
| ISNULL() | Returns true if the argument is null, otherwise false | Apps, Automations, Analysis |
| LEFT() | Returns a substring containing n characters starting from the left | Apps, Automations, Analysis |
| LEN() | Returns the length of the input | Apps, Automations, Analysis |
| LINK() | Returns the first non-null argument. Takes any number of same-type arguments. | Apps, Automations, Analysis |
| LOWERCASE() | Converts string to be all lowercase | Apps, Automations, Analysis |
| MAP_TO_BOOLEAN_LIST() | Converts an object list to base list for the given key | Apps, Automations |
| MAP_TO_INTEGER_LIST() | Converts an object list to base list for the given key | Apps, Automations |
| MAP_TO_NUMBER_LIST() | Converts an object list to base list for the given key | Apps, Automations |
| MAP_TO_TEXT_LIST() | Converts an object list to base list for the given key | Apps, Automations |
| MAX() | Returns the maximum of the given values | Apps, Automations |
| MAXFILTERED() | Returns the maximum of its argument, filtered to completions matching the given condition | Analysis |
| MAXIMUM() | Returns the maximum of its argument | Analysis |
| MAXIMUMFILTERED() | Returns the maximum of its argument, filtered to completions matching the given condition | Analysis |
| MID() | Returns a substring containing n characters starting from start | Apps, Automations, Analysis |
| MIN() | Returns the minimum of the given values | Apps, Automations |
| MINFILTERED() | Returns the minimum of its argument, filtered to completions matching the given condition | Analysis |
| MINIMUM() | Returns the minimum of its argument | Analysis |
| MINIMUMFILTERED() | Returns the minimum of its argument, filtered to completions matching the given condition | Analysis |
| NULLIF() | Returns null if the first argument equals the second argument, otherwise returns the first argument | Apps, Automations, Analysis |
| POW() | Returns the first argument raised to power of the second argument | Apps, Automations |
| RAND() | Generates a random decimal number between 0 and 1 | Apps, Automations |
| RANDBETWEEN() | Generates a random number between (and including) the two numbers provided | Apps, Automations |
| RANDOM_COLOR() | Generates a random color | Apps, Automations |
| RANDOMSTRING() | Returns a random 17-character string | Apps, Automations |
| REGEX_MATCH() | Returns a list of matches to the regular expression | Apps, Automations, Analysis |
| REGEX_REPLACE() | Replaces content in text using a regular expression | Apps, Automations |
| RGB() | Returns a color of the specified red, green, and blue components | Apps, Automations |
| RGBA() | Returns a color of the specified red, green, blue, and alpha components | Apps, Automations |
| RIGHT() | Returns a substring containing n characters starting from the right | Apps, Automations, Analysis |
| ROUND() | Rounds a number to the specified number of decimal places. If decimal places are negative or not specified, rounds to the nearest integer. | Apps, Automations, Analysis |
| ROUNDDATETIME() | Truncates a date to the given unit. If a tz identifier is provided, uses that time zone instead of the local time zone. | Apps, Automations, Analysis |
| SECONDS_TO_INTERVAL() | Converts seconds into an interval | Apps, Automations, Analysis |
| SIN() | Returns the sine of the given input in radians | Apps, Automations |
| SPLIT() | Splits text on the given delimiter | Apps, Automations, Analysis |
| SQRT() | Returns the square root of a number | Apps, Automations |
| SUBSTITUTE() | Replaces text from given string with another string | Apps, Automations, Analysis |
| SUBTRACT_TIME() | Subtracts a given duration unit from a given time. If a tz identifier is provided, uses that time zone instead of the local time zone. | Apps, Automations |
| SUM() | Returns the sum of its argument | Analysis |
| SUMFILTERED() | Returns the sum of its argument, filtered to completions matching the given condition | Analysis |
| TAN() | Returns the tangent value of the input in radians | Apps, Automations |
| TEXTTOBOOLEAN() | Parses text into a boolean. “y”, “yes”, “t”, “true”, and “on” (and any capitalized variants) are recognized as true, and “n”, “no”, “f”, “false”, and “off” are recognized as false | Apps, Automations, Analysis |
| TEXTTODATETIME() | Parses a datetime from text and format. If a tz identifier is provided, uses that time zone instead of the local time zone. | Apps, Automations, Analysis |
| TEXTTOFILE() | Converts text into a File | Apps, Automations |
| TEXTTOIMAGEURL() | Converts text into an image URL | Apps, Automations |
| TEXTTOINTEGER() | Parses text into a integer | Apps, Automations, Analysis |
| TEXTTONUMBER() | Parses text or a timestamp into a number | Apps, Automations, Analysis |
| TOPLAINTEXT() | Parses anything into text. Numbers are treated as strings in objects and lists to support precision. | Apps, Automations |
| TOTEXT() | Parses anything into text | Apps, Automations, Analysis |
| TRIM() | Trims the given character(s) from the ends of the given string | Apps, Automations, Analysis |
| UPPERCASE() | Converts string to be all uppercase | Apps, Automations, Analysis |
| USER_ID_TO_USER() | Converts a user id to a user object | Apps |