Idea Summary

Oracle APEX supports number format masks for displaying values after page rendering or submission. However, during data entry, users often type plain digits without seeing the formatted result immediately.

I suggest adding a built-in option to automatically format numeric input as the user types or when the field loses focus, similar to the behavior available in many modern web applications built with PHP and React.

Examples:

• 1000 → 1,000
• 1000000 → 1,000,000
• 1234567.89 → 1,234,567.89

The formatting should follow the item's defined number format mask and NLS settings.

This enhancement would improve readability, reduce data-entry errors, and provide a more user-friendly experience, especially in ERP, accounting, and logistics applications where users frequently enter large numeric values.

Use Case

• Financial and accounting applications
• ERP and logistics systems
• Currency and quantity entry
• Improved readability during data entry
• Consistent behavior with modern web applications

Preferred Solution (Optional)

Add a new Number Field property such as:

• Auto Format Numeric Input = Yes/No

When enabled, Oracle APEX would automatically apply the item's number format mask while the user types or when the field loses focus, using the application's configured NLS decimal and group separators.