Скачать или смотреть How to Display a Text Field as a Percentage in Oracle Apex

Learn how to convert decimal values into a well-formatted `percentage` display in Oracle Apex, improving user experience and meeting client expectations.
---
This video is based on the question https://stackoverflow.com/q/68092755/ asked by the user 'JB999' ( https://stackoverflow.com/u/13552281/ ) and on the answer https://stackoverflow.com/a/68094510/ provided by the user 'Koen Lostrie' ( https://stackoverflow.com/u/4189814/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: Oracle Apex - Display Item as a Percentage

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
Displaying a Text Field as a Percentage in Oracle Apex

In the world of Oracle Apex, presentations matter just as much as backend functionality. A common problem faced by developers is the need to display decimal values as percentages, especially when users expect to see familiar formats. For example, if a user inputs a value of 0.5, they likely want to see 50% instead. In this guide, we will walk through a practical solution to this issue, making imperative modifications to enhance user experience and meet client demands.

The Problem

The scenario here is straightforward: a text field needs to represent a value as a percentage, while the underlying database stores it as a decimal. The challenge comes when trying to display this representation dynamically and accurately within the Oracle Apex framework. The user is frustrated with the default configuration, which doesn't display the percentage in a user-friendly manner.

The Solution

Fortunately, there’s a simple and effective way to achieve this without cluttering your application with complex JavaScript or other convoluted methods. The solution involves creating a new item specifically for displaying the percentage while keeping the original decimal value intact for processing. Here’s how to implement that solution step by step:

Step 1: Create a New Item

Define the Base Item: Begin with your original item, let’s say it's called P1_COMMISSION. This is where the decimal values (e.g., 0.5) are stored in the database.

Create a Percentage Item: Introduce another item named P1_COMMISSION_PCT. This new item will display the percentage representation (e.g., 50%). Importantly, this item does not connect to any database columns.

Step 2: Hide the Original Item

Set the visibility of P1_COMMISSION to hidden, ensuring that users do not interact with the raw decimal value directly. This keeps the interface clean and focused on the percentage output.

Step 3: Add a Computation

After the form is initialized, implement a computation to automatically calculate the P1_COMMISSION_PCT value based on the original P1_COMMISSION value.

For instance:

[[See Video to Reveal this Text or Code Snippet]]

This computation ensures that the percentage display updates as soon as the value is loaded or modified.

Step 4: Add Dynamic Actions

Implement a dynamic action that triggers whenever P1_COMMISSION_PCT is changed by the user. This dynamic action will recalculate the original P1_COMMISSION based on the input provided in percentage format.

A simple way to handle this conversion is to strip the % sign and divide by 100 for the recalculation.

Conclusion

Displaying user-facing values in a familiar and intuitive format is essential for effective application design. By following the steps outlined above, you can convert decimal values into a percentage format that enhances the usability of your Oracle Apex application. This not only meets client specifications but also improves the overall user experience by providing clearer data representation.

Implement these changes to your Oracle Apex application today and transform how your users interact with numerical data from basic decimals to engaging percentages! Happy coding!