Oracle APEX - make a field conditionally required

Question

I have an item that is displayed conditionally - based on another item selection. I want to make that item non-required when hidden. What is the best way to do that?

score 6 · Accepted Answer · answered Feb 03 '20 at 17:32

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 first item is P12_JOB and the second is P12_COMMISSION, and P12_COMMISSION is only shown when P12_JOB = 'SALESMAN'. Then this Validation will do it:

As you can see there are various settings available there that you should check are appropriate for you e.g. Always Execute, Display Location.

Thanks! That was very helpful – Coding Duchess Feb 03 '20 at 18:53 — Coding Duchess, Feb 03 '20 at 18:53

Oracle APEX - make a field conditionally required

1 Answers1