Skip Headers
Oracle® Application Express Application Builder User's Guide
Release 4.1

Part Number E21674-05
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

About AnyCo IT Department Sample Websheet Application

This section describes the sample Websheet application, AnyCo IT Department. AnyCo IT Department highlights the features and capabilities of Websheets.

Topics:

See Also:

"About Websheet Applications" to learn more about creating Websheet applications.

Running AnyCo IT Department

To run AnyCo IT Department:

  1. Log in to Oracle Application Express.

    The Workspace home page.

  2. Click the Application Builder icon.

    The Application Builder home page appears.

  3. Click AnyCo IT Department.

  4. Click the Run icon.

  5. Enter the following credentials:

    • Username - Enter your workspace username.

    • Password - Enter your workspace password.

  6. Click Login.

When run, the home page appears.

About Websheet Navigation

Every Websheet contains common navigation elements that enable you to quickly move within a page or between pages. Each Websheet page is divided into sections. You can hide and unhide a page section by clicking the arrow to the left of the Section title. In the following example, Systems Overview is hidden.

Description of websheet_nav1.gif follows
Description of the illustration websheet_nav1.gif

Using Breadcrumbs to Navigate Between Websheet Pages

A breadcrumb displays at the top of every Websheet page. Positioning the mouse over the Home breadcrumb displays a submenu of links to all the pages in the Websheet.

Description of websheet_bread.gif follows
Description of the illustration websheet_bread.gif

Understanding AnyCo IT Department

AnyCo IT Department demonstrates the following functionality:

  • Examples of ways to share text, data, and images using a Websheet pages

  • Hierarchical navigation between page sections and pages

  • Formatted text that include easily formatted links

  • Display of tabular data by creating Data Grids and displaying the content as reports, interactive report, or charts.

The following sections describe specific functionality available on each page.

Topics:

Understanding Navigation

The hierarchical tree displays at the top of the Home page enables you to navigate between Websheet pages. Click the arrow to the left of the Home breadcrumb to expand or collapse the tree. To learn more about adding navigation, see "About Navigation Sections".

Description of websheet_nav.gif follows
Description of the illustration websheet_nav.gif

To view subsections (or children) within a section, click the arrow to the left of a section name. Click Expand All to view all pages and page subsections and Reset to return the tree to the default display. To link to another page, select the page name.

Description of websheet_nav2.gif follows
Description of the illustration websheet_nav2.gif

About the Home Page

Description of websheet_home.gif follows
Description of the illustration websheet_home.gif

The AnyCo IT Department Home page contains four sections:

  • Page Navigation

  • AnyCo IT Department

  • Projects Summary

  • Systems Summary

AnyCo IT Department is a text section that includes links to other pages and an embedded image.

Projects Summary is a data grid that displays as 3D chart. Passing the cursor over a bar changes the color and displays a dollar amount.

Description of websheet_proj_sum.gif follows
Description of the illustration websheet_proj_sum.gif

Systems Summary is a report of hardware, software, and cloud services. The bottom of the section includes links to Systems Management report as well as to the Systems page.

Description of websheet_sys_sum.gif follows
Description of the illustration websheet_sys_sum.gif

About the Projects Page

Description of websheet_table.gif follows
Description of the illustration websheet_table.gif

The Project contains one section, Projects Breakdown. The Projects Breakdown section includes a link to the Project Review page and an updatable report of major IT projects.To edit a specific project, click the Edit Row icon. To add another projects, click the Add Row icon.

About the Project Review Page

Description of websheet_proj_review.gif follows
Description of the illustration websheet_proj_review.gif

The Project Review page contains two sections, Budget Review and Task Analysis. Both sections are data grids that display as different types of 3-D charts.

About the Systems Page

Description of websheet_sys_nav.gif follows
Description of the illustration websheet_sys_nav.gif

The Systems page contains three sections:

  • System (navigation)

  • System Overview

  • Purchasing Projections

System is a navigation section that includes links to the sections, Systems Overview, Systems Maintenance, and Purchasing Projections.

System Overview is a text section that includes an embedded image as well as links to other pages.

System Maintenance is a data grid that displays as a 3D horizontal chart. Passing the cursor over a bar changes the color and displays a dollar amount.

Purchasing Projections features a report of planned purchases as well as a link to the Planned Purchases Review page. To add entries, click Add Row.

About Planned Purchase Review

Description of websheet_plan_pur.gif follows
Description of the illustration websheet_plan_pur.gif

The Planned Purchase Review page contains two sections:

  • Vendor Analysis

  • Total Planned Purchases

Vendor Analysis is report of vendors.

Total Planned Purchases is a data grid that displays as 3D horizontal chart. Passing the cursor over a bar changes the color and displays a dollar amount.

About Systems Budget Review

Description of websheet_bud_alloc.gif follows
Description of the illustration websheet_bud_alloc.gif

The Systems Budget Review page contains two sections:

  • Annual Budget Allocation

  • Remaining Budget for the Year

Annual Budget Allocation is a report budget categories. To update report item, click the Edit Row icon.

Remaining Budget for the Year is a data grid that displays as 3D pie chart. Passing the cursor over a pie section displays the dollar amount. Selecting a section, removes it slightly from the pie.

Common Websheet User Interface Elements

The sections that follow describe interface elements common of all Websheets.

Topics:

About Websheet Menus

Description of websheet_nav.gif follows
Description of the illustration websheet_nav.gif

Four menus display at the top of the each Websheet:

  • Create

  • Edit

  • View

  • Administration

Many of the create and edit options within these menus are duplicated on the Control Panel that displays on the right side of the page. To learn more, see "About Websheet Applications".

About Websheet Search

The Search Websheet field displays in the upper right of each Websheet page.

Description of websheet_search.gif follows
Description of the illustration websheet_search.gif

Use Search Websheet to perform case insensitive searches of application content. To learn more, see "About Websheet Search".

About the Control Panel

The Control Panel displays on the right side of each Websheet page and includes commands available in the Create, Edit, and View menus at the top of the page. To hide or display the Control Panel, click the arrow to the right of the region title.

Description of websheet_control_panel.gif follows
Description of the illustration websheet_control_panel.gif

The Websheet Control Panel contains the following options:

About the Files Region

The Files region displays below the Control Panel. The Files region displays files currently upload to the current page. To hide or display the Control Panel, click the arrow to the right of the region title.

About the Tags Region

Use the Tags region to enter tags that identify the current page and facilitate searching. To hide or display the Tags region, click the arrow to the right of the region title.

See Also:

"Adding Tags"

About the Notes Region

The Notes region displays notes associated with current page. To hide or display the Notes region, click the arrow to the right of the region title.

See Also:

"Adding Notes"

Modifying Websheet Content

Once you understand the type of functionality available in AnyCo IT Department, the next step is to learn more about the construction of each page. Analyzing an deconstructing an application is an efficient way to speed up the learning process. If you break something, you can quickly delete the demonstration application and install it again. See "Updating a Previously Installed Sample Websheet Application".

The section that follows offers a high-level discussion of editing a Websheet. To learn more, see "About Websheet Applications".

To update a Websheet section:

  1. Run the Websheet as described in "Running AnyCo IT Department".

  2. Click the Edit icon that displays in the upper right of the section.

    Description of websheet_edit_sect.gif follows
    Description of the illustration websheet_edit_sect.gif

    The Edit Section page appears. How you edit a specific section depends upon the section type.

  3. Edit the fields provided.

  4. To change the formatting, click the Expand Toolbar icon in the upper right corner.

    Description of websheet_toolbar2.gif follows
    Description of the illustration websheet_toolbar2.gif

    The Toolbar appears. When you pass your cursor over an icon, a descriptive tooltip displays.

  5. To hide the toolbar, click the Collapse Toolbar icon.

    Description of websheet_toolbar.gif follows
    Description of the illustration websheet_toolbar.gif

  6. To save your changes, click Apply Changes.

See Also:

"About Adding and Editing Page Sections" to learn more about editing Websheets