9.2 Creating a Form

Developers can create forms using the Create Application Wizard and Create Page Wizard.

Note:

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.

9.2.1 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. Set Icon - Click Set Icon to select an application icon. The icon you select is used as the Favicon, the PWA icon, the Apple touch icon, and the App Builder icon.
  5. Name - Enter the name used to identify the application to developers.
  6. Appearance - Accept the default or click Set Appearance to change it.
  7. Click Add Page and select Form.
  8. 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.
  9. 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.

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

9.2.2 Creating a Form Using the Create Page Wizard

Use the Create Page Wizard to add a form page to an existing application.

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:

  1. On the Workspace home page, click the App Builder icon.
  2. Select an application.
  3. Click Create Page.
    Create a Page appears and features three tabs: Component, Feature, and Legacy Pages.
  4. Under Component, select Form.
  5. Under Page Definition:
    1. Page Number - The page number is an integer value that identifies a page within an application.
    2. Name - Specify a text name for this page.

      Tip:

      This text is also used for page Title. After page creation, you can modify the Title in Page Designer.

    3. Page Mode - Identify the page mode. To learn more, see field-level Help.
  6. Data Source - Select a Data Source for the page:
    • Local Database - Data is sourced from the local database.
    • REST Enabled SQL Service - Data is sourced from a remote database, where the connection is defined using REST Enabled SQL. To create or maintain REST Enabled SQL references, navigate to Shared Components, REST Enabled SQL.
    • REST Data Source - Data is sourced from a RESTful web service defined using REST Data Sources. To create or maintain REST Data Sources, navigate to Shared Components, REST Data Sources.

    The steps that follow differ depending upon the selected Data Source. This task assumes the Data Source is Local Database.

  7. Source Type - Specify the source of the new page. Options include:
    • Table:

      • Table/View Owner - Select the owner of the table on which you are building the page.

      • Table/View Name - Select the table or view on which the page will be based.

    • SQL Query:

      • Enter a SQL SELECT statement - Enter the SQL query.

  8. Navigation - Expand the region and enable or disable navigation. If either flag is enabled, additional attributes appear. To learn more about an attribute, see field-level Help.
    1. Use Breadcrumb - Enable to create a breadcrumb entry for this page. By default, the page name is used as breadcrumb entry name.
    2. Use Navigation - Enable to create a navigation menu entry for this page.By default, the page name is used as navigation menu name.
  9. Click Next.
  10. Primary Key Column - Select a primary key column, or accept the default.
  11. Branch Pages:
    • Branch Here on Submit - Select a page to branch to after the page processing is complete.
    • Cancel and Go To Page - Select a page to which application shall redirect, when the Cancel button is clicked.
  12. Click Create Page.

Tip:

To learn more about external data sources, see Managing REST Enabled SQL References and Managing REST Data Sources.