Feature Summary
The Number field is one of the basic field types in a multi-dimensional table, used to store and display numerical data. It supports custom number formats (such as decimal places, percentages, currencies, etc.) and is suitable for storing numerical information that needs to be used in calculations, such as product prices, quantities, percentages, and amounts.
Feature Description
| Feature Dimension | Description |
|---|---|
| Membership Restriction | No membership restriction |
| Version Restriction | No version restriction |
Operation Steps
Create a New Number Field
Feature Entry
Click the "+" button on the right side of the header → "Field Type" dropdown list → "Number" option
- Click the "+" button on the right side of the header
- Select the "Number" field from the pop-up Field Type list
- Enter the field name and click "OK" to complete the creation
Set Number Format
Feature Entry
Right-click the "Field Header" → "Field Settings" → "Format" option
- Right-click the number field header and select "Field Settings"
- Find the "Number Format" option in the settings panel
- Select the corresponding format type:
- Integer: The number field only displays integer content, without decimals
- Keep 1 to 9 decimal places: Based on the selected number of decimal places, the values in the number field will retain the specified decimal places
4.Click "OK" after completing the settings
Set Default Value
Feature Entry
Right-click the "Field Header" → "Field Settings" → "Default Value" option
- Right-click the number field header and select "Field Settings"
- Find the "Default Value" option in the settings panel
- Enter the preset default value, which will be automatically filled when adding a new Record
Set Thousands Separator
Feature Entry
Right-click the "Field Header" → "Field Settings" → "Default Value" option
- Right-click the number field header and select "Field Settings"
- Find the "Show Thousands Separator" option in the settings panel
- After checking Show Thousands Separator, the value will display the thousands separator
Frequently Asked Questions
Question 1: The calculation result of the percentage format number is incorrect?
- Solution: Confirm that the format settings of the number field are correct. The percentage field actually stores a decimal value (e.g., 0.5 is displayed as 50%). If it needs to be used in calculations, please confirm that the formula logic is consistent with the display format.
Notes
- Format settings only change the display effect of the number and do not affect the actual stored value or calculations
- The number field only supports storing numerical values; entering text content will be automatically ignored