Oracle APEX – make a field conditionally required

As you have probably found, you cannot just set the dependent item’s Required attribute, as this makes it required even when hidden. Instead you can create a Validation of type “Item is NOT NULL” on the dependent item, but with a server-side condition based on the value of the other item. For example, suppose the […]

Oracle APEX Bar Chart Colors (Conditional)

Step 1: Create a new blank page. Step 2: Create a bar chart region and your bar chart series query would then look something like this, ————————————————————————————— select null,STATUS as STATUS, case when STATUS = ‘VACANT’ then ‘#d1f5e0’ –light green when STATUS = ‘ALLOCATED’ then ‘#fff4dd’ –light orange when STATUS = ‘MAINTENANCE’ then ‘#fdd5cc’ –light red else […]