utility

Boolean

Converts the given value to a true/false. This conversion is equivalent to JavaScript !!value . Function signature BOOLEAN(value: String|Number|Boolean) => Boolean Examples

Updated on : 06 Jun 2022

Default_file_extension

Returns the default file extension associated with the given MIME type. Function signature DEFAULT_FILE_EXTENSION(mime-type: String) => String Examples

Updated on : 18 May 2022

Default

If the given value is non-empty (as per the definitions in the EMPTY function), returns the given value, otherwise return the given default. Function signature DEFAULT(value: , default: ) => Boolean|Number|Object|Array Examples

Updated on : 18 May 2022

Encode_for_url

URL encodes the given text, escaping any special characters. Returns the encoded text. Function signature ENCODE_FOR_URL(value: String) => String Examples

Updated on : 18 May 2022

Encode_JSON

Converts a given JSON-format input (number, true/false, list, object) into a text. Function signature ENCODE_JSON(value: String|Number|Boolean|Object|Array, spaces: Number) => String Examples

Updated on : 18 May 2022

Filename_is_image

Returns true if the given text is or has a file extension that belongs to a web-compatible image MIME type. Function signature FILENAME_IS_IMAGE(fileextension: String) => Boolean Examples

Updated on : 18 May 2022

IF

If the first parameter evaluates to true , returns the second parameter. Otherwise, returns the third parameter. Function signature IF(condition: Boolean, truevalue: , falsevalue: ) => String Examples

Updated on : 18 May 2022

Integer

Converts the given input value to an integer number. Texts are parsed, and numbers are rounded down. If the input is already an integer, it is returned as-is. Any other values, and invalid texts, result in null value. Function signature INTEG...

Updated on : 18 May 2022

IS_EMAIL

Returns true if the given text is a valid email address, otherwise returns false . Function signature IS_EMAIL(value: String) => Boolean Examples

Updated on : 18 May 2022

IS_Empty

Returns true or false based on if the given value is empty. Returns true if the parameter is one of the following values: an empty text an empty list an object without properties null undefined NaN For any other value...

Updated on : 18 May 2022

IS_Equal

Returns true if the both parameter values are equal, otherwise false . Same than using the == operator in formulas. The values are considered equal if they are of the same type and represent the same value. If the values are objects or arrays...

Updated on : 18 May 2022

IS_NULLY

Returns true if the given value is either null or undefined . For any other value, returns false . Function signature IS_NULLY(value: Json) => Boolean Examples

Updated on : 18 May 2022

IS_Number

Returns whether or not the given value is number. This returns true if the parameter type is number . For any other value this returns false . Note that this returns false for numeric texts. Function signature IS_NUMBER(value: Json) => ...

Updated on : 18 May 2022

IS_Same

Returns true if the both parameter values are exactly the same, otherwise false . Same than using the === operator in formulas. Similar to IS\_EQUAL except that it does not perform deep comparison for objects and lists. Instead objects ar...

Updated on : 18 May 2022

IS_Undefined

Returns true if the parameter is undefined value. For all other values, including null , this returns false . Function signature IS_UNDEFINED(value: Json) => Boolean Examples

Updated on : 18 May 2022

Mime_type_is_image

Returns true if the given MIME type belongs to a web-safe image format, and false otherwise. Function signature MIME_TYPE_IS_IMAGE(mimetype: String) => Boolean Examples

Updated on : 18 May 2022

Mime_type

Returns the MIME type of the given file extension, or null if it cannot be determined. Also works with full paths and filenames, where it's assumed the text ends in an extension. Function signature MIME_TYPE(fileextension: String) => String ...

Updated on : 18 May 2022

NOT

Returns true if the given parameter is false , otherwise returns false . Equivalent to the ! operator. Function signature NOT(value: Boolean) => Boolean Examples

Updated on : 18 May 2022

Number

Converts the value to a number, if it is not already a number. Numeric texts are parsed. Any other values, and invalid texts, result in null value. Function signature NUMBER(value: String|Number) => Number Examples

Updated on : 18 May 2022

Numeric_base

Converts the given number into a text representation in another base. Function signature NUMERIC_BASE(number: Number, base: Number) => String Examples

Updated on : 18 May 2022

String

Converts the given value to a text. If the value is a number, returns its text representation, possibly including decimals. True/false values are converted to either "true" or "false" . A null value is converted to an empty text. Function sig...

Updated on : 18 May 2022

URL

Converts the given text to an URL-type text. Returns null if the text cannot be converted to an URL. Function signature URL(text: String) => String Examples

Updated on : 18 May 2022

IS_NULL

Returns true if the given parameter is null value. For any other value, including undefined , returns false . Function signature IS_NULL(value: Json) => Boolean Examples

Updated on : 18 May 2022