Question

Custom menu "Create window with Transfer" with sum

  • 2 November 2021
  • 1 reply
  • 244 views

Userlevel 5
Badge +11

Hello, I have created a custom menu of type "Create window with Transfer".
When the user clicks on this custom menu, I would like to display the sum of a column automatically.
Like here: 

 


Is this possible?
Thank you! 


This topic has been closed for comments

1 reply

Badge +14

Hi @TheoB ,

Action Create Window with Transfer, Create Window, but the keys from the current window will be passed to the destination window. If the destination window is prepared for data transfer, it will be populated with corresponding records.
(note: this option ONLY works if the form has been setup in the toolset to accept a transfer of information - be aware not every form is)

Please refer the documentation for more information:

Documentation

 

Suggestion: you can create a persistent custom field and create a PL/SQL Block action custom menu.

Inside the block you can implement the code to get the sum of column and update the new custom field.