Number format
The number format lets you format your smart number fields the way you want.
The specified format will be used to display or present the result of your calculation. Internally the field value is always stored as a number.
Currently, display formats can only be set for number fields (using a number field from the Templates) or a Custom smart number fields
Update /set via the field overview page
The most common way to update /set a display format is by accessing the configuration of the field you want to update via the field overview page. Also see Manage existing smart fields / Field overview
Click on Edit (pencil icon) next to the smart field you want to update
If you are using one of the built-in Templates you might have to switch to Expert Mode
Choose a predefined number format or use a custom pattern to e.g. add a suffix (miles, kg…🔥)
Save the configuration
Number format patterns
If your smart field is being used to store a simple number (e.g. a dollar amount), you have the following formatting options. Choose a valid format and freely use additional characters to indicate the entities (e.g. currencies, weights etc.)
You can even use emojis like 💵 💶 ⭐️ when selecting a custom format!
Format | Example field value | Displayed value | Description |
|---|---|---|---|
Default (unformatted) | 123456.789 | 123456.789 | The value will be returned as stored. |
Custom format | Be creative and combine a number format with suffixes or prefixes. | ||
| 123456.789 | 123,456.789 | Each pound sign (#) denotes a digit, the comma is a placeholder for the thousands separator, and the period is a placeholder for the decimal separator. |
| 123456.789 | 123456.79 | The value has three digits to the right of the decimal point, but the pattern has only two. The last digit will be rounded up. |
| 123.78 | 000123.780 | The pattern specifies leading and trailing zeros, because the 0 character is used instead of the pound sign (#). |
| 12345.67 | $12,345.67 | The dollar sign $ will be shown as a prefix. |
| 12345.67 | 12,345.67 EUR | The currency symbol EUR will be shown as a suffix. |
Custom pattern
Upon selecting “Custom format” you have the option to create your own pattern by combining the above options with suffixes or prefixes.
Custom pattern examples | |||
| 99.9 | 99.9% | |
| 5 | 5⭐️ | |
| 9.8 | 9.8🔥 | |
| 9.8 | 10👍 | |
When no option is selected, a default format is automatically set to unformatted.