Creating a New Calendar

How you create a calendar depends on if you are adding a calendar to an existing page or adding a calendar on a new page. When creating calendars remember:

You can only create one calendar for each page. The calendar includes daily, weekly, and monthly views.
The date column determines which days on the calendar will contain entries.
The display column defines a specific row that will display a calendar date.

Topics:

Adding a Calendar to an Existing Page
Adding a Calendar to a New Page

Tip:

In Oracle Application Express release 3.1, the Create Calendar Wizard includes a new Display Type option. Standard submits the page along with the associated request. Partial Page Refresh only refreshes the Calendar region. Once the calendar is created, the display type cannot be changed. To change the display type, you must delete the calendar and then recreate it.

Adding a Calendar to an Existing Page

Oracle Application Express supports the creation of one calendar per page.

To add a calendar to an existing page:

Navigate to the Page Definition. See "Accessing a Page Definition".
Under Regions, click the Create icon.

The Create Region Wizard appears.
Select Calendar and click Next.
Select the type of calendar you want to create and click Next:
- Easy Calendar creates a calendar based on the date column and display column you specify.
- SQL Calendar creates a calendar based on a SQL query you provide.
Follow the on-screen instructions.

Adding a Calendar to a New Page

To create a calendar on a new page:

Navigate to the Workspace home page.
Click the Application Builder icon.
Select an application.
Click Create Page.
Select Calendar and click Next.
Select the type of calendar you want to create and click Next:
- Easy Calendar creates a calendar based on the date column and display column you specify.
- SQL Calendar creates a calendar based on a SQL query you provide.
Follow the on-screen instructions.