9.1 Understanding Form Types
When creating an application, developers can create four basic form types: editable interactive grid, form, report with form, or master detail.
- Editable Interactive Grid
View an example of an editable interactive grid. - Form
View an example form. - Report with Form
View an example report with form. - Master Detail Forms
View an example master detail form.
Parent topic: Developing Forms
9.1.1 Editable Interactive Grid
View an example of an editable interactive grid.
An interactive grid presents users with a set of data in a searchable, customizable report. In an editable interactive grid, users can also add to, modify, and refresh the data set directly on the page. Functionally, an interactive grid includes most customization capabilities available in interactive reports plus the ability to rearrange the report interactively using the mouse. The following is an example of an editable interactive grid.
Description of the illustration form_ig.png
You can create an editable interactive grid with either the Create Application Wizard or Create Page Wizard by enabling the Editing Enabled flag when creating the report. In an existing interactive grid, you can make it editable by enabling the Edit, Enabled under Attributes in Page Designer.
See Also:
-
Using an Editable Interactive Grid in Oracle APEX End User’s Guide
Parent topic: Understanding Form Types
9.1.2 Form
View an example form.
Form creates a form that enables users to update a single row in a database table. The following is an example of a form on table.
Description of the illustration form_table_ig.png
Both the Create Application Wizard and Create Page Wizard support the creation of a simple form. The main difference between these two wizards is that the Create Page Wizard offers more customization and data source options. Using the Create Page Wizard, the developer has the option to select a data source (that is, Local Database, REST Enabled SQL Service, or REST Data Source). Additionally, the developer can also specify whether to include and configure breadcrumbs or a navigation menu and select the columns and the order in which they display.
Parent topic: Understanding Form Types
9.1.3 Report with Form
View an example report with form.
Both the Create Application Wizard and Create Page Wizard support the creation of a interactive report or classic report and form combination. In both wizards, you create the report and then enable a flag to add the form.
In the Create Application Wizard, you click Add Page and then select either Interactive Report or a Classic Report and then select the Include Form option.
In the Create Page Wizard, you select either Interactive Report or a Classic Report and then enable Include Form Page. The Create Page Wizard offers more customization and data source options. Using the Create Page Wizard, the developer select a data source (that is, Local Database, REST Enabled SQL Service, or REST Data Source) and also specify whether to include and configure breadcrumbs or a navigation menu.
The following is an example of an interactive report with form.
Description of the illustration report_form_ig.png
Parent topic: Understanding Form Types
9.1.4 Master Detail Forms
View an example master detail form.
A master detail form reflects a one-to-many relationship between two tables in a database. Master detail forms enable users to insert, update, and delete values from two tables or views. Typically, a master detail form displays a master row and multiple detail rows within a single HTML form. Developers can create a single page or two page master detail. You choose the tables on which to build the master and detail regions. Master Detail form options include:
- Stacked - Creates a single page master detail with editable interactive grids.
- Side by Side - Creates a single page (or Side by Side) master detail with a master table and detail table. The left side contains a master list to navigate to the master record. The right side contains the selected master record and the associated detail report.
- Drill Down - Creates a two page (or Drill Down) master detail. The first page contains an interactive report for the master table. The second page features a standard form for the master and interactive grid for the detail.
Parent topic: Understanding Form Types