Can you have more than one form region in apex?
It is a limitation of the built-in Apex forms that you can only have one automated row fetch process per page, unfortunately. You can have more than one form region per page, but you have to code all the fetch and submit processing yourself if you do (not that difficult really, but you need to take care of optimistic locking etc. yourself too).
How to create a page with multiple forms?
There are various methods you can use to do this. A common one is to use OWA_OPT_LOCK.CHECKSUM to compare the record as it was when selected with as it is at the point of committing the update. Another, easier solution for the fetching part is creating a view with all the feilds that you need.
How are two tables in apex linked together?
I have two tables in APEX that are linked by their primary key. One table (APEX_MAIN) holds the basic metadata of a document in our system and the other (APEX_DATES) holds important dates related to that document’s processing. For my team I have created a contrl panel where they can interact with all of this data.
Is it possible to split a table into multiple forms?
Splitting one table’s form over several regions is perfectly possible, even using the built-in form functionality, because the region itself is just a layout object, it has no functionality associated with it. Building forms manually is quite straight-forward but a bit more work.
How to get values from a map in apex?
I have a map passed as parameter of an apex method. In this method I need to get the values of the map. Here is the apex method :
How to create a hidden page in apex?
Step-2 Create a Hidden Page Item for Region Employees created above. This region is to show the most current (last) selected employee id. Create a dynamic action for the region Employees created in step-1.
How to get selected rows in Oracle apex?
Step-2 Create a Hidden Page Item for Region Employees created above. This region is to show the most current (last) selected employee id. Create a dynamic action for the region Employees created in step-1. The above JavaScript code will set the value for P9_EMPIDS in this format (:101:102:106:103:) for multiple employee ids.