2 Using Websheets

2.3.1 Breadcrumb Sections

A breadcrumb displays at the top of every Websheet page. Click the down arrow next to the home breadcrumb to display a submenu of links to all Websheet pages. To view another page, click the child breadcrumb entry.

2.3.2 Navigation Sections

Websheets can contain multiple pages. Each navigation section includes a hierarchical tree that enables you to navigate between pages or page sections.

Click the arrows on the left to expand or collapse the tree. To link to a specific section or page, click it. Click Expand All to view all pages and page subsections. Click Reset to return the tree to the default display. To learn more, see "Adding Navigation Sections."

2.3.3 Showing and Hiding Page Sections

You can hide and show page sections. To hide and show a section, click the arrow to the left of a section name.

2.3.4 Online Help

A Help button displays in the upper right corner of each page. Clicking Help displays a small Help system that provides an overview of Websheet functionality. Available tabs include: About, Overview, Access Control, Markup Syntax, Data Grid, Application Content, and FAQ.

2.3.5 Sign out Link

To exit a running Websheet, click Sign out in the upper right corner.

2.3.6 Searching a Websheet

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

Use Search Websheet to perform case insensitive searches of application content. Search results display in a report.

Once the search results display, use the Search region on the right side of the page to control what content to search. Searchable Content options include:

• Page Name

• Page Alias

• Page Description

• Section title

• Section content

• File Name, Alias, Description

• Tags

• Notes

• Data Grid Data

To refresh the view, click the Search button.

2.3.7 Control Panel

For users with developer and administrator rights, the Control Panel displays on the right side of most Websheet pages. To hide or display the Control Panel, click the arrow to the right of the region title.

The Websheet Control Panel contains the following options:

• New Sections. See "Adding and Editing Page Sections."

• Edit Sections. See "Adding and Editing Page Sections."

• New Page. See "Adding a New Page."

• New Page as a Copy. See "Copying an Existing Page."

• Edit Page. See "Editing Page Details."

• Page Directory. See "Viewing the Page Directory."

• New Data Grid. See "Creating a Data Grid."

2.4.1 Adding a New Page

To add a new Websheet page:

1. Run the Websheet application. See "Running a Websheet."

2. From the Create menu, select New Page.

3. On Create Page:

   1. Name - Enter a page name. The page name displays as the window title and in the breadcrumb.

   2. Page Alias - Identify the page alias. This alias enables you to link to this page. See "Linking to a Page."

   3. Parent Page - If this page is part of a page hierarchy, then select the parent page.

   4. Click Create Page.

2.4.2 Copying an Existing Page

To copy an existing page:

1. Run the Websheet application. See "Running a Websheet."

2. From the Create menu, select New Page as a Copy.

3. In New Page Name, enter the name of the new page.

4. Click Copy Page.

   A success message appears.

5. Select one of the following:

   • View Current Page

   • View New Page

2.4.3 Editing Page Details

On Page Details, you can change the page name, alias, parent page, or page description.

To edit page details:

1. Run the Websheet application. See "Running a Websheet."

2. From the Edit menu, select Edit Page.

3. On the Details Page:

   • Name - Identifies the name of the page. The page name displays in the window title and in the breadcrumb.

   • Alias - A page alias enables you to create links in page sections to other pages. A page alias must be unique within an application. See "Linking to a Page."

   • Owner - Identifies the owner of the page.

   • Parent Page - Identifies the parent page. The defined parent page is used to construct breadcrumbs and navigation between pages.

   • Page Description - Descriptive text that describes the page.

4. Click Apply Changes.

   A success message appears.

2.5.1 About Page Section Types

Websheets are organized into pages which consist of containers called sections. To each Websheet page, you can add the following section types:

• Text - Display entered text, inline images, and inline reports, and links to reports, data grids, other pages, files, external URLs, and so on. You can create and modify text sections using an intuitive WYSIWIG editor. See "Adding and Editing Text Sections."

• Navigation - Add dynamically generated navigation to subordinate pages or page sections. See "Adding Navigation Sections."

• Data - Create inline reports based upon a data grid or report. See "Creating Data Sections Based on a Data Grid or Report" and "Adding Data Reports."

• Chart - Create inline charts based upon a data grid or report. See "Creating Chart Sections."

2.5.2 Editing Page Sections

To edit a page section:

1. Run the Websheet as described in "Running a Websheet."

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

   
   Description of the illustration websheet_edit_sect.png
   
   

   The Edit Section page appears.

   Tip:

   The left side of the Edit Section page lists all sections on the current page. The current section is highlighted. To access another section, select it.

3. Edit the section and click Apply Changes.

2.5.3 Deleting Page Sections

To delete a page section:

1. Run the Websheet as described in "Running a Websheet."

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

   The Edit Section page appears.

3. Click Delete.

2.5.4 Editing Section Titles and Display Order

You can change the section title or display order on the Edit Sections page.

To edit all sections:

1. Run the Websheet application. See "Running a Websheet."

2. From the Edit menu, select Edit Sections.

   The Edit Sections page appears.

   
   Description of the illustration websheet_edit_sections.png
   
   

3. To edit the section title, enter a new title.

4. To change the section order, click the Up and Down arrows adjacent to the section title.

5. Click Apply Changes.

2.6.1 Adding a Text Section

To add a text section:

1. Run the Websheet application. See "Running a Websheet."

2. From the Create menu, select New Section.

3. When prompted for the section type, select Text and click Next.

4. On Create Text Sections select either:

   • Create single text section

   • Create multiple text section from Spreadsheet

5. If you select Create single text section, specify the following:

   1. Sequence - Enter the section display sequence.

   2. Title - Enter a section title.

   3. Content - Enter text. To learn more about formatting text, see "Editing a Text Section."

   4. Click Create Section.

6. If you select Create multiple text section from Spreadsheet,specify the following:

   1. First Row Contains Column Headings - Select this option if applicable.

   2. Paste Spreadsheet Data - Paste a two column spreadsheet or other tab delimited data. The first column must contain the section title and the second column must contain the section content.

   3. Click Create Section.

   Tip:

   You can also add a new section by selecting New Section on the Control Panel.

2.6.2 Editing a Text Section

You can edit and format text sections using an intuitive WYSIWIG editor.

To edit a text section:

1. Run the Websheet as described in "Running a Websheet."

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

   
   Description of the illustration websheet_edit_sect.png
   
   

   The Edit Section page appears.

3. Edit the text in the field provided.

   Tip:

   To learn more about adding or embedding links, see "Understanding Markup Syntax"

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

   
   Description of the illustration websheet_toolbar2.png
   
   

   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 the illustration websheet_toolbar.png
   
   

6. To save your changes, click Apply Changes.

2.7.1 Adding a Navigation Section

To add a navigation section:

1. Run the Websheet application. See "Running a Websheet."

2. From the Create menu, select New Section.

3. When prompted for the section type, select Navigation and click Next.

4. For Navigation Type:

   1. Select either:

      • Page Navigation - Creates navigation of all pages in the Websheet.

      • Section Navigation - Creates navigation for all section on a page.

   2. Click Next.

5. If you select Page Navigation, specify the following:

   1. Sequence - Enter the section display sequence.

   2. Title - Enter a section title.

   3. Starting Page - Select the starting page from which to display hierarchical navigation.

   4. Maximum Levels - Select the maximum number of levels (or tree depth) to display.

   5. Order Siblings By - Select the order of siblings by column. If not defined, then the siblings are sorted by the page name.

   6. Click Create Section.

6. If you select Section Navigation, specify the following:

   1. Sequence - Enter the section display sequence.

   2. Title - Enter a section title.

   3. Click Create Section.

2.8.1 About Data Grids

You can define the structure of a data grid using column names, data sources, and basic validations, or you can create a data grid by pasting spreadsheet data. Once created, the structure can be modified as needed.

Users can alter the layout of report data by selecting columns or by applying filters, highlighting, and sorting. Users can also define breaks, aggregations, group bys, computations, and different charts. Additionally, users can create multiple variations of a data grid and save them as named reports, for either public or private viewing. You can also use the data from a data grid and include it as a chart or report within any page.

2.8.2 Creating a Data Grid

You can create a data grid by either defining the structure (that is, the column names, data sources, and basic validations), or by pasting in spreadsheet data. In addition to the defined columns, the following standard columns are always included within each data grid: owner, created by, created on, updated by, updated on, row order, and annotation (files, notes, links, and tags).

• Creating a Data Grid from Scratch

• Creating a Data Grid by Copying and Pasting Spreadsheet Data

2.8.3 Copying a Data Grid

To copy a data grid:

1. Run the Websheet application. See "Running a Websheet."

2. From the Data Grid menu, select an existing data grid.

   The data grid appears.

3. From the Manage menu, select Copy.

4. Enter a new data grid name and click Copy.

2.8.4 Viewing and Editing a Data Grid

Once you create a data grid, you can view and edit it on the Data page.

• Accessing the Data Page

• Editing Data Grid Data

• Editing Data Grid Columns Manually

• Editing Data Grid Rows Manually

• Editing a Single Data Grid Row

• Adding Annotations to a Single Data Grid Row

• Displaying Annotation Columns in a Data Grid Report

• Managing Pseudo Columns in a Data Grid Report

• Editing Data Grid Properties

• Creating a Bookmark Link to a Data Grid

2.8.4.1 Accessing the Data Page

To access the Data page:

1. Run the Websheet application. See "Running a Websheet."

2. From the Data Grid menu, select View All.

   An interactive report appears displaying all data grids.

   Tip:

   If icons display, then click the View Report icon.

   The Report view appears.

   
   Description of the illustration data_page_rpt.png
   
   

   By default, the Report view displays the data grid Name, Alias, Updated, and Updated By columns. The Embed Tag column displays the syntax used to include a link to the report or data grid from within a section of a page.

3. Select a data grid.

   The data grid appears.

   
   Description of the illustration data_grid_view.png
   
   

2.8.4.1.1 Toggling Check Boxes

When viewing a data grid, you can enable and disable check boxes. From the Manage menu, select Toggle Checkboxes. By selecting this option, check boxes display to the left of each row.

Description of the illustration data_grid_toggle.png

ws?p=100000:DG_<data grid alias> 
ws?p=100000:DG_<data grid alias>::ROW_ID:<data grid row ID>

2.8.5 Viewing the Data Grid Change History Log

The View Change History log displays a report of data grid changes. This report lists the row, column name, old value, new value, user who authored the change, and how long ago the change occurred.

To view a history of data grid changes:

1. Run the Websheet application. See "Running a Websheet."

2. From the Data Grid menu, select a data grid.

   The data grid appears.

3. From the Manage menu, select History.

2.8.6 Deleting a Data Grid

To delete a data grid:

1. Run the Websheet application. See "Running a Websheet."

2. From the Data Grid menu, select a data grid.

   The data grid appears.

3. From the Manage menu, select Delete Data Grid.

4. Confirm your selection and click Delete.

2.9.1 About Available Data Sources

Websheets can include data sources. Once defined, you can incorporate these data sources into Websheet page sections. Websheets can include the following data sources:

• Data Grids - Data grids are highly customizable, editable tabular reports. Data grids enable you to maintain data within the Websheet that is stored within the Oracle Database. See "Managing Data Grids."

• Reports - Reports are queries defined against tables or views that exist within your Oracle Database. See "Adding Data Reports."

2.9.2 Enabling Support for Creating Data Reports

To define a data report, your Websheet developer must enable the Allow SQL attribute on the Application Properties page. By default, this attribute is disabled.

2.9.3 About Incorporating Data into Websheet Pages

Data grids and data reports can be incorporated into page sections in the following ways:

• Within a data section. See "Adding Data Reports."

• Within a chart section. See "Adding a Chart Section."

• Linking to a data grid. See "Linking to a Data Grid."

• Include a single value or tabular results of queries See "Using SQL and SQLVALUE Syntax."

2.10.1 About Data Reports

Data reports, unlike data grids, are query-only and based on existing data from the Oracle Database. You can specify the table or view name and retrieve all columns or write a SQL statement to retrieve the required data.

Users can alter the layout of report data by selecting columns or by applying filters, highlighting, and sorting. Users can also define breaks, aggregations, group by, computations, and different charts. Additionally, users can create multiple variations of a data grid and save them as named reports, for either public or private viewing. You can also use the data from a data report and include it as a chart or report within any page.

2.10.2 Creating a Data Report

You can create a data report by either simply entering the table or view name, or by providing a SQL query.

To create a data report:

1. Run the Websheet as described in "Running a Websheet."

2. From the Report menu, select New Report.

   Tip:

   You can also select New Report on the Control Panel.

   The Create Report page appears.

3. For Report Source, identify how to develop your source. Options include:

   1. Table - Select Table and enter the following:

      • Table or View Name - Select the name of the table or view on which to base the report.

      • Report Name - Enter the name of the report.

      • Report Alias - Enter a report alias. A Report alias is used for linking to the Report within page sections. A Report alias must be unique within an application.

   2. SQL Query - Select SQL Query and enter the following:

      • Report Name - Enter the name of the report.

      • Report Alias - Enter a report alias. A Report alias is used for linking to the Report within page sections. A Report alias must be unique within a Websheet.

      • Query - Enter the SQL query that defines your report.

   3. Click Next.

4. Confirm your selections and click Create Report.

2.10.3 Viewing and Modifying a Data Report

To view or modify a data report:

1. Run the Websheet as described in "Running a Websheet."

2. From the Report menu, select View All.

   The Report page appears.

3. Select the report.

   The report appears.

4. To edit report attributes:

   • From the Manage menu, click Edit Attributes.

     The Report Attributes page appears.

   • Edit the attributes and click Apply Changes.

5. To edit the report query:

   • From the Manage menu, click Edit Query.

     The Report Query page appears.

   • Edit the report query and click Apply Changes to save your query.

2.10.4 Deleting a Data Report

To delete a data report:

1. Run the Websheet as described in "Running a Websheet."

2. From the Report menu, select the report.

   The report appears.

3. Select the report.

   The report appears.

4. From the Manage menu, click Edit Attributes.

   The Report Attributes page appears.

5. Click Delete.

2.11.1 Adding a Data Section to a Page

Once you create a data grid or report, you add it to a page by adding a data section.

To add a data section:

1. Run the Websheet application. See "Running a Websheet."

2. From the Create menu, select New Section.

3. When prompted for the section type, select Data and click Next.

4. Specify the following:

   1. Data Section Source - Select either Data Grid or Report.

   2. Display Sequence - Enter the section display sequence.

   3. Data Grid/Report - Select the data grid or report to be used to display the data section.

   4. Report Settings to Use - For the selected data grid or report, select the report settings to use. This selection enables you to filter the rows and columns you want to display and set the columns to display.

      Tip:

      If you do not have a saved report with the settings you need, create it now before adding the section.

   5. Title - Enter the section title.

   6. Maximum Row Count - Enter a value to define the maximum number of rows to query.

   7. Include - Select whether to add the following:

      • Add Row (available if Data Section Source is data grid)

      • Edit Row (available if Data Section Source is data grid)

      • Search Field

   8. Style - Choose a user interface style.

   9. Click Next.

5. Click Create Section.

2.11.2 Editing a Data Section

Once you have added a data report to a page, you can change the section sequence, title, and user interface style.

To edit a data section:

1. Run the Websheet as described in "Running a Websheet."

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

   The Edit Section page appears.

3. Edit the fields provided. See item Help for more details.

4. To save your changes, click Apply Changes.

2.12.1 Adding a Chart Section

To add a chart section:

1. Run the Websheet application. See "Running a Websheet."

2. Create a data grid or report. See "Managing Data Grids" and "Adding Data Reports."

3. From the Create menu, select New Section.

4. When prompted for the section type, select Chart and click Next.

5. On Select Chart Type:

   1. Select one of the following:

      • Column

      • Horizontal Bar

      • Pie

      • Line

   2. Click Next.

6. Specify the following:

   1. Chart Source - Select either Data Grid or Report.

   2. Display Sequence - Enter the section display sequence.

   3. Data Grid/Report - Select the data grid or report to be used to display the chart.

   4. Report Settings to Use - For the selected data grid or report, select the report settings to use. Use this option to filter the rows and columns you want to display.

      If you do not have a saved report with the settings you need, then create it now before adding the section.

   5. Section Title - Enter the section title.

   6. Click Next.

7. Specify the following:

   1. Chart Label - Select the column to be used as the Label.

      In Axis Title for Label, enter the title to display on the axis associated with the column selected for Label.

   2. Chart Value - Select the column to be used as the Value. If your function is a COUNT, a Value does not need to be selected.

      In Axis Title for Value, enter the title to display on the axis associated with the column selected for Value.

   3. Function - Select a function to be performed on the column selected for Value.

   4. Sort - Select the chart sort direction.

      Check Enable 3D to display the chart in 3D.

   5. Click Next.

8. On the summary page, confirm your selections and click Create Section.

2.12.2 Editing a Chart Section

To edit a chart section:

1. Run the Websheet application. See "Running a Websheet."

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

   The Edit Section page appears.

3. Edit the fields provided. See item Help for more details.

4. Click Apply Changes.

2.13.1 Linking to a Page

To include links in page sections to other pages in a Websheet, use the syntax described below. If the page exists, a link displays. If the page does not exist, a link to create the page displays. Note that the use of the page: identifier is optional.

Syntax:

[[ page: <page alias> | <link name> ]]
[[ <page alias> | <link name> ]]

Syntax Example:

[[page: home]] 
[[mypage | My Page]]

In Context Example:

One of the most colorful fish is the [[ clownfish | Clown fish]].

2.13.2 Linking to a Section

To include links to a page section, use the syntax below. If the section exists, a link displays. If the section does not exist, a link to create the section displays. Note that if the section is not prefaced by a page, it is assumed the section is on the current page.

Syntax:

[[ section: <page alias> . <page section> | <link name> ]]
[[ section: <page section> | <link name> ]]

Syntax Example Linking Within the Current Page:

[[section: clownfish | Clown Fish]] 

Syntax Example Linking to a Different Page:

[[section: fish.clownfish | Clown Fish]] 

In Context Example:

One of the most colorful fish is the [[ section: clownfish | Clown fish]].
Visit or fish page to see the [[ section: fish . clownfish | Clown fish]], also known as Nemo.

2.13.3 Linking to External URLs

To include links to external URLs in page sections, use the syntax below. Note that the use of the url: identifier is optional. To have the link open in a new browser window, use the popup prefix.

Syntax:

[[ url: <url> | <link name> ]]
[ popupurl: <url> | <link name> ]]
[[ <url> | <link name> ]]

Syntax Example:

[[url: http://www.company.com/store | commpanystore]]
[[popupurl: http://www.company.com/store | commpanystore]]
[[http://www.searchengine.com | searchengine]] 
[[http://www.searchengine.com ]] 

In Context Example:

You can buy Company software on the [[http://www.company.com/store | Company Store]] website.

2.13.4 Linking to a Data Grid

To include links to data grids within page sections, use the syntax below. You can use these links to view the data grid or to create new data.

Syntax:

[[ data grid: <datagrid alias | <link name> ]]
[[ datagrid: <datagrid alias | <link name> ]]
[[ datagrid: <datagrid alias . <saved report name (may not be private)> | <link name> ]] 

Syntax Example:

[[ data grid: todo list | To Do List ]]
[[ data grid: todo list . open todo items | To Do List ]]
[[ datagrid: todo list | To Do List ]] 

In Context Example:

Please review the [[ data grid: todo list | To Do List ]] and ensure your tasks can be accomplished by Friday.

2.13.5 Using SQL and SQLVALUE Syntax

By using SQL or SQLVALUE syntax, you can include single value and tabular results of queries against data grids or tables and views within sections of a page. The SQLVALUE tag displays the first column of the first row returned by the SQL query. Use this syntax to embed data within a sentence (for example: There are currently 5 types of cats.). For tabular results, use the SQL tag. Using SQL tag produces a searchable report. However, you can disable the search option by using the NOSEARCH syntax.

When working with data grids, there are a few more options (shown under Syntax) and a few more rules. Basic rules when writing a data grid query include:

• Enclose the data grid name or data grid alias with braces. For example:

  {Cat Facts}
  

• Enclose the data grid column names with double quotation marks. For example:

  "Type of Cat"
  

Syntax for Queries Against Tables and Views:

[[sql: <select statement> ]]
[[sql: <select statement | limit="<maximum rows>" nosearch style="<style number>" ]]
[[sqlvalue: <select statement> ]]

Syntax for Data Grid Queries:

[[sql: <select statement> ]]
[[sql: <select statement | limit="<maximum rows>" nosearch style="<style number>" edit_row add_row show_sql ]]
[[sqlvalue: <select statement> ]]
[[sqlvalue: <select statement> | show_sql ]]

In Context SQL Tag Syntax Examples:

[[sql: select ename "Employee Name", sal "Salary" from emp order by sal desc | limit="10" style="2"]].
[[sql: select "Type of Cat",
              "Estimated Population",
              "Largest Threats",
              "Top Speed",
              "Scientific Name",
              "IUCN Status",
              "Weight",
              "Study Date"
       from {Cat Facts} | add_row edit_row ]]

In Context SQLVALUE Tag Syntax Examples:

We have [[sqlvalue: select count(*) from emp]] employees in our database, 
[[sqlvalue: select count(*) from emp where deptno=10 ]] work in department 10.
We are currently tracking [[sqlvalue: select count(*) from {Cat Facts} ]] 
types of cats.

2.13.6 Advanced Data Grid Queries Rules

Advanced data grid query rules include:

• The query must reference the data grid only once to include an edit or add row link (that is, you cannot join the data grid to itself within the query).

• The first column must be the primary key of the data grid to include an edit row link (that is, the column that uniquely identifies the row of data). If the "edit_row" option is included and the query has a single select statement, the primary key column is included automatically. If the query contains multiple select statements, you can use the "APXWS_DATA_GRID_PK" substitution (always enclosed with double quotation marks) as the first column in the SELECT statement to include the primary key to include an edit row link.

• Report column names are the column name from the data grid, but can be modified using standard SQL column aliasing syntax. For example, the following displays the data from the Minimum Number column but the heading displays as Min:

  select "Minimum Number" "Min" from ...
  

• If a column name is longer than 30 characters, you only include the first 30 characters as the name. For example, use:

  "% of Estimated Lions per Regio"
  

  Instead of:

  "% of Estimated Lions per Region"
  

• To display the query that is executed, include the "show_sql" option. By including this option, the query displays above the included report. Although this is a good approach for debugging, Oracle does not recommend "show_sql" for a production application.

2.14.1 Managing Uploaded Files and Images

You can upload files and images to a Websheet page using the Files region. Once uploaded, you can display uploaded images within a page section or embed download links to files.

• Uploading Files and Images

• Including a Download Link in a Page Section

• Displaying an Uploaded Image Inline

• Editing or Deleting Uploaded Files

[[ file: < file name > | < link name > ]]
[[ file: < file alias > | < link name > ]]

[[file: myfile ]]
[[file: myfile.xls ]]
[[file: myfile | My File ]]

This [[file: parts01.xls | spreadsheet ]] documents our part numbers.

[[ image: < file name > | < properties > ]]
[[ image: < file alias > | < properties > ]]

[[image: myimage ]]
[[image: theimagename.jpg ]]
[[image: myimage | width="600" alt="my image" ]]

This diagram [[image: diagram1]] illustrates the work flow.

2.14.2 Adding Tags

Tags facilitate keyword searching within a Websheet.

• Adding Tags

• Editing Existing Tags

• Deleting Existing Tags

2.14.3 Adding Notes

This section describes how to add, edit, and delete notes. You can use notes to record user comments.

• Adding Notes

• Editing or Deleting Existing Notes

2.14.4 Viewing and Deleting Annotations

You can view and delete all Websheet annotations on the Annotations page. Annotations include uploaded files, notes, links, and tags that were either added to a Websheet page or to a specific row in a data grid.

• Accessing the Annotations Page

• Deleting Annotations

2.15.1 Changing Your Websheet Password

To change your Websheet password:

1. Log in to and run the Websheet. See "Running a Websheet."

2. From the Administration menu, select Change My Password.

   The Change Password page appears.

3. Follow the on-screen instructions and click Change Password.

2.15.2 Emailing a Websheet Page

To email a Websheet page:

1. Log in to and run the Websheet. See "Running a Websheet."

2. Locate the page you want to email.

3. Click the Email icon above the Control Panel.

   
   Description of the illustration websheet_mail_pg.png
   
   

4. On the Email Page:

   1. To - Enter the target email address.

   2. Subject - Enter a description of this email.

   3. Body - Enter the email content you want to include along with the Websheet page link.

5. Click Send.

An email link to the currently selected page is automatically included in your email message.

2.15.3 Printing a Websheet Page

To print a Websheet in printer-friendly mode:

1. Log in to and run the Websheet. See "Running a Websheet."

2. Click the Print icon above the Control Panel.

   
   Description of the illustration websheet_print.png
   
   

   The page displays in printer-friendly mode.

3. Print the page.

2.16.1 About Presentation Mode

Presentation mode enables a single Websheet page to be viewed as a presentation. Each page section displays one at a time as a slide. Users can navigate between sections by using the right and left arrow keys, by using the right and left arrow controls on the top right of the page, or by entering a section number to quickly jump to a specific section.

To view a Websheet in presentation mode, click the Presentation icon on the far right side of the page.

In Presentation mode, each page section displays as a separate page.

Use the navigation bar on the upper right of the page to scroll forward and backward from section to section. To exit Presentation mode, click the Exit icon or press ESC.

2.16.2 Viewing the Page Directory

The page history report shows old and new section content up to 4000 bytes. If the content you want to view exceeds the length of the report display, you can also query APEX$_WS_WEBPG_SECTION_HISTORY in your workspace schema.

To access the Page Directory:

1. Log in to and run the Websheet. See "Running a Websheet."

2. From the View menu, select Page Directory.

   The Page Directory displays as an interactive report. To learn more about interactive reports and using the Actions menu, see "Using Interactive Reports" and "Customizing an Interactive Report Using the Actions Menu."

   By default, the Page Directory displays in icon view.

   One page in each Websheet is designated as the home page. The home page is the starting page that displays when you run the Websheet. In Icon view, the home page displays as a page with outline of home.

3. To view the page as a report, click the View Report icon.

   By default, Report view displays the following columns: Name, Doc Type, Created, Created By, Updated On, Updated By, Parent Page, and Grand Parent Page.

2.16.3 Viewing Page History

The page history report shows old and new section content up to 4000 bytes. If the content you want to view exceeds the length of the report display, you can also query APEX$_WS_WEBPG_SECTION_HISTORY in your workspace schema.

To view the Page History report.

1. Log in to and run the Websheet. See "Running a Websheet."

2. Select a page.

3. From the View menu, select Page History.

   The Page History displays as an interactive report.

   A Search bar displays at the top of the page. Available controls include:

   • Select columns to search - Resembles a magnifying glass. Click this icon to narrow your search. To search all columns, select All Columns.

   • Text area - Enter case insensitive search criteria (wildcard characters are implied) to search for a page group by name and then click Go.

   • Go button - Executes a search or applies a filter.

   • View Icons - Displays each Websheet as a large icon.

   • View Report - Displays each Websheet as a line in a report.

   • Actions menu - Use the Actions menu to customize the report view. See "Customizing an Interactive Report Using the Actions Menu."

4. To view changes in a Calendar format, click Calendar.

2.16.4 Viewing the Websheet Directory

Use the Websheet Directory to navigate to another Websheet application.

To access the Websheet Directory:

1. Log in to and run the Websheet. See "Running a Websheet."

2. From the View menu, select Websheet Directory.

   A Search bar displays at the top of the page. Available controls include:

   • Select columns to search - Resembles a magnifying glass. Click this icon to narrow your search. To search all columns, select All Columns.

   • Text area - Enter case insensitive search criteria (wildcard characters are implied) to search for a page group by name and then click Go.

   • Go button - Executes a search or applies a filter.

   • View Icons - Displays each Websheet as a large icon.

   • View Report - Displays each Websheet as a line in a report.

   • Actions menu - Use the Actions menu to customize the report view. See "Customizing an Interactive Report Using the Actions Menu."

3. To view a Websheet:

   • In Icon view, click the appropriate icon.

   • In Report view, click the Run icon in the Actions column.