Friday, February 07, 2014

APEX 5.0 (EA): CSS Calendar

APEX 5.0 allows you to create a new Calendar type, called CSS Calendar.

The CSS Calendar is based on Full Calendar 1.6.4, at the moment of writing, the current latest production release. The creator of this JQuery plugin, Adam Shaw, is currently working on version 2. A few days ago he released beta 2. It remains to be seen which version of Full Calendar will make it in the final release of APEX 5.0.

Following the wizard in APEX allows us to add a Source for the calendar.
You can just enter a SQL query here.


In the next step you define which column contains your start date, the end date etc.


There are some nice features that come with Full Calendar, for example the integration with Google Calendar and JSON (APEX WebService URL). Another interesting feature is the export to different formats like iCal and CSV.

Finally running the page shows you the new CSS Calendar. You can change the color scheme of the calendar by changing the css.


This CSS calendar is also responsive... when you make your screen smaller the calendar automatically switches to the Week view.


The only thing that's missing with this calendar is a year view... there are people who created extensions for example here and here to offer the year view. Hopefully version 2 of FullCalendar will add the year view native. Wonder if the final release of APEX 5.0 will include the year view too...

6 comments:

  1. Thanks,
    It looks like this calendar does not exist in apex.oracle.com. Has it been dropped ? or we are going to see it in the official release ?

    ReplyDelete
  2. Thanks,

    Very Crucial feature, but it looks like it has been dropped from the release. Do you have any idea whether it is going to be included in the coming release ?

    ReplyDelete
  3. Hi Dimitri,

    How did you get the All-Day row? I'm trying to handle this on new calendar (Apex 5) but I don't see where or how set the events as All-Day.

    Regards,
    Rafael Trevisan.

    ReplyDelete
  4. I have an application that collects calendar data and I would like to be able to sync that data with a Google Calendar. Apex 5 Calendar to Google Calendar. What is are the steps to do this?
    Thanks for any direction on this.

    ReplyDelete
  5. this is good, here is a tutorial about it you should watch it.
    https://youtu.be/JI_3uCxTZsg

    ReplyDelete
  6. Excel; You can use APEX Office Print (https://www.apexofficeprint.com) together with Excel to create your calendar with data from APEX (Oracle DB)

    ReplyDelete