11.1 Using a Wizard to Create a Form

Application Builder includes built-in wizards that enable you to generate forms. This section summarizes form options when using the Create Application Wizard, Create Page Wizard, and Create Region Wizard. Note that the available forms differ depending the selected application user interface (for example, Desktop and jQuery Mobile Smartphone).

See Also:

"Creating a Report Using the Create Application Wizard," "Creating a Report Using the Create Page Wizard," and "Creating a Region in Component View"

Tip:

In some wizards you select the table and in others you provide the SQL query. For assistance in writing the SQL query, click the Query Builder button. See "Building SQL Queries with Query Builder" in Oracle Application Express SQL Workshop Guide.

11.1.1 Create Page Wizard Form Options

Table 11-1 describes form options when using the Create Page Wizard. Note that the available forms options differ depending the selected user interface (for example, Desktop and jQuery Mobile Smartphone).

Table 11-1 Create Page Wizard Report Options

Page Type Description Desktop jQuery Mobile Smartphone

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.

Available

Available

Form on a Table or View

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.

Available

Available

Form on a Table with List View

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 available

Available

Form on a Table with Report

Creates two pages. One page displays a report. Each row provides a link to the second page to enable users to update each record. You can select the table on which to build the report and form.

Note: This wizard does not support tables having more than 127 columns. Selecting more than 127 columns generates an error.

Available

Available

Master Detail Form

Creates a form that displays a master row and multiple detail rows within a single HTML form. With this form, users can query, insert, update, and delete values from two tables or views. You choose the tables on which to build the master report and detail form.

See Also: "Managing Master Detail Forms"

Available

Not available

Tabular Form

Creates a form to perform update, insert, and delete operations on multiple rows in a database table. You choose the table on which to build the form.

See Also: "Managing Tabular Forms"

Available

Not available

Form on a SQL Query

Creates a form based on the columns returned by a SQL query such as an EQUIJOIN.

Available

Available

Summary Page

Creates a read-only version of a form. Use this option to create a confirmation page at the end of a wizard.

Available

Available

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 Also: "Creating a Form on a Web Service"

Not available

Available

Form and Report 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 Also: "Creating an Input Form and Report on a Web Service"

Available

Available

See Also:

"Creating a Form Using the Create Page Wizard"

11.1.2 Create Region Wizard Form Options

Table 11-2 describes form options when using the Create Region Wizard.

Table 11-2 Create Region Wizard Form Options

Page Type Description Desktop jQuery Mobile Smartphone

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.

Available

Available

Form on a Table or View

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.

Available

Available

Form on a Table with List View

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 available

Available

Form on a Table with Report

Creates two pages. One page displays a report. Each row provides a link to the second page to enable users to update each record. You can select the table on which to build the report and form.

Note: This wizard does not support tables having more than 127 columns. Selecting more than 127 columns generates an error.

Available

Available

Master Detail Form

Builds a two page report and form combination. On the first page, users select a row to update. On the second page, users can update the selected table or view and its associated detail. You choose the tables on which to build the master report and detail form.

See Also: "Managing Master Detail Forms"

Available

Not available

Tabular Form

Creates a form to perform update, insert, and delete operations on multiple rows in a database table. You choose a table on which to build the form.

See Also: "Managing Tabular Forms"

Available

Not available

Form on a SQL Query

Creates a form based on the columns returned by a SQL query such as an EQUIJOIN.

Available

Available

Summary Page

Creates a read-only version of a form. Typically used to provide a confirmation page at the end of a wizard.

Available

Available

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 Also: "Creating a Form on a Web Service"

Available

Available

Form and Report 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 Also: "Creating an Input Form and Report on a Web Service"

Available

Available

See Also:

"About Regions"

11.1.3 Creating a Form Using the Create Page Wizard

The easiest way to create a form is to use the Create Page Wizard. As described in Table 11-1, "Create Page Wizard Report Options", this wizard offers numerous form options.

To create a form using the Create Page Wizard:

  1. On the Workspace home page, click the Application 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.

    2. Select a page type - Select Form.

    3. Click Next.

  5. Select the type of form page you wish to create. See Table 11-1, "Create Page Wizard Report Options".

  6. Follow the on-screen instructions.

    To learn more about an attribute, see field-level Help. See "Viewing Field-Level Help."

11.1.4 Creating a Form Using the Create Application Wizard

Use the Create Application Wizard to create a form to update a single row in a table. This wizard enables you to choose the table on which to build the form.

To create a form using the Create Application Wizard:

  1. On the Workspace home page, click the Application Builder icon.

  2. Click the Create button.

  3. For the application type, select Desktop and click Next.

  4. For Name:

    1. Schema - Each application obtains its privileges by parsing all SQL as a specific database schema. Identify the database schema owner.

    2. Name - Enter the name used to identify the application to developers.

    3. Application - Specify an integer value that identifies the application. The application ID must be unique within your Application Express instance. Application IDs between 3000 to 9000 are reserved for internal use by Oracle Application Express.

    4. Theme - Select a theme. Themes are collections of templates used to define the layout and style of an entire application. See "Using Themes."

    5. Theme Style - Select a theme style. Theme styles are only available for newer applications such as theme 42 and 51. See "Using Theme Styles."

    6. Click Next.

    Tip:

    To create an application at this point that consists of just a login page and blank page, click Create Application.

    Next, add pages to your application.

  5. For Pages, click Add Page.

    In the Create Application - Add Page dialog:

    1. Select Page Type - Select Form.

    2. Parent Page - If applicable, select a subordinate page. To learn more about an attribute, see field-level Help.

    3. Table Name - Select a table.

    4. Click Add Page.

      The page (or pages) appear at the top of the page. To delete a page, click the Delete icon.

    5. Repeat the previous steps until all pages have been added.

    6. Click Next.

  6. Follow the on-screen instructions.

    Tip:

    To learn more about an attribute, see field-level Help. See "Viewing Field-Level Help."

See Also:

"Creating a Database Application"

11.1.5 Creating a Form in Page Designer

To create a form in Page Designer:

  1. View the page in Page Designer. See "Viewing a Page in Page Designer."

  2. Locate the Page Designer Toolbar at the top of the page.

  3. On Page Designer Toolbar, click the Create menu and select Create Form Region.

    The Create Region Wizard appears.

  4. Select the type of form you wish to create and click Next. To learn more about form options, see "Create Region Wizard Form Options."

  5. Follow the on-screen instructions.