Feature Summary
The currency field is a special numeric field that automatically formats values into currency format. It supports custom currency symbols (such as ¥ for RMB, $ for USD, etc.) and is specifically designed for recording product prices, reimbursement amounts, financial data, and other finance-related scenarios.
Feature Description
| Feature Dimension | Description |
|---|---|
| Membership Restriction | No membership restriction |
| Version Restriction | No version restriction |
| Supported Currencies | RMB ¥ / USD $ and other multi-currency |
Operation Steps
Create a New Currency Field
Feature Entry
"+" button on the right side of the header → "Field Type" dropdown list → "Currency" field
- Click the "+" button on the right side of the header
- Select the "Currency" field from the pop-up field type list
- Enter the field name and click "OK" to complete the creation
Set Currency Symbol
Feature Entry
Right-click "Field Title" → "Field Settings" → "Currency" option
- Right-click the currency field title and select "Field Settings"
- Select the currency type from the "Currency" dropdown list (e.g., ¥ RMB, $ USD, etc.)
Set Decimal Places
Feature Entry
Right-click "Field Title" → "Field Settings" → "Number Format" option
- Right-click the currency field title and select "Field Settings"
- Select the number of decimal places to retain in "Number Format"
- After setting, all amounts will be automatically formatted for display
Set Default Value
Feature Entry
Right-click "Field Title" → "Field Settings" → "Default Value" option
- Right-click the currency field title and select "Field Settings"
- Enter the default value in "Default Value"
- After setting, the entered value will be displayed by default when creating a new Record in this field
FAQ
Q1: Can currency fields be used in calculations?
- Solution: Yes. Currency fields are essentially numeric fields and support participation in all formula calculations. The format settings do not affect the calculation results.
Q2: How to switch the displayed currency symbol?
- Solution: Select a new currency symbol in the field settings, and all entered amounts will automatically update their display format. The actual stored value remains unchanged.
Notes
- Currency formatting only changes the display effect and does not affect the actual stored value or calculation results
- Supports common international currency symbols and can be switched at any time
- Using with the thousands separator makes large values easier to read