The numeric field type is specifically designed to store numerical values. This versatile field type can be used for a wide range of numeric data, such as keeping track of the quantity of an item in an order or the number of bedrooms in a realty property.
Be mindful of the other number field types that may make more sense for your data values depending on what type of information you are looking to store:
Number slider | Number | The Number Slider field provides a visual way to track the progress of work related to a Table's record. | |
Percent | Number | The Percent field is a numeric field type with the specific purpose to capture percent values. | |
Currency | Number | A currency field formats the numeric value as a currency based on the currency selected. |
Adding a Number field
From Grid View
From Grid View
Click the + menu icon after the last column header or open the Column Menu by clicking on a column header's dropdown icon and then select "Add Field to the Right."
Select "Number" and a window will open to configure the field.
From Record View
From Record View
The fastest way to add a field from an open Record View to is simply click the + sign next to a current field to add a new field below.
See a Number field being added in Edit Record View below:
Formats
In the field settings, there are various ways to customize the number field.
Solution Manager can select the precision to display in numeric fields (up to 6 decimal places). The default precision is "1."
You can decide whether the separators within a number should follow locale-based conventions or a standardized version.
You can choose if you'd like to abbreviate large numbers, and with what abbreviation.
You can opt to include Prefix or Suffix labels that display within the field before or after the numeric value by toggling the "Include Labels" on.
You can also indicate whether or not you want to allow negative numbers or display a thousands separator.
Examples of Use
The Number field is straightforward in its applications. The Real Estate Activity Management solution in the SmartSuite Solution Library provides some relatable examples to track:
Property size (sq. ft.)
Lot size (acres)
# of Bedrooms and bathrooms
Year built
Year last renovated
