N O T I C E
MSPbots WIKI is moving to a new home at support.mspbots.ai to give you the best experience in browsing our Knowledge Base resources and addressing your concerns. Click here for more info!
Page History
...
- Navigate to Widgetson the MSPbots app.
- Find the widget for customization in the My Widgets tab and open it using any of the following ways:
- Click the widget.
- Click the ellipsis button and select Edit.
Alternatively, you can also click the ellipsis button on the widget on your dashboard and select Edit.
- Click the widget.
- When the Widget Builder window appears, go to Dataset, click the ellipsis button, and select Edit.
- When the Dataset window appears, find the column name for customization and select the corresponding icon.
Note Ensure that you are customizing the column with Number as the selected Business Type, else the customization will not succeed.
- Click Custom on the Format pop-up.
- Type your preferred format in the Custom field. Be guided by the formatting options below.
For example, if you want 10000 to be displayed as 10,000.0000, enter 0,0.0000 into the Custom field. - Click Save on the Format pop-up.
- Click Save on the Dataset window to keep your customizations.
...
Order | Field Value (Raw Format) | Formatting | Output | Description |
---|---|---|---|---|
1 | 10000 | 0,0.0000 | 10,000.0000 |
|
2 | 10000.23 | 0,0 | 10,000 |
|
3 | 10000.23 | +0,0 | +10,000 |
|
4 | -10000 | 0,0.0 | -10,000.0 |
|
5 | 10000.1234 | 0.000 | 10000.123 |
|
6 | 100.1234 | 00000 | 00100 |
|
7 | 1000.1234 | 000000,0 | 001,000 |
|
8 | 10 | 000.00 | 010.00 |
|
9 | 10000.1234 | 0[.]00000 | 10000.12340 |
|
10 | -10000 | (0,0.0000) | (10,000.0000) |
|
11 | -0.23 | .00 | -.23 |
|
12 | -0.23 | (.00) | (.23) |
|
13 | 0.23 | 0.00000 | 0.23000 | Adds five digits after the decimal point and displays the whole number |
14 | 0.23 | 0.0[0000] | 0.23 |
|
15 | 1230974 | 0.0a | 1.2m |
|
16 | 1460 | 0 a | 1 k |
|
17 | -104000 | 0a | -104k |
|
18 | 1 | 0o | 1st |
|
19 | 100 | 0o | 100th |
|
Formatting Guide for Currency
...
Order | Field Value (Raw Format) | Formatting | Output | Description |
---|---|---|---|---|
1 | 1000.234 | $0,0.00 | $1,000.23 |
|
2 | 1000.2 | 0,0[.]00 $ | 1,000.20 $ |
|
3 | 1001 | $ 0,0[.]00 | $ 1,001 |
|
4 | -1000.234 | ($0,0) | ($1,000) |
|
5 | -1000.234 | $0.00 | -$1000.23 |
|
6 | 1230974 | ($ 0.00 a) | $ 1.23 m |
|
Formatting Guide for Bytes
Order | Field Value (Raw Format) | Formatting | Output | Description |
---|---|---|---|---|
1 | 100 | 0b | 100B | Adds "B" after the number |
2 | 1024 | 0b | 1KB |
|
3 | 2048 | 0 ib | 2 KiB |
|
4 | 3072 | 0.0 b | 3.1 KB |
|
5 | 7884486213 | 0.00b | 7.88GB |
|
6 | 3467479682787 | 0.000 ib | 3.154 TiB |
|
Formatting Guide for Percentages
Order | Field Value (Raw Format) | Formatting | Output | Description |
---|---|---|---|---|
1 | 1 | 0% | 100% | Multiplies the value by 100 and adds a percent sign |
2 | 0.974878234 | 0.000% | 97.488% |
|
3 | -0.43 | 0 % | -43 % | Multiplies the value by 100 and adds a percent sign |
4 | 0.43 | (0.000 %) | 43.000 % |
|
Formatting Guide for Time
Order | Field Value (Raw Format) | Formatting | Output | Description |
---|---|---|---|---|
1 | 25 | 00:00:00 | 0:00:25 | Numbers less than 60 are displayed in the seconds section. |
2 | 238 | 00:00:00 | 0:03:58 | For numbers greater than or equal to 60 but less than 3600:
Hence, the output is 0:03:58. |
3 | 63846 | 00:00:00 | 17:44:06 | For numbers greater than or equal to 3600:
Hence, the output is 17:44:06. |
...
Order | Field Value (Raw Format) | Formatting | Output | Description |
---|---|---|---|---|
1 | 1123456789 | 0,0e+0 | 1e+9 |
|
2 | 12398734.202 | 0.00e+0 | 1.24e+7 |
|
3 | 0.000123987 | 0.000e+0 | 1.240e-4 |
|
Overview
Content Tools