Creating a Form

Developers can create forms using a number of wizards including the Create Application Wizard, Create Page Wizard, and Create Region Wizard.

• Creating a Form Using the Create Page Wizard
  Use the Create Page Wizard to wide variety of forms.
• Form Options When Running the Create Page Wizard
  Learn about form options when running the Create Page Wizard.
• Creating a Form Using the Create Application Wizard
  Use the Create Application Wizard to create a form.
• Creating a Form Region
  Use the Create Form Region Wizard to create a complex form region which includes multiple form items and processes.

See Also:

• "Developing Reports"

• "Managing Legacy Tabular Forms"

• "Creating a Legacy Master Detail Form"

Creating a Form Using the Create Page Wizard

Use the Create Page Wizard to wide variety of forms.

To create a form using the Create Page Wizard:

1. On the Workspace home page, click the App Builder icon.
2. Select an application.
3. Click Create Page.
4. For Create a Page:
   1. User Interface - Select a user interface for the page.
      This attribute only displays for applications using older themes for which Desktop and Mobile User Interfaces have been defined.
   2. Page Type - Select Component and then select either Form or Master Detail.

      Tip:

      Component pages provides page-level functionality and can be added multiple times within a given application such as reports, forms, charts, or calendars. Feature pages provide application-level functionality and can only be added once per application.

   3. If you select Form, select a form type:

      • Report with Form on Table

      • Report with List View on Table (Optimized for mobile apps)

      • Editable Interactive Grid

      • Form on a Table

      • Form on a Procedure

      • Form on a SQL Query

      • Form on Web Service

      • Form on a SQL Query

      • Form on a Web Service

      • Report and Form on Web Service

   4. If you select Master Detail, select a type:

      • Stacked - Creates single page master detail with editable interactive grids. With this page, users can query, insert, update, and delete values from two tables or views which are related. You choose the tables on which to build the master and detail regions.

      • Side by Side - Create a single page master detail with a master table and detail table. In addition, the page includes a searchable region on the left that displays a primary and secondary column from the master table. Use this region to select a record to display.

      • Drill Down - Creates a two page master detail creates one interactive grid on the first page for the master table and on the second page it creates a standard form (for the master) and interactive grid for the detail.

   5. Click Next.
5. What appears next depends upon the form you select. Follow the on-screen instructions.
   To learn more about an attribute, see field-level Help.

See Also:

• "Form Options When Running the Create Page Wizard"

• "Managing Master Detail Forms"

Form Options When Running the Create Page Wizard

Learn about form options when running the Create Page Wizard.

Tip:

Universal Theme - 42 is optimized to work equally well in either a mobile or desktop environment. In previous releases and in earlier themes, the Mobile user interface is based on jQuery Mobile. Oracle recommends migrating existing mobile applications to the Universal Theme as soon as possible.

Available Forms in the Create Page Wizard

The Create Page Wizard supports the following forms.

Table 10-1 Create Page Wizard — Available Forms

Form Type	Description	To Learn More
Report with Form on Table	Creates report and form on a table you select. You select the report type (Interactive Report, Interactive Grid, or Class Report). One page displays as an interactive grid. Each row provides a link to the form to enable users to update each record. Note: This wizard does not support tables having more than 127 columns. Selecting more than 127 columns generates an error.	Not applicable.
Report with a List View on Table	Optimized for mobile applications. Creates a form and list view that enables users to update a single row in a database table. You choose the table on which to build the form and select the column to be used for displaying text in the List View.	Not applicable
Editable Interactive Grid	Creates an editable interactive grid based on a table your select or a SQL query. An interactive grid presents users 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.	See "Managing Interactive Grids"and "Making an Existing Interactive Grid Editable"
Form on a Table	Creates a form that enables users to update a single row in a database table. You can choose a table on which to build a form.	Not applicable.
Form on a Procedure	Builds a form based on stored procedure arguments. Use this approach when you have implemented logic or Data Manipulation Language (DML) in a stored procedure or package.	Not applicable.
Form on a SQL Query	Creates a form based on the columns returned by a SQL query such as an EQUIJOIN.	Not applicable.
Form on Web Service	Creates a page with items based on a Web service definition. This wizard creates a user input form, a process to call the Web service, and a submit button.	See "Creating a Form on a Web Service"
Report and Form on Web Service	Creates a page with items based on a Web service definition. This wizard creates a user input form, a process to call the Web service, a submit button, and displays the results returned in a report.	See "Creating an Input Form and Report on a Web Service"

Available Master Detail Options in the Create Page Wizard

The Create Page Wizard supports the following master detail options.

Table 10-2 Create Page Wizard — Available Master Detail Options

Form Type	Description	To Learn More
Stacked	Creates a single page (or Stacked) master detail with editable interactive grids. Users can query, insert, update, and delete values from two tables or views which are related. You choose the tables on which to build the master and detail regions.	See "Creating a Stacked Master Detail Using the Create Page Wizard"
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	See "Creating a Side by Side Master Detail Using the Create Page Wizard"
Drill Down	Creates a two page (or Drill Down) master detail form. 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.	See "Creating a Two Page Drill Down Master Detail Using the Create Page Wizard"

Available Forms for Mobile Applications

In previous releases, developers selected the Mobile User Interface to optimize applications for mobile environments. The Mobile user interface is based on jQuery Mobile. If your application users an older theme and the Mobile User Interface, the Create Page Wizard supports the following forms.

Table 10-3 Create Page Wizard — Forms for Mobile Applications

Form Type	Description	To Learn More
Report with a List View on Table	Creates a form and list view that enables users to update a single row in a database table. You choose the table on which to build the form and select the column to be used for displaying text in the List View.	Not applicable
Form on a Table	Creates a form that enables users to update a single row in a database table. You can choose a table on which to build a form.	Not applicable
Form on a Procedure	Builds a form based on stored procedure arguments. Use this approach when you have implemented logic or Data Manipulation Language (DML) in a stored procedure or package.	Not applicable
Form on a SQL Query	Creates a form based on the columns returned by a SQL query such as an EQUIJOIN.	Not applicable
Form on Web Service	Creates a page with items based on a Web service definition. This wizard creates a user input form, a process to call the Web service, and a submit button.	See "Creating a Form on a Web Service"
Report and Form on Web Service	Creates a page with items based on a Web service definition. This wizard creates a user input form, a process to call the Web service, a submit button, and displays the results returned in a report.	See "Creating an Input Form and Report on a Web Service"

See Also:

"Creating a Form Using the Create Page Wizard"

Creating a Form Using the Create Application Wizard

Use the Create Application Wizard to create a form.

To create a form using the Create Application Wizard:

1. On the Workspace home page, click the App Builder icon.
2. Click the Create button.
3. Click New Application.
4. For Name, enter the name used to identify the application to developers.
5. For Appearance, accept the default Theme Style and menu layout (Vita, Side Menu), or change it by clicking the Set Appearance icon adjacent to the Appearance field.
6. To add a form, click Add Page and select then select Form.
7. On Create Form Page:
   1. Page Name - Enter a name for this page.
   2. Set Icon - Select an icon to display in the navigation menu for this page.
   3. Table - Select the table for the form.
   4. Include Report - Select Include Report to create a report and form. The first page is an interactive report. Each row provides a link to a form where users can update a record.
   5. Advanced - Expand Advanced:

      • Page Help - Enter text to be displayed when the user selects Page Help.

        Tip:

        This setting requires you select the About Page feature. If you select the About Page feature, a help icon is generated in the navigation bar with an entry for page help.

   6. Click Add Page.
8. Under Features, select features to include with the application. Features provide application-level functionality and can only be added once per application. To learn more, click the Help icon adjacent to Features.

   Tip:

   Click the Check All button to select all features.

9. Under Settings, specify settings used to generate this application. To learn more about an attribute, click the Help icon adjacent to Settings.
10. Click Create Application.

See Also:

"Creating Database Applications"

Creating a Form Region

Use the Create Form Region Wizard to create a complex form region which includes multiple form items and processes.

Tip:

Using the Create Form Region Wizard creates a complex form region which includes multiple form items and processes. Although you can create a region directly in the Rendering tree or drag a region from the Gallery, these approaches will not create these additional components.

To create a form using the Create Form Region Wizard:

1. View the page in Page Designer:
   1. On the Workspace home page, click the App Builder icon.
   2. Select an application.
   3. Select a page.
   Page Designer appears.
2. Locate the Page Designer Toolbar at the top of the page.
3. On Page Designer Toolbar, click the Create menu and select Form Region.

   The Create Region Wizard appears.

4. On Create Form Region:
   Options include:
   1. Select the type of form you wish to create. Options include:

      • Form on a Table

      • Form on a SQL Query

      • Form on a Procedure

      • Form on a Web Service

   2. Click Next.
5. What appears next depends upon the form region. Follow the on-screen instructions.