APEX

Hello,

First let me preface this by saying I am not an APEX expert and have been learning on the fly for the past few weeks. As a trainer for my organization it was important to have a dynamic training and events calendar with some specific features. I found a pre-packaged [Sample Calendar|http://www.oracle.com/technetwork/developer-tools/apex/application-express/packaged-apps-090453.html] application, uploaded that and have modified it to fit about 90% of my needs. Here is where I am stuck:

1. I need to change how the events sort. I need alpha sorting, ideally.

2. I currently have two different calendar groupings, soon to be three. Meaning, I have some events labelled as Training & Events and others labelled as Birthdays. I would like to color code these on my calendar so that it is clear to users what is what. I know how to change the highlighting color of all events, but not how to specify based on an identifiable column in my table.

3. I created a page to reflect event details. When you click on a given event, it redirects to another page and shows the name, date, start time, web conference and dial-in details. The problem is the latter two items are showing blank when there is data in my table. Ideas?

Any help or guidance is greatly appreciated. I am using APEX 4.2.

Thank you,
Christina