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!

Dynamically calculate the total for Interactive Grid with javascript

yavaAug 6 2018 — edited Aug 9 2018

Hi, Dear experts!

Currently, we are migrating the Oracle Forms application to the APEX environment.

We are faced with one problem. In Oracle Forms, it is very simple to solve. At all. However, we do not yet understand how to repeat this in APEX.

Description:

I need dynamically calculate the total sum for one of the columns in Interactive Grid.

Many thanks to John Snyders for the excellent example in APEX IG Cookbook for 5.1.4.

However it is necessary to count the sum of not for all rows, but depending on the value in the other column of row. For example, I plan a spend time on work for several employees. Therefore, the amount must be calculated for the employee, which is indicated in the current IG’s row. The value must dynamically change as user moves through the rows from one employee to another or changes the data.

We plan each month independently, the total number of lines in IG is not more than 40… 50.

Currently there is no understanding how to change the javascript code that John suggested.

Perhaps there are other options for solving this.

Thank you!

APEX 5.14, 18.1

Example on apex.oracle.com:

Workspace: YAVA

Pass: Apex_2018

Application IG18_TEST, 15675, Page 10

Best Regards,

yava

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 6 2018

Added on Aug 6 2018

#apex-discussions

6 comments

3,157 views