# Additional Functions

### Transform

This should only be called on a Databox containing XML data and applies a pre-defined transformation to generate a display-friendly presentation of the XML data. 

Currently there is only 1 transformation designed to work with the XML returned from the **Services System Values Databox**. 

```
Transform('Transform/Services.xsl') 
```

Use this with a 'Services' System Values Databox to format details of all Services recorded in a script into an HTML table for inclusion in an email.

<div align="center"><figure><img src="/files/G16U5KAD4ehVxxNVjLUz" alt=""><figcaption></figcaption></figure></div>

This can handle an additional Standard Minute Value (SMV) column if appropriate.&#x20;

{% hint style="warning" %}
**IMPORTANT** Any changes in this area must be configured by Omfax Systems to ensure the SMV is included in the Services export (e.g. using Services2SMV template), the SMV heading text is defined in `TransformServicesStandardMinuteValue and this element is included in TransformServicesElements` in the language text.
{% endhint %}

### Date Functions

The following operate independently of the Databox value. They can only be used as a parameter to another function or after an [operator](/product-suite/admin/databox-expressions/operators-and-literals.md).

| Function |          Sample Expression          | DataBox Value |         Result        | Comments                          |
| :------: | :---------------------------------: | :-----------: | :-------------------: | --------------------------------- |
|   `Now`  | \&Format(Now,”dd MMM yyyy – HH:mm”) |               | 01 April 2010 – 09:00 | Returns the present Date and Time |
|  `Today` |     \&Format(Today, “MMM yyyy”)     |               |       April 2010      | Returns the present Date          |

### ds (Datasource)

The `ds` expression function is useful for when you want to use the value of a databox multiple times in one expression. Please see [Ds](/product-suite/admin/databox-expressions/additional-functions/ds.md).

### Numeric Functions

| Function |             Sample Expression            | DataBox Value | Result | Comments                                |
| :------: | :--------------------------------------: | :-----------: | :----: | --------------------------------------- |
|    `%`   |                 12 + 10%                 |               |  13.20 | Add n% of original value                |
|   `Rnd`  | <p>Number + Rnd format("F4")<br><br></p> |       1       | 0.8946 | Returns a random number between 0 and 1 |

### Text Functions

|     Function    |              Sample Expression             |       Databox Value       | Result                                       |                                                                                                                                         |
| :-------------: | :----------------------------------------: | :-----------------------: | -------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------- |
|      `ChCR`     |             Replace(", ", ChCR)            |       "Hello, world"      | <p>Hello<br>world</p>                        | The example replaces a comma followed by a space with a Carriage Return character                                                       |
|     `ChCRLF`    |            Replace(", ", ChCRLF)           |  "line 1, line 2, line 3  | <p>line 1<br>line 2<br>line 3</p>            | Replace comma and space with Carriage Return and Line Feed characters                                                                   |
|      `ChLF`     |  <p>Replace(", ", ChLF)      <br><br></p>  | <p>"Hello, world"<br></p> | <p>Hello<br>world</p>                        | <p>The example replaces a comma followed by a space with a Line Feed character<br></p>                                                  |
|       `ds`      |  <p>Replace(ds, 'Hello ') + ds<br><br></p> |          "world"          | Hello world                                  | This replaces the initial value with a prefix (‘Hello’) and then appends the initial value. ‘ds’ represents the original DataBox Value. |
| `HtmlLineBreak` | <p>Replace(",", HtmlLineBreak)<br><br></p> |  "line 1, line 2, line 3  | <p>line1\<br/> line2\<br/> line3<br><br></p> | <p>Html "\<br/>" text<br></p>                                                                                                           |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.keyfax.biz/product-suite/admin/databox-expressions/additional-functions.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.