The content of pages are organized into sections. The following section types are supported:

• Text - Displays entered text which can include inline images and inline reports as well as links to reports, data grids, other pages, files, external URLs, and so on. Text sections are managed using a WYSIWIG editor.
• Navigation - Displays dynamically generated navigation to subordinate pages or page sections.
• Data - Provides an inline report based upon a data grid or report.
• Chart - Provides an inline chart based upon a data grid or report.

Data grids are contributor defined sets of tabular data - essentially a Web-based spreadsheet. You can define the structure of a data grid (column names, data types and basic validations) or you can create a data grid by pasting in spreadsheet data. Once created, the structure can be modified as needed over time.

In addition to the defined columns, a set of standard columns is always included within each data grid. These include owner, created by, created on, updated by, updated on, row order and annotations (files, notes, links and tags).

Data grids are basically editable reports that are highly customizable. Users can alter the layout of report data by choosing the columns they are interested in and applying filters, highlighting, and sorting. They can also define breaks, aggregations, group by, computations and different charts. Users can create multiple variations of a data grid and save them as named reports, for either public or private viewing.

Aside from being available under the Data tab, data within a data grid can be included as a chart or report within any page.

Reports are queries against the database objects you have access to. To define a report, you can either simply select a table or view within an available schema or create something more complex using industry standard SQL.

Just as with data grids, reports are highly customizable. Users can alter the layout of report data by choosing the columns they are interested in and applying filters, highlighting, and sorting. They can also define breaks, aggregations, group by, computations and different charts. Users can create multiple variations of the report and save them as named reports, for either public or private viewing.

Aside from being available under the Data tab, data within a report can be included as a chart or report within any page.

Within pages or rows of a data grid, you can include the following annotations:

• Files - Upload files for download or to display as an inline image within section text
• Notes - Include obvious and usually temporary notes specific to the content
• Tags - Include tags to aid in searching
• Links - Include URL links for a data grid row

An administrator controls who can login to a Websheet application by specifying one of the following authentication mechanisms:

• Public access (no authentication)
• Application Express Account
• Oracle Single Sign-On
• LDAP
• Custom

Once logged in to the application, a user's access will be governed by the role assigned to them. The supported roles include:

• Administrator
• Contributor
• Reader