Think APEX

This article explains how to build a complete Internal Meeting Scheduler using the APEX Calendar with dynamic UI behavior, registration tracking, and strong business validations. . Oracle APEX PL/SQL JavaScript Calendar Region Table of Contents Overview & Features Step 1 — Table Design Step 2 — Calendar Page Setup Step 3 — Calendar Attribute Mapping Step 4 — Filter Control Step 5 — Calendar Customization Step 6 — Meeting Details Popup Step 7 — Registration Handling Step 8 — Add New Meeting Step 9 — Save Meeting Logic Step 10 — Register Button Action Step 11 — Department-Based Styling Step 12 — Business Validations Overview This solution provides a structured and interactive way to manage internal meetings using Oracle APEX. Here are the key capabilities it offers: ...

Modern applications rely on One-Time Password (OTP) verification for secure authentication. These inputs are typically designed as multiple input boxes, each accepting a single character, providing a structured and user-friendly experience. Oracle APEX does not provide a native OTP input component. This article demonstrates how to build a fully configurable OTP Input Item Plugin from scratch, tested on APEX 24.2. Overview Configurable number of input boxes (1 to 12) Customizable size and colors per instance Supports numeric-only or alphanumeric input modes Auto-advance to next box after each entry Backspace moves back and clears the previous box Arrow key navigation between boxes Paste distributes characters across all boxes automatically Blur validation — empty boxes turn red when user leaves the component Page submit validation — blocks form submission if any box is empty Plugin Creation Navigation: Shared Components → Plug-ins → Create ...

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...