Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Use dynamic action to update a field when another field(s) is updated

FriendlyToooSep 25 2018 — edited Sep 25 2018

Hi Folks:

I have a form that the users have to fill out seven fields (using APEX 18.1). Each field can be between 0 and 100. The seven fields in total MUST equal 100.

I created a field below called P5_TOTAL. When the other fields have a number entered into them ( the fields from P5_PROCESS_LOSS to P5_UNACCOUNTED_FOR) I want to add them up and enter the total into the P5_TOTAL field.

If the user changes a field, then on change it should recalculate and change the number in the P5_TOTAL Field. I am very new to dynamic actions. I figured this would need to be a change event. I added the necessary ITEMS under "Items".

Is that right so far? and what do I do next to tell apex to add them and put the total into the P5_TOTAL item? Thank you so much for any advice/help.

update_field.PNG

This post has been answered by askMax - Maxime Tremblay on Sep 25 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 23 2018
Added on Sep 25 2018
4 comments
13,606 views