Search code examples
oracle-apex-5

how to add datepicker for a field in apex5.0


i'm new to apex and struggling to add a datepicker on a date field for an interactive report.
How can i add the datepicker or make the field inputable 'DD-MM-YYYY' that will insert into the table and also add validation to make it accept only the system date?
Please help!


Solution

  • Interactive Reports are not editable in Oracle APEX 5. So, you will have to make use of Tabular Form instead of Interactive Report and then you can add DatePicker column type. You can even add custom validations to tabular forms.

    If you are using APEX 5.1, then you can take advantage of Interactive Grid which will let you edit report data and also add validations.

    There is a packaged application, "Sample Master Detail" that is shipped with APEX 5 which demonstrates these functionalities. Here are screenshots of the app and the master detail form that has an example of tabular form with editable column with date picker,

    Sample Master Detail Packaged Application

    Department Master Detail Form