# Functions: HubSpot Domain Functions Lookup-table that translates code values of the domain 'Functions' into descriptions. - Catalog: `HubSpot` - Schema: `CodeValues` - Label: Domain Functions Example: The code value 'max' means 'Will have between 2 and 100 input numbers, and will return the maximum number out of all the inputs'. - Retrieve: True ## View Columns The columns of the view `Functions` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `code` | `varchar2(240)` | Code | ☑ | Unique code within the domain. | | `description` | `varchar2(4000)` | Description | ☐ | Meaning of the unique code within the domain. | | `domain` | `varchar2(240)` | Domain | ☑ | Each domain defines a map of codes to values. | | `resource_code` | `varchar2(240)` | Resource Code | ☐ | Resource code for internationalization. | ## Values | Code | Description | |:---:|---| | `concatenate` | Joins a list of strings; the list of inputs can go from 2 up to 100 | | `contains` | Has two strings as inputs and will return true if the first input contains the second | | `is_present` | Evaluates whether an expression can be evaluated | | `max` | Will have between 2 and 100 input numbers, and will return the maximum number out of all the inputs | | `min` | Will have between 2 and 100 input numbers, and will return the minimum number of out all the inputs | | `number_to_string` | Tries to convert the input number expression to a string | | `string_to_number` | Tries to convert the input string expression to a number |