Oracle APEX Tutorial 4 – Form Layout – Part 3 – Video Training

kevin.landonTechnical Tips1 Comment

Introduction

APEX gives you a lot of power and flexibility with its built in wizards. They are very good at
creating the base needs of a general application. This is true with forms. However, the wizards
create everything in the same way, which may or may not be what you want the end form to look
like. In this tutorial we will look at how to alter and better control the form’s appearance and
layout, as well as how to optimize our form somewhat. This tutorial installs it’s own sample data,
so the OEHR sample data is not required, but we reccomend you have it installed if you don’t
already. Our article on APEX Tutorial Preparation and OEHR Sample Data Install covers it’s
installation and creation of a user account for development purposes.

Part 3 – Creating Hints, Altering Item types, Label Templates and Buttons

[youtube]http://www.youtube.com/watch?v=sVBx7BFbe6M[/youtube]

High Level Steps

1) Create a Hint Region. (0:30)
2) Changing Item Types (1:42)
3) Label Templates (5:29)
4) Buttons and Bold (6:10)

Times in parenthesis are the approximate start times for those steps

Notes and Resources.

Item Types

As mentioned in the tutorials first part, the wizards create everything in a form the same way.
By altering the item type we can make the form more compact, as well as easier to use for the
end user. We have a variety of options available to us, from radio groups, to check boxes, to
select lists, as well as others. An empty field is not always the best way to get information.

Templates

We discuss the Label Templates, but make no changes in this tutorial. Any label can be altered
by it’s template setting, as well as other options. One thing of some confusion is the
difference between the templates ‘optional label with help’ and ‘required label with help’. The
main difference is that the Required Label option puts a small yellow asterik next to the label.
The number and type of label templates available vary based on which theme you selected for the
application.

Buttons

We also discuss but make no changes to the buttons in this application. Like all items in the
application, you can alter the appearance, position, label, and functionality of the buttons. We
have allowed the APEX system to place the buttons in this application, but we are free to move
them about if we wanted to.

Running for Update

This application is primarily designed to input new employees. However, if you wanted to see
how some for the conditional settings work, you need it in update form. If you wanted to do this,
you would take the URL of the page (while it’s running, not in the developers edit screen) and
to the end of it add ‘P2_EMP_ID:1’, This will force a value (1) to be assigned to the named item
(P2_EMP_ID) and you will be able to see the data associated with that record. For example, if my
URL was ‘apex.oracle.com/pls/otn/f?p=9659:2:1284393467360777225::::’ I could update a record by
editing it to be apex.oracle.com/pls/otn/f?p=9659:2:1284393467360777225::::P2_EMP_ID:1 which
would allow me to view and update the record for employee 1

Code and Entered Text

Below is the text for the Hint Region

Use this page to enter and maintain employee information.

This is the LOV for P2_EMP_PART_OR_FULL_TIME

STATIC:Full-time;F,Part-time;P

This is the LOV and Null Display Value for P2_EMP_DEPT

STATIC:SALES,ACCOUNTING,MANUFACTURING,HR
- No Assignment -

This is the LOV for P2_EMP_TELECOMMUTE.

STATIC:;Y

One Comment on “Oracle APEX Tutorial 4 – Form Layout – Part 3 – Video Training”

  1. Hi, i have a problem I am currently trying to solve. I am developing a small database for my office and I want an option on a form where I can select a date from a date picker and below that i will have receipt numbers for the date selected being displayed as a list.

    I have a tone load of receipt numbers in the database, which is why I want to narrow it down to those numbers affiliated with a particular date.

    can you guys help me out here?

Leave a Reply

Your email address will not be published. Required fields are marked *