Oracle Apex. Effortless Calculations in Editable Interactive Grid: Step-by-Step Tutorial.

preview_player
Показать описание
Want to make calculations easier? Look no further! Join us as we explore Editable Interactive Grids in this engaging tutorial. We'll show you how to effortlessly perform calculations using this amazing feature. Say goodbye to complex data manipulation and hello to a user-friendly interface. Whether you're a data enthusiast, a professional, or just someone looking to simplify your work, this video is perfect for you. Discover the power of Editable Interactive Grids and revolutionize the way you crunch numbers. Watch now and take control of your data like never before!"

Feel free to make any further adjustments as needed!
#oracleapex #oracle #interactive #grid
Рекомендации по теме
Комментарии
Автор

hi this video is very helpful. I am just starting apex. I created master detail form in IG. i want serial no to auto calculate in detail block. i.e. 1st line would show 1 in serial_no database column and then on next line it should show 2 and so on.

safdarhassan
Автор

Dear Sir, I am working oracle apex Product Build 23.2.4,
I have created master and details, when I add new row in the intractive grid the application change the prevouse row calculated Values to zero in the Total_Tax, Total_Invoice, and Grand_Total
And this is the following programing steps I am using in the intactive grid details to calculate Total_Tax, Total_Invoice, and Grand_Total
I create Dynamic actions on the Quantity field
Name : Total_Tax
When Event Change
Selection Type Columns
Column(s) QUANTITY, UNIT_PRICE, V_TAX_RATE
True
Name Get_Total_Tax
Action Set Value
Set Type PL/SQL Expression

(round(nvl(:quantity, 0) * (nvl(:unit_price, 0)), 2) * (nvl(:v_tax_rate, 0) /100))
I am using the same logic for calculating Total_invoice and Grand_Total

waiting for your valuable answer

Best regards
Jamil Alshaibani

jamil
Автор

One or more errors have occurred since the page loaded. Open the Browser's JavaScript console to see the errors. I am getting this error how to fix this.

ManikantaPogula
Автор

Yahan tak to sab kr lety hein tell me how to show the result on page load

allpractical