Overview
In legacy Construct, currency formatting was controlled via a property in the Number columns that set how currency values would be displayed.
Cloud Construct supports currency formatting through user’s locale settings and built-in number display properties on currency fields.
Updated Methodology
Approach A: Configure Display Properties in a Number Field
Add a Number column input type and configure currency display properties directly:
Edit the required WebApp.
In the WebApp Builder, access the required page’s container fields and add a Number column input for the currency field from the dataset.
Access the Number field configuration properties and configure:
displayThousandsSeparator- Show/hide thousands separator. Formatting respects regional conventions such as comma,for USD and period.for Euros, as per user’s locale.decimalPlaces- Number of decimal places; Usually 2 for currency.negativeFormat- How to display negative amounts.
Save and Preview WebApp to test the formatting.
Approach B: Separate Currency and Value Fields
To avoid locale-based display inconsistencies, create two explicit fields in the view:
Currency Field: Display the currency code or symbol, Example values: "USD", "GBP", "EUR", "$", "£", "€".
This remains constant regardless of user's locale
Stored explicitly in database (not calculated)
Value Field: Display the numeric amount. Example: 1234.56.
Separate from currency symbol
Use standard number formatting
This approach provides consistent display across all users regardless of their profile locale.