Oracle apex form multiply two values and populate field -
I have a form that has "miles travel field", which is filled by the user, as well as "rate ".
Then I want to calculate the miles traveled * rate which should populate the area "zodiac".
How can I achieve it in the Supreme?
-
To calculate on the page, without the server - you can use dynamic action ( Javascript).
- Identify: Enter a name for the action
- When: On the page labeled "Page Properties," click on "+" in the "Dynamic Action" section, click < Code> Event - Firing Event Type (Clicks, Variations, Set Focus ...),
Selection Types
andItems
- Items where the user has to click (Change, Set Focus ...), and Conditions - Correct Action: You have to select the action type "execute javascript code". In a field for code input, you must enter something like this:
$ v ('P_ITEM_NAME_FOR_Miles_Traveled') * $ v ('P_ITEM_NAME_FOR_Rate');
-
There are several ways to perform the server side (dynamic action, process, etc.), but in this situation it is not suitable. If you need it then I can describe it later.
Comments
Post a Comment