11.2 Creating a Form
Developers can create forms using the Create Application Wizard and Create Page Wizard.
- 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 Using the Create Page Wizard
Use the Create Page Wizard to create forms on a local database or on an external data source. - Creating a Report and Form Using the Create Page Wizard
Run the Create Page Wizard to add a new page with a report and form that uses local database or on an external data source.
See Also:
Parent topic: Developing Forms
11.2.1 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. Because jQuery Mobile is desupported, you must migrate existing mobile applications to the Universal Theme.
Available Forms in the Create Page Wizard
The Create Page Wizard supports the following forms.
Table 11-1 Create Page Wizard — Available Forms
Form Type | Description | To Learn More |
---|---|---|
Form |
Creates a form that enables users to update a single row on the specified data source (Local Database, REST Enabled SQL Service, or Web Source). |
|
Editable Interactive Grid |
Creates an editable interactive grid based on the data source (internal or external) you specify. 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" |
Report with Form |
Creates a report and form based on the data source you specify. You choose the report type (Interactive Report, Interactive Grid, or Class Report) Note: This wizard does not support tables having more than 127 columns. Selecting more than 127 columns generates an error. |
Not applicable. |
List View with Form |
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 |
Form on Local 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. |
Available Master Detail Options in the Create Page Wizard
The Create Page Wizard supports the following master detail options.
Table 11-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 data source (internal or external on which to build the Stacked master detail. |
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. You choose the data source (internal or external on which to build the Side by Side master detail. |
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. You choose the data source (internal or external on which to build the Drill Down master detail. |
See "Creating a Drill Down Master Detail Using the Create Page Wizard" |
See Also:
Parent topic: Creating a Form
11.2.2 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:
See Also:
Parent topic: Creating a Form
11.2.3 Creating a Form Using the Create Page Wizard
Use the Create Page Wizard to create forms on a local database or on an external data source.
The component(s) described in this topic include built-in support for REST Enabled SQL and Web Sources which enables read and write access to remote data sources. In order to build a component on a remote data source, you must first create the application and configure the external data source.
Note:
Using the Create Page 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 Page Wizard:
See Also:
Parent topic: Creating a Form
11.2.4 Creating a Report and Form Using the Create Page Wizard
Run the Create Page Wizard to add a new page with a report and form that uses local database or on an external data source.
The component(s) described in this topic include built-in support for REST Enabled SQL and Web Sources which enables read and write access to remote data sources. In order to build a component on a remote data source, you must first create the application and configure the external data source.
Tip:
Using the Create Page 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 report and form using the Create Page Wizard:
- On the Workspace home page, click the App Builder icon.
- Select the application.
- Click Create Page.
- On Create a Page, for Page Type, Form.
- Create Page - Select Report with Form.
- For Page Attributes:
- For Navigation Preference:
- Select how you want this page integrated into the Navigation Menu. To learn more, see field-level Help.
- Click Next.
- On Data Source, select a data source. Options include:
-
Local Database - Data is sourced from a local database.
-
REST Enabled SQL Service - Data is sourced from a remote database where the connection is defined using a REST Enabled SQL service.
-
Web Source - Data is sourced from an arbitrary REST Service (Oracle or non-Oracle) using Web Source Modules.
-
- What displays next changes based on your selection. Follow the on-screen instruction. To learn more about an attribute, see field-level Help.
Parent topic: Creating a Form