6 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, signing 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.
"Creating Websheet Applications" in Oracle Application Express App Builder User’s Guide