filmov
tv
Use Dynamic Actions To Update Data
Показать описание
This tutorial will create a dynamic action named 'CALCULATE COMMISSION'. This fires whenever the 'Job' or 'Salary' page items change. Upon change, it does two things. Firstly an AJAX call is fired that retrieves the calculated commission (based on the current values for 'Job' and 'Salary') from calling a PL SQL function. The 'Commission' page item is then set to the calculated commission. It is based on one native action ('Set Value' with a 'Set Type' of 'PL SQL Function Body').
And one dynamic action called 'GET DEPT INFORMATION'. This fires whenever the 'Department' page item changes and invokes an AJAX call that retrieves the 'Location' and 'Number of Employees' information for the selected department from the database. It uses one native action ('Set Value' with a 'Set Type' of 'SQL Statement').
And one dynamic action called 'UPDATE SALARY' is associated with the button on the page. This uses the 'Execute PL SQL Code' event type to update the employee salaries and then uses the 'Refresh' event type to show the updated values in the report.
Source Code Link
===============================================
00:00 - Introduction
01:30 - Update Salary
04:49 - Get Dept Information
08:00 - List Of Value (LOV) Calc Commission
09:01 - Calculate Commission
And one dynamic action called 'GET DEPT INFORMATION'. This fires whenever the 'Department' page item changes and invokes an AJAX call that retrieves the 'Location' and 'Number of Employees' information for the selected department from the database. It uses one native action ('Set Value' with a 'Set Type' of 'SQL Statement').
And one dynamic action called 'UPDATE SALARY' is associated with the button on the page. This uses the 'Execute PL SQL Code' event type to update the employee salaries and then uses the 'Refresh' event type to show the updated values in the report.
Source Code Link
===============================================
00:00 - Introduction
01:30 - Update Salary
04:49 - Get Dept Information
08:00 - List Of Value (LOV) Calc Commission
09:01 - Calculate Commission
0:12:17
Use Dynamic Actions To Update Data
0:08:53
Dynamic action with update record || oracle apex || Nadeem Info Tech
0:02:10
Intro to Dynamic Actions in Oracle APEX
0:01:59
Dynamic Actions
0:15:20
Dynamic Action In Oracle Apex 1 | Dynamic Action On Button To Insert Record In Oracle Apex
0:02:23
Enable Edit Mode in Interactive Grid Using Dynamic Action in Oracle APEX 21.1
0:56:18
Dive into Dynamic Actions
0:01:58
Oracle Apex Dynamic Action, Region Refresh - Part1
0:03:51
Database Column Position Change without recreate table. Move the column to any position/place.
0:06:14
Dynamic Forms & Dynamic Actions
0:08:10
Create Dependent Text Field In Oracle Apex | Dynamic Action In Oracle Apex 2
0:09:35
Salesforce Winter '21 Update How to configure Dynamic Actions in Salesforce Lightning.
0:02:13
Salesforce Dynamic Actions - How Salesforce Administrators Can Easily Control Visibility of Actions
0:01:54
Oracle APEX: Region Refresh on Modal Page Close
0:00:47
Save Interactive Grid Using Dynamic Action in oracle APEX 19.2
0:03:24
Dynamic Action On change Calculation Between two date
0:00:17
Dynamic Notch 💀#fyp #shorts #14promax #apple #ios #tech
0:04:49
Apex Confirm Message With Custom Event Dynamic Action - Oracle Apex
1:04:41
Dynamic Actions in Application Express
0:24:56
Oracle Application Express Set Value Dynamic Action
0:05:58
Oracle Apex 19.1 : Dynamic Action Part 34 [Delete a Row From Classic Report with a Dynamic Action]
0:01:00
How to create dynamic actions on the record page in your org?
0:55:41
Oracle APEX - Complete Guide to Dynamic Actions
0:06:54
Dynamic Action in Salesforce || #Salesforce #DynamicAction || AMIT SINGH
Комментарии