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

  • ADRIAN said: OHH MY BAD IT HAVE PUT IT IN THE LANGUAGE THAT I AM WORKING ON . “IT IS AN ERRO ON THE CONVERSION...
  • ADRIAN said: I MA GETTING THIS ERROR WHEN I AM CREATING THE FIRST ITEM “ORA-06502: PL/SQL: erro: erro de...
  • BCD said: I am learning a lot from your tutorials. Can you do a tutorial “allowing end users to change their...
  • Garden Canopies said: I really like your style, the particular fact that your site is a tad bit different tends to...
  • Dane said: Another question: You will have to use the runtime environment ONLY to accomplish this?

Calendar

September 2010
M T W T F S S
« Jul    
 12345
6789101112
13141516171819
20212223242526
27282930  

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