Note: You must have Admin permissions to modify field settings in the Table Builder.
Number Formatting
Number formatting allows you to modify the display of number fields in TrackVia and ensure a consistent presentation throughout your application. Number formatting can be applied to Number, Percentage, and Currency fields, as well as their Calculated and Triggered variants (Calculated Number, Calculated Percentage, Calculated Currency, Triggered Number, Triggered Percentage, and Triggered Currency). Not sure what Triggered fields are? See Triggered Fields vs. Calculated Fields.
When adding or editing a numeric field in the Table Builder, admins can customize the field's format by modifying the Display Options.
Admins can customize the number of decimal places to display, from zero to six. Setting the number of decimals to display does not alter or round the underlying value in the database. For example, with "Set Decimal Places" set to 0, a number whose underlying value is 1.333 will display as "1" — but the underlying value of 1.333 remains intact, ensuring accuracy in any further calculations.
Additionally, a country-based number format can be selected in the Display Options, and further customized by choosing whether to display comma separators for large numbers.
Currency Formatting
Currency field types have additional customization options, including the ability to select a preferred currency. A single table can have one currency field output in Yen and another in US Dollars. These settings apply to Currency, Calculated Currency, and Triggered Currency fields.
Min/Max Validation
Number field types can be further customized by requiring a value to fall within a specified range, by setting minimum and maximum allowed values. This could be useful in a sales environment — for example, allowing a user to create a cost quote only within a predefined range to ensure profitability.
Minimum and maximum values can also be used to enforce a specific character length. For example, a Number field can be used to enter a year. To ensure four digits are entered, set a minimum value of 1900 and a maximum value of 2100. To reference the year 2015, a user must enter the full year — "15" would be rejected.
Users who attempt to enter a value outside the designated range will receive an error message and be prevented from saving the record.
Comments
0 comments
Article is closed for comments.