5 Using Websheets

User interface elements common to all Websheets include breadcrumb sections, navigation sections, online help, search, and the Websheet control panel.

• About Websheet Applications
  Websheet applications are interactive web pages that combine text with data. You can define these highly dynamic applications in a number of ways.
• Accessing Websheets
  Users access a Websheet by loading the Websheet URL, logging in with their account credentials (username and password), and navigating to the Websheet page.
• Using Websheets
  The Websheet application interface contains various elements for quick navigation and robust text editing.
• Managing Websheet Pages
  You can add pages to a Websheet manually or copy existing pages.
• Adding and Editing Page Sections
  You can add new sections to a Websheet page with the Create menu and edit existing sections with the Edit button and Edit menu.
• Adding and Editing Text Sections
  You can create a Text section to add text to a Websheet page. You can type directly into a text section, or copy and paste content from a spreadsheet.
• Adding a Navigation Section
  Add dynamically generated navigation to subordinate pages or page sections by clicking New Section in the Create menu and create a Navigation section.
• Managing Data Grids
  Data grids are sets of data displayed in rows and columns. Data grids store data in a similar way to how spreadsheets store data. Once created, the structure can be modified as needed over time.
• Adding and Editing Data Content
  Add content to Websheets that is queried from your Oracle Database (such as data grids and reports). Note: this function requires your application’s developer to enable the Allow SQL attribute.
• Adding Data Reports
  Data reports are contributor defined queries on tables or views within the underlying Oracle Database.
• Creating Data Sections Based on a Data Grid or Report
  Add a data grid or data report to a Websheet with data sections.
• Creating Chart Sections
  You can create inline charts based upon a data grid or report.
• Understanding Markup Syntax
  You can use the following syntax for adding links to Websheet pages, page sections, external URLs, data grids, or for including SQL or SQLVALUE syntax.
• Managing Annotations
  Add commentary and additional details to a web sheet in annotations.
• Managing Websheet Applications
  From a Websheet, you can change your Websheet password, email a Websheet to another user, and print a Websheet.
• Viewing Websheets
  Use the options on the View menu to access presentation mode, view a page directory, access a page history, and view an application directory.

See Also:

"Creating Websheet Applications" in Oracle Application Express App Builder User’s Guide