1. App Builder User's Guide
  2. Developing Forms
  3. Understanding Form Types

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.

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 form_ig.png follows
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:

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 form_table_ig.png follows
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.

See Also:

Creating a Form Using the Create Page Wizard

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 report_form_ig.png follows
Description of the illustration report_form_ig.png

See Also:

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.

See Also:

Parent topic: Understanding Form Types