Number Formatting

For better formatting of numbers you can use helper functions. The following examples are run on this JSON

{
    "number1": 1.5,    
    "number2": 1000.457
}
CODE

Examples

{{ FormatCurrency number1 }}
-> $1.50

{{ FormatNumber number1 'N0' }}
-> 2

{{ FormatNumber number1 'N1' }}
-> 1.5

{{ FormatNumber number1 'N2' }}
-> 1.50
CODE

If you need different culture formatting you can customize this as well. The default culture for number formatting is en-US.

{{ FormatCurrencyCulture number1 'de-DE'}}
-> 1,50 €
{{ FormatNumberCulture number2 'N2''de-DE' }}
-> 1.000,46    
CODE

Date & Time Formatting

There are helper function to do basic date & time formatting.

{
    "time": "2020-09-01T22:05:45.488+02:00"
}
CODE

Examples

{{ FormatDate time 'g''en-Us'}}
-> "9/1/2020 10:05 PM"

{{ OffsetTimezoneThenFormatDate time '+8''g''en-AU'}}
-> "2/9/2020 4:05 am"
CODE

The g in the examples is a format type which can be changed to the following and will be different depending on your culture.

* d :08/17/2000
* D :Thursday, August 17, 2000
* f :Thursday, August 17, 2000 16:32
* F :Thursday, August 17, 2000 16:32:32
* g :08/17/2000 16:32
* G :08/17/2000 16:32:32
* m :August 17
* r :Thu, 17 Aug 2000 23:32:32 GMT
* s :2000-08-17T16:32:32
* t :16:32
* T :16:32:32
* u :2000-08-17 23:32:32Z
* U :Thursday, August 17, 2000 23:32:32
* y :August, 2000
CODE

IF / ELSE Example

Sometimes you want to show a colored badge depending on a value being true or false. Considering the following JSON data

[
  { 
    "isActive": false,
    "company": "POWERNET"
  },
  {   
    "isActive": true,
    "company": "EXIAND"
  },
  {   
    "isActive": false,
    "company": "KYAGURU"
  },
  {
    "isActive": true,
    "company": "OATFARM"
  },
  {
    "isActive": true,
    "company": "VIAGRAND"
  }
]
CODE

In combination with the following template:


<table class="aui">
{{#.}}
    <tr>        
        <td>{{company}}</td>
        <td>
            {{#isActive}}
                <span class="aui-lozenge aui-lozenge-removed">Inactive</span>
            {{/isActive}}
            {{^isActive}}
                <span class="aui-lozenge aui-lozenge-success">Active</span>
            {{/isActive}}
        </td>
    </tr>
{{/.}}
</table>
CODE

{{#isActive}} is the IF part and {{^isActive}} refers to the ELSE part

The result will look like this:

In case you need to compare the value of your data source you can use the following helper function to achieve a similar result:


<table class="aui">
{{#.}}
    <tr>        
        <td>{{company}}</td>
        <td>
            <span class="aui-lozenge aui-lozenge-{{ RenderOnMatch isActive 'true''success''removed'}}">
              {{ RenderOnMatch isActive 'true''Active''Inactive'}}
            </span>
        </td>
    </tr>
{{/.}}
</table>
CODE

RenderOnMatch Example Explained

{{ RenderOnMatch field 'compare''equal''notequal'}}
CODE

This helper function compares the value compare with the value of the field and renders equal if they are equal and notequal if they are not.

SearchReplace

In case you have a text that contains line breaks like \n or \r\n and want to display those linebreaks in HTML you can use the following syntax to do so.

{{ SearchReplace field '\n''<br>' }}
CODE

or

{{ SearchReplace field '\r\n''<br>' }}
CODE

Arithmetics

There are also helper functions to do basic arithmetics in combination with formatting of the result.

The following examples are run on this JSON

{
    "number1": 6,    
    "number2": 3
}
CODE

Examples

You can add, subtract, divide and multiple decimal values.

{{ AddThenFormat number1 number2 'N1' }}
-> 9.0

{{ SubThenFormat number1 number2 'N1' }}
-> 3.0

{{ DivThenFormat number1 number2 'P1' }}
-> 50.0%

{{ MulThenFormat number2 number1 'N1' }}
-> 18.0
CODE

If you need different culture formatting you can customize this as well. The default culture for number formatting is en-US.

{{ AddThenFormatCulture number1 number2 'N1''de-DE' }}
-> 9,0

{{ SubThenFormatCulture number1 number2 'N1''de-DE' }}
-> 3,0

{{ DivThenFormatCulture number1 number2 'P2''de-DE' }}
-> 50,00%

{{ MulThenFormatCulture number2 number1 'N1''de-DE' }}
-> 18,0
CODE