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

By M&S Consulting (Kevin) on Jun 30th, 2009
Filed Under Technical Tips // Tags: ,

Introduction

APEX gives you a lot of power and flexibility with it’s 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 2 - Attributes, Alignments, Footers and Conditionals

YouTube Preview Image

High Level Steps

1) Edit the Items Attributes (0:27)
2) Alter Alignments of Items (3:22)
3) Create and Populate a new Region. (6:03)
4) Editing Header/Footer Information. (7:35)
5) Making a Region Conditional. (8:17)

Times in parenthesis are the approximate start times for those steps

Notes and Resources.

Start/Stop Table

The Start/Stop Table is the inserting of the HTML table start/end tags into the
displayed region. It forces the creation/end of an HTML table, and is one way to address
alignment problems on a page. It is not related to the data tables.

Making a region Hide/Show

One thing you can also do is give the user the ability to show or hide a given area. In this
tutorial, we can add this ability to the Audit region. We didn’t, but if you wanted to, under
Region Definitions, you can select the ‘Audit Information’ region and under the ‘User Interface’
section there is an entry for ‘Hide and Show Region’ under the template list.

Code and Entered Text

Listed Below are the final Item Attributes.

Prompt Field New Line? Width
Emp ID Yes 30
First Name Yes 15
Middle Initial No 2
Last Name No 15
Part or Full Time Yes 2
Salary Yes 10
Department Yes 15
Hire Date Yes 10
Manager No 15
Special Information Yes 60
Telecommute Yes 2
Record Create Date Yes 10
Record Update Date Yes 10

Listed below is the region footer text:

<I>The Record Create Date is the date that the record was initially entered in
to the system.
The Record Update Date is the date that the
record was last updated.</I>
Bookmark and Share

Related Information:

  1. Oracle APEX Tutorial 4 – Form Layout – Part 3 – Video Training APEX gives you a lot of power and flexibility with its built in wizards. They are very good at creating...
  2. Oracle APEX Tutorial 4 – Form Layout – Part 1 – Video Training APEX gives you a lot of power and flexibility with its built in wizards. They are very good at creating...
  3. Oracle APEX Tutorial 8 - Up and Downloading Files - Part 1 - Video Training Reports and data entry constitue the bulk of what most of these tutorials cover, and what many businesses need. However,...
  4. Oracle APEX Tutorial 2 - Parameterized Report Part 1 - Video Training This Tutorial is a guided walkthrough of section 3 of the Oracle APEX Advanced Tutorials....
  5. Oracle APEX Tutorial 6 – A Web Service – Part 2 – Video Training As the world moves forward, there is a higher need for more information. However, it is a near impossible task...
  6. Oracle APEX Advanced Tutorial 1 - Creating a Tabular Form - Video Walkthrough This tutorial is designed to walk you through section 2 of the Oracle APEX Advanced Tutorial, Creating a Tabular Form....
  7. Oracle APEX Tutorial 3 - Drilldown Report Part 1- Video Training This tutorial covers section 4 of the Oracle APEX Advanced Tutorials, Creating a drilldown report...
  8. Oracle APEX Tutorial 3 - Drilldown Report Part 2- Video Training This tutorial covers section 4 of the Oracle APEX Advanced Tutorials, Creating a Drilldown Report...

Leave a Reply


Archives

Recent Comments

  • SaintClair said: Thanks a million for this priceless material. May God richly bless you!
  • ashok.aggarwal said: Thank you for your comment, Stuart. I’m glad this helped you.
  • Stuart said: I’d really like to thank you for your post. It was really that simple.
  • ashok.aggarwal said: Your specific question is not very clear, however, in the context of implementing a LIKE...
  • Jonas said: Finally in print that a user is required to show the email option. Thanks.

Calendar

March 2010
M T W T F S S
« Feb    
1234567
891011121314
15161718192021
22232425262728
293031  

Featured Testimonial

"M&S has taken 'partnership' to a new level. They are not only a deeply skilled service provider, the M&S team is actually a mission critical component to our operations, taking on new initiatives as well as maintaining custom, open source, and COTS solutions."

CEO, MedPivot

Free SQL Service