Ability to set prefix/suffix values, separator formatting on custom fields (like $ or % or anything)
E
Eric Typaldos
Often times, number or formula custom fields are used to show currency amounts, percentages, as well as "thousands separator" formatting. But they can only display as plain numbers (with decimals).
Add the ability to enhance number custom fields such that users can:
- Define a prefix/suffix character or format
- Define "thousands separator" format (none, comma)
Some examples....
== Example 1 ==
Name: "Invoice Amount"
Type: Number
-- Format --
Prefix: $
Suffix: None
Separator: Comma
Example format: 100000 => $100,000
== Example 2 ==
Name: "Product Weight"
Type: Number
-- Format --
Prefix: None
Suffix: kg
Separator: Comma
Example format: 10000 => 10,000 kg
== Example 3 ==
Name: "Percentage sold"
Type: Number
-- Format --
Prefix: None
Suffix: %
Separator: None
Example format: 99 => 99%
== Example 4 ==
Name: "Days until kickoff"
Type: Formula
Formula: DAYS(NOW(),field("Kickoff Date"))
-- Format --
Prefix: None
Suffix: days to go
Separator: N/A
Example format: 56 => 56 days to go
Log In
E
Eric Typaldos
Merged in a post:
Add Formatting for $ and comma values in number custom fields and Dashboards
C
Con O'Connor
When wanting to track a $ amount on a row, we need to add an Action Custom Field...with the "Number" option.
There's no option to add a comma or $.
This translates into Dashboard Number widgets which also don't have formatting, leaving room for improvement.
Would also be nice to more easily roll up budget / $ / numbers in parent rows for all child rows.
E
Eric Typaldos
Merged in a post:
Create custom field types - currency, time, values, etc
W
Winshen Liu