In modern business applications, role-based input restrictions are common. For example: Certain users can select only a limited number of options in multi-select fields. Others have no restriction. Sometimes, selection depends on another field value, like a designation. Implementing such dynamic validations in Oracle APEX can be done efficiently using JavaScript functions combined with Dynamic Actions, keeping logic reusable and maintainable. Key Components Global Validation Function: A single JavaScript function that validates any multi-select LOV based on a controlling field (e.g., designation). Dynamic Action on LOV Items: Executes the validation function whenever a user changes selection. Safety Dynamic Action on Controlling Field: Clears dependent LOVs if the controlling value changes to prevent invalid data. Benefits: Centralized and reusable logic...
Oracle APEX items allow Quick Picks, but they are usually static. In real-world business scenarios, we often need: Quick Picks generated dynamically Quick Picks styled for better UI Quick Picks controlled based on another item’s value Enable/Disable logic driven by business rules In this article, I’ll explain how I implemented dynamic quick picks for one date item based on another date item. 🎯 Scenario We have two Date Pickers: P5_DATE1 P5_DATE2 For P5_DATE2, I created two custom quick picks: 1️ Current Month – 1st date 2️ Next Month – 1st date 🧩 Business Logic Based on the value selected in P5_DATE1: If user selects 1st day of current month ✅ Enable "Current Month – 1st" ❌ Disable "Next Month – 1st" If user selects any other date ❌ Disable "Current Month – 1st" ✅ Enable "Next Month – 1st" Step 1: Add Custom Quick Picks in DATE2 (Post Text) In P5_DATE2 → Post Text: <span class="apex-quick-picks custom-quick-picks"> <a...