List of Main Formulas
This list is not complete but can be used as a reference point when using formulas.
Any parameters placed within
| ADD_TAG | Adds tags to a list. | ADD_TAG ({field}, “values”) |
|---|---|---|
| BOOLEAN | Converts a positive/negative value into a true/false string value. | BOOLEAN({field}[,string si/true, string si/false]) |
| CLEAN_HTML | Removes the HTML tags from a field. | CLEAN_HTML ({field}[, FOR_WEB | FOR_EMAIL]) |
| CLEAN_TEXT | Removes spaces and excess line breaks. | CLEAN_TEXT ({field}) |
| COLUMN_EXISTS | Returns true if the column can be found in the input data. | COLUMN_EXISTS("column name”) |
| CONCAT | Concatenates strings, fields, and functions. | CONCAT("anytext", {field1}, {field2}) |
| CONTAINS | Returns true if the field contains the specified text. | CONTAINS({field},”text”[,UNCASE_SENSITIVE]) |
| CONVERT_CURRENCY | Converts the value of one currency to another. | CONVERT_CURRENCY({price}, USD, EUR) |
| CONVERT_NUM | Converts a number to a given format... | CONVERT_NUM({field},”character decimal”,”character thousands”, number decimals) |
| COUNT_LIST | Counts the number of values in a list. | COUNT_STRING({field}) |
| COUNT_STRING | Counts the number of characters in a string. | COUNT_STRING({field}) |
| DEL_TAG | Removes one or multiple tags from a list. | DEL_TAG ({field}, “values”) |
| DO_NOT_TOUCH | Sets it so that the value of the field cannot be modified. | IF({THIS}=””,DO_NOT_TOUCH()) |
| EXISTS_CURRENT | Returns true if the record exists in Sales Layer. | EXISTS_CURRENT() |
| EXTRACT_NUMBER | Extracts a number from within a text. | EXTRACT_NUMBER({field}) |
| FIRSTUPPER | Converts the first letter to uppercase. | FIRSTUPPER ({field}) |
| FORMAT | Formats a piece of text so that it conforms to a given pattern (*1). | FORMAT(“'%f”’, {field}'[, {field}, …) |
| GET_CATALOGUE_LEVEL | Returns the title of the category at a given level. | GET_CATALOGUE_LEVEL(level[,{field},”multi-category separator ”]) |
| GET_CATALOGUE_LEVEL_REFERENCE | Returns the reference of the category at a given level. | GET_CATALOGUE_LEVEL_REFERENCE(level[,”multi-category separator”]) |
| GET_CATALOGUE_PATH | Returns the path of the category. | GET_CATALOGUE_PATH(“delimiter”[,”multi-category separator”]) |
| GET_CATALOGUE_PATH_REFERENCES | Returns all the references of the path of the category. | GET_CATALOGUE_PATH_REFERENCES(“delimiter”[,”multi-category separator”]) |
| GET_CELL_VALUE | Returns the value of a cell in a table field, given the row and column coordinates. | GET_CELL_VALUE({field}, "row2", "column2") |
| GET_COLUMN_VALUE | Returns the incoming value of a column or field. | GET_COLUMN_VALUE(“column”|{field}) |
| GET_CREATION_DATE | Returns the items' creation date. | GET_CREATION_DATE([“format”]) |
| GET_CURRENT | Returns the current value of the field. | GET_CURRENT({field}) |
| GET_FIELD_TITLE | Returns the field title. | GET_FIELD_TITLE({field}) |
| GET_INPUT_VALUE | Returns the new input value of a field. | GET_INPUT_VALUE({field}) |
| GET_LANG() | Returns the language of the formula. | GET_LANG() |
| GET_LANGUAGE_VALUE | Returns the value of a field in the specified language. | GET_LANGUAGE_VALUE({field},”language”) |
| GET_LAST_TIME | Returns the time/date in UNIX format of the last call. | GET_LAST_TIME() |
| GET_LIST_VALUE | Returns a value from a list. | GET_LIST_VALUE({field [,position] |
| GET_TIME | Returns the date in UNIX format. | GET_TIME([{field}]) |
| GET_VARIANTS_VALUES | Returns the values, separated by a character(s), of a field from a table that is dependent on the current one (the default other table is Variants). | GET_VARIANTS_VALUES({field},”linked field”,”field to concatenate”[,”separator”,”dependent table”,true|false, true|false] |
| IF | Conditional | IF(condition, action if true[, action if false]) |
| INSERT_IN_TABLE | Inserts or updates content of a table field with incoming data. | INSERT_IN_TABLE("insert" , "row1", "column1", 4000, "", "column2", 5000, 1, 1, 2000) |
| IS_EMPTY | Checks if a field is empty or not. | IS_EMPTY({field}) |
| IS_HTML | Returns true if the field contains HTML tags. | IS_HTML ({field}) |
| IS_JSON | Returns true if the field contains JSON. | IS_JSON ({field}) |
| IS_LIST | Checks if the field is a list (separated by “,”). | IS_LIST({field}) |
| IS_MODIFYED_LATER | Returns true if the item has been modified after the given date. | IS_MODIFYED_LATER(“date”) |
| IS_NUMBER | Check if the value is numerical. | IS_NUMBER({field}) |
| IS_SIMILAR | Returns true if the given fields or strings are identical. | IS_SIMILAR({field},{field}[,FIT_SIMILAR | FIT_SONORITY]) |
| IS_STRING | Returns true if the field is a string. | IS_STRING({field}) |
| IS_TRUE | Returns true if the value contains true. | IS_TRUE({field}) |
| IS_XML | Returns true if a field is XML. | IS_XML({field}) |
| JSON_SPLIT | Separates a string into a JSON list, based on a string value separator. | JSON_SPLIT({field},”string separator”[, REGEX | CASE_SENSITIVE | CASE_INSENSITIVE]) |
| LIST_CONTAINS | Returns true if the list contains the specified text. | LLIST_CONTAINS({field},”text” | [item1, item2...] [,UNCASE_SENSITIVE]) |
| LIST_REPLACE | Replaces the value for one(s) from a list. |
LIST_REPLACE({field}, [[value, replacement],[value, value, value, replacement], ...], FIT_SIMILAR, ‘default value’) options: FIT_EXACT, FIT_SIMILAR, FIT_SONORITY |
| LOWERCASE | Converts the text to lowercase. | LOWERCASE ({field}) |
| MATH | Mathematical calculation. | MATH(formula) |
| MONEY_FORMAT | Passes the value into the format of the specified international currency. | MONEY_FORMAT({price}, ‘en_US’) |
| Prints the content of the field. | PRINT({field}) | |
| PRINT_TABLE_FIELD | Formats and prints the contents of a table field. | PRINT_TABLE_FIELD({field}, "JSON", [FIRST_ROW_AS_COLUMN_TITLES]) |
| QUALITY_SCORE | Returns the Quality Score calculated with the fields exported on the connector. | QUALITY_SCORE() |
| RANDOM | Returns a random number. | RANDOM(number[,number max]) |
| REGEX_EXTRACT | Extracts a text fragment from the value using a regular expression. | REGEX_EXTRACT({field},”regular expression”) |
| REGEX_MATCH | Returns true if the string matches the regular expression. | REGEX_MATCH({field},”regular expression”) |
| REGEX_REPLACE | Replace a pattern with a text. | REGEX_REPLACE({field},”regular expression”, “text”) |
| REMOVE_FROM_LIST | Deletes the item from the current data list. | REMOVE_FROM_LIST() |
| REMOVE_IN_TABLE | Delete a list of rows or columns. | REMOVE_IN_TABLE("columns", ["column1","column2"]) |
| REPEAT | Repeats one string at the end or the beginning of another. | REPEAT({field}, “string to be repeated”, number of repetitions [,LEFT | RIGHT]) |
| REPLACE | Replaces one string with another. | REPLACE ({field}, “original string”, “new string”[, UNCASE_SENSITIVE]) |
| REPLACE_FROM_TABLE | Replaces the value of the field with another from an external table via the field that links them. | REPLACE_FROM_TABLE({field},”external table”,{linked field},{field output} [, “default value”,CASE_SENSITIVE | UNCASE_SENSITIVE, “separator”]) |
| REPLACE_TAGS_FOR_VALUES | Replace the defined tags with the specified values. | REPLACE_TAGS_FOR_VALUES({campo}, “etiqueta 1”,”valor 1” [,”etiqueta2”, “valor2,...]) |
| ROUND | Rounds a numerical value. | ROUND({field}[, number of decimals]) |
| SPLIT | Splits a string on a character or fragment. | SPLIT({field},”separator” [, REGEX | CASE_SENSITIVE | CASE_INSENSITIVE]) |
| STANDARD_NUMBER | Converts a number from the national format into the common standard. | STANDARD_NUMBER({field}) |
| SUBSTR | Extracts a fragment from a string. | SUBSTR ({field} [, start position] , end position) |
| TABLEGROUP | Converts items from a related table into an HTML table or JSON. | TABLEGROUP ( “table | JSON | list”, {subtable}, “Field name 1”, {field 1}, “Field name 2”, {field 2}, … ) |
| TEXT_LANG | Returns a text in the appropriate language from a given list. | TEXT_LANG([[lenguaje 1,texto 1],[lenguaje 2, texto 2]]...) |
| {THIS} | Value of the field where the formula is being applied. | {THIS} |
| TO_DATE | Converts a number or expression into a date. |
TO_DATE({timestamp} [, “date format”]) TO_DATE(“+1 day”) |
| TO_GMT_DATE | Converts a number or expression into a GMT date. | TO_GMT_DATE({field} [, “date format”, “time zone”] |
| TO_HTML | Converts a text string to HTML. | TO_HTML({field}) |
| TO_HTML_TABLE | Converts a string in JSON format to an HTML table. | TO_HTML_TABLE({field}, “css class”) |
| TO_PERCENT | Converts a number into a percentage. | TO_PERCENT(field}, max value) |
| UPPERCASE | Converts the text to uppercase. | UPPERCASE({field}) |
