You create a Websheet application by running the Create Application wizard. After you create a Websheet page, you add content either as text or data.
Topics:
To create a Websheet application:
On the Workspace home page, click the Application Builder icon.
Click the Create button.
For Method, select Websheet and click Next.
On Create Websheet:
Websheet - Identifies a unique integer value to identify the application. Application IDs between 3000 to 9000 are reserved for internal use.
Name - Enter a name to identify the application.
Allow SQL and PL/SQL - Determines whether you can define SQL tags, SQL reports, and PL/SQL sections. Select Yes or No. By default, this attribute is disabled and set to No.
Include Getting Started Guide - Select this option to include basic information about using Websheets in the first text section of the Websheet home page.
Once reviewed, you can edit or remove this text section. See "About Adding and Editing Page Sections".
Confirm your selections and click Create Websheet.
A success message appears.
To view a rendered version of your application:
Click Run Websheet.
On the Login page, enter your Websheet credentials:
Username - Enter your workspace username.
Password - Enter your workspace password.
Click Login.
By default, your Websheet credentials are the same as you workspace login credentials.
Your Websheet application appears.
Add Websheet content.
To create a Websheet application from a running Websheet:
Run a Websheet application. See "Running a Websheet".
From the Create menu, click New Websheet.
For Create Websheet:
Websheet - Identifies a unique integer value to identify the application. Application IDs between 3000 to 9000 are reserved for internal use.
Name - Enter a name to identify the application.
Description - Enter a description of your application.
Click Next.
Confirm your selections and click Create.
To view a rendered version of your application, click Run.
Your Websheet application appears.
Add Websheet content. See "About Adding and Editing Page Sections".
To view a rendered version of your application, you run or submit it to the Application Express engine.
Topics:
To run a Websheet from the Application Builder home page:
On the Workspace home page, click the Application Builder icon.
Click the Websheet Applications tab.
From the Search bar, click the View Report icon.
Locate the Websheet application in the Applications list.
Click the Run icon in the far right column.
On the Login page, enter your Websheet credentials:
Username - Enter your workspace username.
Password - Enter your workspace password.
Click Login.
Your Websheet application appears.
To run an entire application from the Application home page:
On the Workspace home page, click the Application Builder icon.
The Application Builder home page appears.
Select the Websheet application.
Click the Run icon.
On the Login page, enter your Websheet credentials:
Username - Enter your workspace username.
Password - Enter your workspace password.
Click Login.
Your Websheet application appears.
Once you complete your Websheet application, you can publish your production URL.
You can determine the URL to your Websheet application by selecting the Websheet application from the Application home page and positioning the mouse over the Run icon. The URL displays in the status bar at the bottom of the page.
Consider the following example:
http://apex.somewhere.com/pls/apex/ws?p=123:home
To learn more, see "About Publishing the Websheet Application URL".
To add a new Websheet page:
Run the Websheet application. See "Running a Websheet".
From the Create menu, select New Page.
On Create Page:
Name - Enter a page name. The page name displays as the window title and in the breadcrumb.
Page Alias - Identify the page alias. This alias enables you to link to this page. See "Linking to a Page".
Parent Page - If this page is part of a page hierarchy, select the parent page.
Click Create Page.
To copy an existing page:
Run the Websheet application. See "Running a Websheet".
From the Create menu, select New Page as a Copy.
On New Page as a Copy, enter the name of the new page.
Click Copy Page.
A success message appears.
Select one of the following:
View Current Page
View New Page
You can change the parent page by editing the Page Details. See "Editing Page Details".
On Page Details, you can change the page name, alias, parent page, or page description.
To edit page details:
Run the Websheet application. See "Running a Websheet".
From the Edit menu, select Edit Page.
One Page Details.
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.
Click Apply Changes.
A success message appears.
You delete a Websheet on the Websheet Properties page.
To delete a Websheet application:
On the Workspace home page, click the Application Builder icon.
The Application Builder home page appears.
Select the Websheet application.
The Websheet Properties page appears.
Click Delete.