Oracle Apex create a form that is split into multiple regions

user_13674928 0
Viewed 607

I have a merchant application form that I want to split up into multiple regions so that the user only has to see one section of the application at a time. Each region is tied to the same table therefore:

  1. Each region would have to share the same primary key
  2. I only want one submission of the form items at the end of the form

I read this post Create an Apex form with multiple pages which makes it seem like an easy to do process by using the Hide and Show Region template and manually separate the form into multiple regions. The problem I'm running into is that Apex requires a primary key to be tied to each form region, but you also can not have duplicate items on the same page. Any ideas?

-- attaching the PNG of the error message here Primary Key ERR

oracle-apex forms oracle
2 Answers

To me, it looks like a single page with several regions. Doing so, you'd have only one primary key item.

Logically, you'd separate items into different regions. Each of them should use its "Server side condition" which would decide whether to render (i.e. display) that region at certain time or not. It means that it doesn't have to be a hide and show region (besides, it is always here and visible, user just decides whether to reveal its contents or not). You'd create any region type (even an ordinary HTML region).

For example:

  • the first region displays customer ID, name and address. Other regions are "hidden" because e.g. P1_ID IS NULL is met as no data has been submitted yet. Once user enters ID, name and address and submits the page, P1_ID gets its value which enables other region(s) to be displayed
  • the second region contains items about some other customer's data; it is now visible because P1_ID is no longer NULL, but 3rd region is still hidden as you didn't enter some required data in the 2nd region which would let the 3rd region to be displayed.
  • and so forth
user_90979060

Note that the post you are referring to is 6 years old. That is like medieval in apex terms - so much has changed since then.

This is a way to do it if you want multiple pages. Just create multiple pages with the same form (using the create form functionality) and depending on the functionality needed on a specific page you delete the page items you don't want to show. If a database column is not included in the form it will not be touched by the dml process. This should be relatively simple to create.

Note: if you want to get up to speed on forms, read this blog

user_41898140
Related