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 one 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.
| Code | Description | Priority | Quantity | Unit | Complete by |
|---|---|---|---|---|---|
| Exp01 | SOR with cost | 3 | 1 | N/A | 01/11/2018 14:00:00 |
This can handle an additional Standard Minute Value (SMV) column if appropriate. Any changes in this area must be configured by Omfax 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.
Other Functions
The following operate independently of the Databox value. They can only be used as a parameter to another function or after an operator.
| 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 |
| Function | Sample Expression | DataBox Value | Result | Comments |
|---|---|---|---|---|
| ds | Number * Number(ds) | 3 | 9 | ‘ds’ represents the original DataBox Value. In this example 3x3 = 9 |
| % | 12 + 10% | 13.20 | Add n% of original value | |
| Rnd | Number + Rnd format("F4") | 1 | 0.8946 | Returns a random number between 0 and 1 |
| Function | Sample Expression | DataBox Value | Result | Comments |
|---|---|---|---|---|
| ChCR | Replace(", ", ChCR) | "Hello, world" | Hello
world |
The example replaces a comma followed by a space with a Carriage Return character |
| ChCRLF | Replace(", ", ChCRLF) | "line 1, line 2, line 3 | line 1
line 2 line 3 |
Replace comma and space with Carriage Return and Line Feed characters |
| ChLF | Replace(", ", ChLF) | "Hello, world" | Hello
world |
The example replaces a comma followed by a space with a Line Feed character |
| HtmlLineBreak | Replace(",", HtmlLineBreak) | "line 1, line 2, line 3 | line1 line2 line3 |
Html "{{{<br/>}}}" text |
