Blog Archive

  • Planning with Gantt & Calendar #JoelKallmanDay

    Overview Building an app to solve a personal need is a great learning opportunity. Sometimes I plan multi-day trips and must decide among overlapping events. The annual animation festival in Annecy, France, is one example. Hundreds of talks and screenings span various venues in a lovely little lakeside locale. Another is a periodic pilgrimage to … Continue reading “Planning with Gantt & Calendar #JoelKallmanDay”

  • Only Unused Items in Grid LOV

    I saw an interesting question in the APEX discussion forum this morning asking how a Popup LOV in an interactive grid could show only the items that were not already referenced in the grid. It’s a question I’d asked myself multiple times before, but one whose answer I hadn’t researched until today… My solution combines … Continue reading “Only Unused Items in Grid LOV”

  • Multilevel Story Approvals

    Oracle APEX lets low-coders easily automate human approvals. With a bit of coordination logic, you can manage multi-step ones, too. Read on to learn how a company gets stories for their corporate website approved by all the required stakeholders before publishing. You’ll find the link to download and try the sample app at the end. … Continue reading “Multilevel Story Approvals”

  • Parent/Child Validation Made Easy

    When working with parent/child data, an app often needs to validate an aggregate condition about all of the child rows related to a parent row. For example, say each teammate assigned to an action item can have a role of “Lead” or “Member”. Some typical parent/child validations for an action item’s team members might require … Continue reading “Parent/Child Validation Made Easy”

  • Bulk Data Loading from a Zip

    A friend is learning APEX to automate his business mentoring athletes. In his practice, he captures training performance metrics, then needs to analyze clients’ progress toward their goals over time. His instruments record an athlete’s performance data in a comma-separated values (CSV) format. Recently, he asked if APEX could load data from a CSV file. … Continue reading “Bulk Data Loading from a Zip”